You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAMETYPEVALUE
———————————————————————–
db_create_file_deststring
db_file_name_convertstring
db_filesinteger200
You verify that sufficient disk space is available and that no file currently exists in the
‘/u0l/app/oracle/oradata/cdb1/salesdb’ location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password
ROLES=(dba)
DEFAULTTABLESPACEsales
DATAFILE’ /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf’SIZE 250M AUTOEXTEND
ON
FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/’,
‘/u01/app/oracle/oradata/cdb1/salesdb/’)
STORAGE(MAXSIZE2G)
PATK_PREFIX=’/u01/app/oracle/oradata/cdb1/SALESPDB’;
Which statement is true?
A.
SALESPDB is created and is in mount state.
B.
PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.
C.
SALESPDB is created and is in read/write mode.
D.
PDB creation fails because a default temporary tablespace is not defined for SALESPDB.
Answer: A
SYS@ORA12C>show parameter file
NAME |TYPE |VALUE
———————|——–|——–
db_create_file_dest |string |
db_file_name_convert |string |
db_files |integer |200
SYS@ORA12C>CREATE PLUGGABLE DATABASE PDB1
ADMIN USER adm IDENTIFIED BY password
ROLES=(dba)
DEFAULT TABLESPACE sales
DATAFILE ’D:\U01\ORADATA\ORA12C\PDB1\sales01.dbf’ SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT=(‘D:\U01\ORADATA\ORA12C\PDBSEED\’,‘D:\U01\ORADATA\ORA12C\PDB1\’)
STORAGE (MAXSIZE 2G)
PATH_PREFIX=’D:\U01\ORADATA\ORA12C\PDB1’;
SYS@ORA12C>select con_id,NAME,OPEN_MODE from v$pdbs where name=’PDB1′;
CON_ID|NAME |OPEN_MODE
———-|—————————–|———-
4|PDB1 |MOUNTED
SYS@ORA12C>select con_id,name from v$datafile where con_id=4;
CON_ID|NAME
———-|—————————————-
4|D:\U01\ORADATA\ORA12C\PDB1\SYSTEM01.DBF
4|D:\U01\ORADATA\ORA12C\PDB1\SYSAUX01.DBF
4|D:\U01\ORADATA\ORA12C\PDB1\SALES01.DBF
Thanks Siegfried !
A.
We need seed tablespace to create new plugable db.
/u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/orcl/pdbseed/system01.dbf
By default. Seed has two tbs.
A
ANS : A
A