Oracle
1Z0-071 · Question #296
Which two commands execute successfully? (Choose two.) - MANAGER is an existing role with no privileges or roles. - EMP is an existing role containing the CREATE TABLE privilege. - EMPLOYEES is an…
The correct answer is A. GRANT CREATE SEQUENCE TO manager, emp; C. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION. See the full explanation below for the reasoning.
Question
Which two commands execute successfully? (Choose two.)
- MANAGER is an existing role with no privileges or roles.
- EMP is an existing role containing the CREATE TABLE privilege.
- EMPLOYEES is an existing table in the HR schema.
Options
- AGRANT CREATE SEQUENCE TO manager, emp;
- BGRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
- CGRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;
- DGRANT CREATE TABLE, emp TP manager;
- EGRANT CREATE TABLE, SELECT ON hr.employees TO manager;
How the community answered
(27 responses)- A81% (22)
- B11% (3)
- D4% (1)
- E4% (1)
Community Discussion
No community discussion yet for this question.