1Z0-071 practice question 31 of 35
Examine thee statements which execute successfully: CREATE USER finance IDENTIFIED BY pwfin; CREATE USER fin manager IDENTIETED BY pwmgr; CREATE USER fin. Clerk IDENTIFIED BY pwclerk; GRANT CREATE SESSON 20 finance, fin clerk; GRANT SELECT ON scott. Emp To finance WITH GRANT OPTION; CONNECT finance/pwfin GRANT SELECT ON scott. emp To fin_ _clerk; Which two are true?
Full set: 326 questionsWhen a privilege is granted WITH GRANT OPTION, the grantee can grant that privilege to others. However, Oracle implements a dependency chain. If the original grantee (FINANCE) is dropped or has the privilege revoked, all dependent grants are automatically revoked. This cascading revocation ensures security integrity by preventing orphaned privileges.
C. FINANCE only received CREATE SESSION without GRANT OPTION, so cannot grant it to others.
D. FINCLERK received SELECT without GRANT OPTION, so cannot grant it to FINMANAGER.
E. FINANCE cannot grant ALL privileges because it only has SELECT privilege on SCOTT.EMP.
1. Oracle Database SQL Language Reference 19c, "GRANT Statement", Section on WITH GRANT OPTION behavior
2. Oracle Database Security Guide 19c, Chapter 4 "Managing User Privileges", Cascade Effects of Revoking Privileges
3. Oracle Database Administrator's Guide 19c, "Managing Users and Securing the Database", Privilege Dependencies section
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
