For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

• A.to specify the list of tablespaces to include when creating a PDB from the CDB seed
• B.to exclude a temp tablespace when plugging in a PDB
• C.to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• D.to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• E.to include specific user tablespaces only when relocating a PDB
• F.to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

Comment: *

Name: *

Email: *

Verification: *

Which three are located by using environment variables?

• A.the temporary disk space used by Oracle Installer during installation
• B.the maximum number of database files that can be opened by a database instance
• C.the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
• D.default directories for temporary files used by temporary tablespaces
• E.the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
• F.the location of Oracle Net Services configuration files

Comment: *

Name: *

Email: *

Verification: *

Choose two. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

• A.to generate an XML metadata file that describes the current plugged-in PDB
• B.to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure
• C.to generate an XML metadata file from any unplugged PDB
• D.to generate a . pdb archive file for any PDB in the current CDB
• E.to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true?

• A.Redo logs are opened.
• B.PDB$SEED is in read only state.
• C.PDB1 and PDB2 are in read only state.
• D.CDB$ROOT is in mount state.
• E.PDB1 and PDB2 are in mount state.

Comment: *

Name: *

Email: *

Verification: *

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

• A.Decreasing PCTUSED
• B.Using Automatic Segment Space Management (ASSM)
• C.Decreasing PCTFREE
• D.Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
• E.Increasing the number of DBWN process

Comment: *

Name: *

Email: *

Verification: *