Oracle
1Z0-063 · Question #1
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user: SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT…
The correct answer is A. The common user is created in the CDB and all the PDBs, and uses the users and temp. See the full explanation below for the reasoning.
Question
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user: SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA I00M ON users TEMPORARY TABLESPACE temp; Which statement is true about the execution of the command?
Options
- AThe common user is created in the CDB and all the PDBs, and uses the users and temp
- BThe command succeeds only if all the PDBs have the users and temp tablespaces.
- CThe command gives an error because the container=all clause is missing.
- DThe command succeeds and sets the default permanent tablespace of a PDB as the default
How the community answered
(33 responses)- A76% (25)
- B3% (1)
- C6% (2)
- D15% (5)
Community Discussion
No community discussion yet for this question.