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 WITH GRANT option is missing.
B.
Statement 1 would not execute because the IDENTIFIED BY <password> clause is missing.
C.
Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.
D.
Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.
https://docs.oracle.com/cd/F49540_01/DOC/server.815/a67772/privs.htm
Note:
System privileges and roles cannot be granted along with object privileges in the same GRANT statement.