You create a new pluggable database, HR_PDB, from the seed database. Which three
tablespaces are created by default in HR_PDB?
A.
SYSTEM
B.
SYSAUX
C.
EXAMPLE
D.
UNDO
E.
TEMP
F.
USERS
Explanation:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains
other user created tablespaces in it.
*
* Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every
database.
* tablespace_datafile_clauses
Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX
tablespaces in the seed PDB.
Incorrect:
Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to
the CDB.
Note:
* Example:
CONN pdb_admin@pdb1
SELECT tablespace_name FROM dba_tablespaces;
TABLESPACE_NAME
——————————SYSTEM
SYSAUX
TEMPUSERS
SQL>
As per snapshot provided, the answer should be ABF.
It should be A,B and E. So System,Sysaux and Temporary tablespaces are created
cool mahrukh, you are right correct answer is ABE
while creating a PDB the New clause USER_DATA TABLESPACE allows you to specify a default tablespace other than USERS when using DBCA…
The default temp tablespace is at first the one from the CDB$ROOT.
ABF is correct
A, B and E.
In the case of this question, the PDB was created a clone from SEED. So, it will have the same tablespaces of SEED.
SQL> select CON_ID, NAME from v$containers where con_id=2;
CON_ID NAME
———- ——————————
2 PDB$SEED
SQL> select tablespace_name from cdb_tablespaces where con_id=2;
TABLESPACE_NAME
——————————
SYSTEM
SYSAUX
TEMP
ABE
As per the documentation, it must be A, B and E
http://docs.oracle.com/database/121/SQLRF/statements_6010.htm
ABE
A, B and E is full and final Answer
A,B, E is correct
ABE
ABE
ABC
I happen to be commenting to make you understand of the wonderful experience my princess experienced checking yuor web blog. She came to understand lots of details, which include how it is like to possess an ideal helping heart to have a number of people without hassle grasp various specialized matters. You really surpassed her expected results. Many thanks for churning out the insightful, safe, educational and even fun tips on this topic to Sandra.