Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

A. ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.

B. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.

C. ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.

D. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.

E. ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.

Which two statements are true about a band join? (Choose two.)

A. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.

B. It returns rows for SQL statements that contain an equijoin.

C. It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.

D. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.

E. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.

Identify a situation where performance profiles can be used for application containers.

A. to specify the total number of parallel execution servers available

B. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

C. to specify the maximum percentage of the parallel execution server pool that a particular application container can use

D. to enforce a limit on the number of I/OS issued per second

E. to enforce a limit on I/O throughput per second

Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

A. It changes Oracle kernel parameters if required

B. It creates a restore point to restore the database if the upgrade fails

C. It drops all the invalid objects

D. It calls the catctl.pl script to perform the upgrade process in parallel

E. It automatically resets the COMPATIBLE parameter value to 12.0.0

F. It modifies or creates new tablespaces as required

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace,

TBS_CMP with default compression for query low.

You execute commands:

Which three statements are true? (Choose three.)

A. The primary key constraints on T1 are dropped

B. T1 is in the TBS_UNCMP tablespace

C. T1 is in the TBS_CMP tablespace

D. T1 is in compressed format

E. T1 is in uncompressed format

F. All indexes on T1 remain valid

Which two statements are true about the In-Memory (IM) column store? (Choose two.)

A. It may be used for columns in Index Organized Tables (IOTs)

B. It may be used for columns in clustered tables

C. IM area size is not controlled by Oracle Automatic Memory Management

D. IM area size can be set at the CDB and PDB levels

E. IM area size can be increased or decreased dynamically

F. It is not used for partitioned tables

Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?

A. Oracle Loader-type external tables

B. remote cloning

C. RMAN Transportable Tablespace with Data Pump for all tablespaces

D. Data Pump Transportable Tablespace for all tablespaces

E. Data Pump Conventional Export/Import

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

A. They may be recovered to a schema in a different PDB

B. An AUXILIARY instance is started only if there is sufficient disk space

C. They can be recovered by RMAN without an AUXILIARY instance

D. They must be un-partitioned tables

E. They may be recovered to a different schema in the same pluggable database (PDB)

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

A. It analyzes only those memory components of the database instance that are impacting performance.

B. It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.

C. It analyzes the performance of the database instance based on the latest two AWR snapshots.

D. It determines SQL statements that are performing poorly.

E. It recommends implementing SQL profiles to generate better execution plans.

F. It analyzes only the components and waits that are impacting database performance.

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A. number of parallel queries issued by a consumer group

B. maximum number of DML operations performed by a consumer group

C. sessions that are blocking other sessions

D. sessions that are not blocking other sessions

E. UNDO quota for a consumer group