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…

Question

Options

• AStatement 1 would not execute because the WITH GRANT option is missing.
• BStatement 1 would not execute because the IDENTIFIED BY <password> clause is missing.
• CStatement 3 would not execute because role and system privileges cannot be granted together in a
• DStatement 2 would not execute because system privileges and object privileges cannot be granted

• A
  6% (2)
• B
  3% (1)
• C
  17% (6)
• D
  75% (27)

No community discussion yet for this question.