SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 - CREATE ROLE mgr;2 - GRANT CREATE TABLE, SELE
Posted: Wed Jun 07, 2023 6:11 am
SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 - CREATE ROLE mgr;2 - GRANT CREATE TABLE, SELECTON 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.
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.