You are planning the creation of a new multitenant container database (CDB) and want to store
the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?
A.
Use Oracle Managed Files (OMF).
B.
Specify the SEED FILE_NAME_CONVERT clause.
C.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.
D.
Specify the DB_FILE_NAMECONVERT initialization parameter.
E.
Specify all files in the CREATE DATABASE statement without using Oracle managed Files
(OMF).
Explanation:
You must specify the names and locations of the seed’s files in one of the following
ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter
ABC
BCE
B C E
A,B,C
You must specify the names and locations of the seed’s files in one of the following ways:
– The SEED FILE_NAME_CONVERT Clause
– Oracle Managed Files
– The PDB_FILE_NAME_CONVERT Initialization Parameter
This is for the PDB, but for de CDB you need to specify the Seed and Root
B: This SEED FILE_NAME_CONVERT clause generates file names for the seed’s files in the /oracle/pdbseed directory using file names in the /oracle/dbs directory.
C: The PDB_FILE_NAME_CONVERT initialization parameter can specify the names and locations of the seed’s files.
E: When you create a CDB using the CREATE DATABASE SQL statement, you must enable PDBs and specify the names and locations of the root’s files and the seed’s files.
by
https://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN13522
BCE
A, B, C
https://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN13522
look at these session
37.4.1.2 About the Names and Locations of the Root’s Files and the Seed’s Files