Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A.By default, AWR snapshots are taken every 60 minutes.
• B.Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
• C.By default, AWR snapshots are retained for 7 days.
• D.The taking of AWR snapshots can be disabled.
• E.AWR data is stored in the SYSTEM tablespace.

Comment: *

Name: *

Email: *

Verification: *

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

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

Comment: *

Name: *

Email: *

Verification: *

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:

Which two are true? (Choose two.)

• A.The MAPTABLE table is a metadata-linked table.
• B.A container map exists for the REVENUE table, but is not enabled.
• C.The REVENUE table must be a list-partitioned table.
• D.The REVENUE table partitions are not pruned across the PDBs automatically.
• E.The CONTAINERS clause cannot be used in queries on the REVENUE table.
• F.The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

• A.CDB1, PDB$SEED, PDB1, and PDB2
• B.CDB1, PDB1, and PDB2 only
• C.CDB1, PDB$SEED, and PDB1 only
• D.CDB1 and PDB$SEED only
• E.PDB$SEED, PDB1, and PDB2 only

Comment: *

Name: *

Email: *

Verification: *

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

• A.using Database Replay
• B.using SQL Developer
• C.using Oracle Data Pump
• D.using operating system file copy utilities
• E.using Database Upgrade Assistant
• F.using the CREATE TABLE AS SELECT SQL statement

Comment: *

Name: *

Email: *

Verification: *