Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?

• A.It can be used to create container databases and non-container databases.
• B.It can be used to change the character set of an existing database.
• C.It can only be launched from the command line interface.
• D.It can be launched from both the command line and the Universal Installer (OUI) interfaces.
• E.It can be used to convert a non-container database to a container database.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?

• A.A lost PFILE can be re-created from alert.log using SQL*PLUS.
• B.A lost TEMPFILE must always be re-created manually.
• C.A lost password file can be manually re-created with the orapwd utility.
• D.A lost password file can be re-created with SQL*PLUS.
• E.A lost index tablespace can be re-created without performing any recovery.
• F.A lost SPFILE can be recovered from memory using SQL*PLUS.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?

• A.The REVENUE table must be a composite-partitioned table.
• B.The CONTAINERS clause cannot be used in queries on the REVENUE table.
• C.The REVENUE table must be a list-partitioned table.
• D.The REVENUE table partitions are not pruned across the PDBs automatically.
• E.The MAPTABLE table defines a logical partition key on a commonly used column for the REVENUE table.

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance. You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

• A.V$SESSTAT
• B.V$SESSION
• C.V$SESSION_EVENT
• D.V$SESSION_WAIT_CLASS
• E.V$SESSION_WAIT

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *