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

Comment: *

Name: *

Email: *

Verification: *

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? (Choose two.)

• A.Effectively implements role separation
• B.Enables you to take advantage of Oracle Managed Files.
• C.Automatically registers the database with Oracle Restart.
• D.Helps you to easily upgrade the database from a prior release.
• E.Enables the Installation of Grid Infrastructure files on block or raw devices.

Comment: *

Name: *

Email: *

Verification: *

You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVELparameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE; Which is true about the result of this command?

• A.The STATISTICS_LEVELparameter is set to all whenever this PDB is re-opened.
• B.The STATISTICS_LEVELparameter is set to ALL whenever any PDB is reopened.
• C.The STATISTICS_LEVELparameter is set to all whenever the multitenant container database (CDB) is restarted.
• D.Nothing happens; because there is no SPFILEfor each PDB, the statement is ignored.

Comment: *

Name: *

Email: *

Verification: *

Identify two correct statements about multitenant architecture. (Choose two.)

• A.Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B.Multiple pluggable databases (PDBs) share the SGA of a multitenant container database (CDB).
• C.Multiple CDBs share certain PDB resources.
• D.Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E.Patches are always applied at the CDB level.
• F.A PDB can have a private undo tablespace.

Comment: *

Name: *

Email: *

Verification: *

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

• A.Reduced logical I/O
• B.Reduced virtual memory utilization
• C.Improved parallel Execution performance
• D.Improved Serial Execution performance
• E.Reduced physical I/O
• F.Reduced CPU utilization

Comment: *

Name: *

Email: *

Verification: *