Database Reference
In-Depth Information
Review Questions
1.
In the Oracle 12
c
multitenant architecture, which of the following accurately describes
the relationship between PDBs and CDBs?
A.
A PDB can exist across multiple CDBs.
B.
Many CDBs can exist across multiple PDBs.
C.
Many CDBs can exist in a single PDB.
D.
Many PDBs can exist in a single CDB.
E.
All of the above.
2.
Which of the following statements is true regarding the number of user-created pluggable
databases per CDB?
A.
A maximum of 252 user-created PDBs per CDB
B.
A maximum of 253 user-created PDBs per CDB
C.
A maximum of 252 CDBs per user-created PDB
D.
A maximum of 253 CDBs per user-created PDB
3.
Which of these formats represents the correct command to create a PDB using SQL*Plus?
A.
CREATE PDB DATABASE pdb3 ADMIN USER pdb3_admin IDENTIFIED BY system03;
B.
CREATE PLUGGABLE DATABASE pdb3 ADMIN USER pdb3_admin IDENTIFIED BY
system03;
C.
CREATE PLUGGABLE DATABASE pdb3 SYSTEM USER pdb3_admin IDENTIFIED BY
system03;
D.
None of the above
4.
Which of the following statements is true concerning the Oracle multitenant
architecture?
A.
It is available beginning with Oracle 11
g
and expanded in Oracle 12
c
.
B.
It supports multiple PDBs within one CDB that spans multiple platforms.
C.
It allows the DBA to shut down a CDB but keep tenant PDBs active.
D.
It allows the DBA to host multiple releases of the Oracle Database within one CDB.
E.
None of the above.
Search WWH ::
Custom Search