Oracle Database SQL — Question 219

1. MANAGER is an existing role with no privileges or roles.
2. EMP is an existing role containing the CREATE TABLE privilege.
3. EMPLOYEES is an existing table in the HR schema.

Which two commands execute successfully? (Choose two.)

Answer options

• A. GRANT CREATE SEQUENCE TO manager, emp;
• B. GRANT CREATE TABLE, emp TO manager;
• C. GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
• D. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;
• E. GRANT CREATE TABLE, SELECT ON hr.employees TO manager;

Correct answer: A, D

Explanation

Option A is correct as it grants CREATE SEQUENCE to both MANAGER and EMP, which is valid since MANAGER has no existing privileges to conflict with. Option D is correct because it grants SELECT and INSERT on hr.employees to MANAGER with the ability to grant those privileges further, which is permissible. The other options either attempt to grant privileges that MANAGER cannot receive or incorrectly format the command.