Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true? (Choose two.)

The correct answer is C. The command will, create a common user whose description is contained in the root and each PDB. D. The schema for the common user C # # A_ADMIN can be different in each container. If you omit this clause and the current container is a PDB, then CONTAINER = CURRENT is the default. If you omit this clause and the current container is the root, then CONTAINER = ALL is create table only in current container

New Features for Database Infrastructure and Architecture

Question

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

Options

ASchema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
BThe C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
CThe command will, create a common user whose description is contained in the root and each PDB.
DThe schema for the common user C # # A_ADMIN can be different in each container.
EThe command will create a user in the root container only because the container clause is not used.

How the community answered

(38 responses)

A
3% (1)
B
5% (2)
C
79% (30)
E
13% (5)

Explanation

If you omit this clause and the current container is a PDB, then CONTAINER = CURRENT is the default. If you omit this clause and the current container is the root, then CONTAINER = ALL is create table only in current container

Topics

#CDB common users#multitenant architecture#PDB user management#CONTAINER clause

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice