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…

The correct answer is A. Use Oracle Managed Files (OMF). B. Specify the SEED FILE_NAME_CONVERT clause. C. Specify the PDB_FILE_NAME_CONVERT initialization parameter. 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…

Managing Database Storage Structures

Question

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?

Options

AUse Oracle Managed Files (OMF).
BSpecify the SEED FILE_NAME_CONVERT clause.
CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.
DSpecify the DB_FILE_NAMECONVERT initialization parameter.
ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files

How the community answered

(28 responses)

A
82% (23)
D
7% (2)
E
11% (3)

Explanation

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

Topics

#CDB creation#Oracle Managed Files (OMF)#PDB_FILE_NAME_CONVERT#Data file management

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice