Which three techniques can you use to achieve this?

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?

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).



Leave a Reply 17

Your email address will not be published. Required fields are marked *


Sunil

Sunil

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.

Ledeboer, Jeroen

Ledeboer, Jeroen

I think only B,C is correct. The others are wrong.

George

George

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

Shoulian

Shoulian

Agree with you, it should be A, B ,C

Morilla

Morilla

not the “A” because the OMF leaves not rename the files, he gives the names.

Morilla

Morilla

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

Rodge

Rodge

George’s answer (ABC) is correct and he links to the relevant Oracle documentation

Oleg

Oleg

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

narendra

narendra

BCE is Correct

Diogo

Diogo

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