Oracle
1Z0-047 · Question #207
1Z0-047 Question #207: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
Question
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?
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
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.