Valid 1z0-067 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-067 Exam! ExamDiscuss.com now offer the newest 1z0-067 exam dumps, the ExamDiscuss.com 1z0-067 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-067 dumps with Test Engine here:
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands: SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQL> CREATE ROLE C##CONNECT; SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?
Correct Answer: D
Explanation/Reference: Explanation: https://docs.oracle.com/database/121/SQLRF/statements_6014.htm#SQLRF01311 "CONTAINER Clause The CONTAINER clause applies when you are connected to a CDB. However, it is not necessary to specify the CONTAINER clause because its default values are the only allowed values. To create a common role, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root. To create a local role, you must be connected to a PDB. You can optionally specify CONTAINER = CURRENT, which is the default when you are connected to a PDB."