Which statement is true regarding the execution of the above commands?

SCOTT is a user in the database. Evaluate the commands issued by the DBA: 1 – CREATE

ROLE mgr; 2 – GRANT CREATE TABLE, SELECT ON oe. orders TO mgr; 3 – GRANT mgr,
create table TO SCOTT; Which statement is true regarding the execution of the above
commands?

SCOTT is a user in the database. Evaluate the commands issued by the DBA: 1 – CREATE

ROLE mgr; 2 – GRANT CREATE TABLE, SELECT ON oe. orders TO mgr; 3 – GRANT mgr,
create table TO SCOTT; Which statement is true regarding the execution of the above
commands?

A.
Statement 1 would not execute because the IDENTIFIED BY <password> clause is
missing.

B.
Statement 3 would not execute because role and system privileges cannot be granted
together in a single GRANT statement.

C.
Statement 1 would not execute because the WITH GRANT option is missing.

D.
Statement 2 would not execute because system privileges and object privileges cannot
be granted together in a single GRANT command.



Leave a Reply 0

Your email address will not be published. Required fields are marked *