Which two are true about instance recovery? (Choose two.)

• A.It is not possible if an archived log is missing.
• B.It is performed automatically while the database remains in MOUNT state. Then the database is opened.
• C.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
• D.Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
• E.Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
• F.It is performed by the Recovery Writer (RVWR) background process.

Comment: *

Name: *

Email: *

Verification: *

Which three are true? (Choose three.)

• A.Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
• B.Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
• C.Application-common TSDP policies are always container specific.
• D.Unified auditing can be automatically synchronized to all application PDBs in an application container.
• E.Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
• F.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
• G.Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Database Configuration Assistant (DBCA)?

• A.It can configure Automatic Storage Management (ASM) diskgroups.
• B.It can generate SQL database creation scripts.
• C.It can be used to add a new tablespace.
• D.It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
• E.It can be used to create a database template from an existing database.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

• A.All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• B.AWR snapshots can be created in CDB$ROOT.
• C.AWR snapshots can be created in a PDB.
• D.ADDM can run in a nonroot container.
• E.No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• F.AWR reports can be generated while connected to any container.

Comment: *

Name: *

Email: *

Verification: *