Oracle
1Z0-047 · Question #218
1Z0-047 Question #218: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #218. The question stem and answer options stay visible for context.
Question
OE and SCOTT are the users in the database. The ORDERS table is owned by OE. Evaluate the statements issued by the DBA in the following sequence: CREATE ROLE r1; GRANT SELECT, INSERT ON oe. orders TO r1; GRANT r1 TO scott; GRANT SELECT ON oe. orders TO scott; REVOKE SELECT ON oe.orders FROM scott; What would be the outcome after executing the statements?
Options
- ASCOTT would be able to query the OE.ORDERS table.
- BSCOTT would not be able to query the OE.ORDERS table.
- CThe REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1.
- DThe REVOKE statement would give an error because the SELECT privilege has been granted to the role R1
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.