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:
* (C,E,not a) file_name_convert
Use this clause to determine how the database generates the names of files (such as data files
and wallet files) for the PDB.
For filename_pattern, specify a string found in names of files associated with the seed (when
creating a PDB by using the seed), associated with the source PDB (when cloning a PDB), or
listed in the XML file (when plugging a PDB into a CDB).
For replacement_filename_pattern, specify a replacement string.
Oracle Database will replace filename_pattern with replacement_filename_pattern when
generating the names of files associated with the new PDB.
File name patterns cannot match files or directories managed by Oracle Managed Files.
You can specify FILE_NAME_CONVERT = NONE, which is the same as omitting this clause. If
you omit this clause, then the database first attempts to use Oracle Managed Files to generate file
names. If you are not using Oracle Managed Files, then the database uses the
PDB_FILE_NAME_CONVERT initialization parameter to generate file names. If this parameter is
not set, then an error occurs.
Note:
* Oracle Database 12c Release 1 (12.1) introduces the multitenant architecture. This database——–architecture has a multitenant container database (CDB) that includes a root container,
CDB$ROOT, a seed database, PDB$SEED, and multiple pluggable databases (PDBs).
The answer should be- BCE.
Its SEED FILE_NAME_CONVERT. DB_FILE_NAME_CONVERT is being used in RMAN, not used as an initialization parameter.
correct: ABC
I think only B,C is correct. The others are wrong.
Answers: A,B and C
The CREATE DATABASE statement uses the root’s files (such as data files) to generate the names of the seed’s files. You must specify the names and locations of the root’s files and the seed’s files. After the CREATE DATABASE statement completes successfully, you can use the seed and its files to create new PDBs. The seed cannot be modified after it is created.
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
http://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN13523
Agree with you, it should be A, B ,C
ABC
not the “A” because the OMF leaves not rename the files, he gives the names.
The following initialization parameters are used for OMF:
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_DEST_n
DB_RECOVERY_FILE_DEST
Morris, Matthew (2014-03-20). Study Guide for 1Z0-060: Upgrade to Oracle Database 12c: Oracle Certification Prep (p. 225). ODB Press. Kindle Edition.
See more:
http://docs.oracle.com/database/121/ADMIN/omf.htm#g1018000
https://oracle-base.com/articles/12c/multitenant-create-and-configure-container-database-12cr1#manual
-> A,B,E
ABC or BCE
George’s answer (ABC) is correct and he links to the relevant Oracle documentation
Fro Oracle 12c Doc
You must specify the names and locations of the seed’s files in one of the following ways:
1.The SEED FILE_NAME_CONVERT Clause
2.Oracle Managed Files
3.The PDB_FILE_NAME_CONVERT Initialization Parameter
So ABC is correct
Thanks really helpful. Will certainly share website with my good friends
NBA http://www.chengpo.net/comment/html/?6148.html
BCE is Correct
A,B,C.
—
You must specify the names and locations of the seed’s files in one of the following ways:
1.The SEED FILE_NAME_CONVERT Clause
2.Oracle Managed Files
(This is right because you can manually set ROOT location and the SEED will be created in the DB_CREATE_FILE_DEST)
3.The PDB_FILE_NAME_CONVERT Initialization Parameter
—
ABC
ABC