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.
Specify all files in the CREATE DATABASE statement without using Oracle managed
Files (OMF).

B.
Use Oracle Managed Files (OMF).

C.
Specify the SEED FILE_NAME_CONVERT clause.

D.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.

E.
Specify the DB_FILE_NAMECONVERT initialization parameter.

Show Hint

Leave a Reply 2

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

Patty

Patty

BCD

The SEED FILE_NAME_CONVERT clause is optional. If you don’t specify this clause, Oracle will name and store the files according to the OMF (Oracle Managed Files) conventions. The SEED FILE_NAME_CONVERT parameter determines where Oracle should locate the seed database’s data files for its SYSTEM and SYSAUX tablespaces. The clause renames the seed pluggable database’s files while they’re copied from the root container.
The SEED FILE_NAME_CONVERT clause is just one way of specifying the directory for the seed data files. Alternatively, you can set one of the following initialization parameters in the init.ora file to specify the source data files. Here are examples for both the parameters:
DB_CREATE_FILE_DEST If you set this parameter, the data files will be
created in the Oracle Managed Files (OMF) format.
PDB_FILE_NAME_CONVERT This parameter maps the root data files to the seed data files.

Reply