Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Which three are true about the SQL Tuning Advisor? (Choose three.)

A.

It checks each query being analyzed for stale statistics.

B.

It checks each query being analyzed for missing statistics.

C.

It only recommends syntactic changes to SQL statements.

D.

It can recommend semantic changes to SQL statements.

E.

It considers all SQL statements being analyzed by the advisor task as a group.

F.

It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Choose two. Which two are true about gathering optimizer statistics?

A.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.

B.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

C.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).

D.

System statistics can be gathered only while the CDB is in MOUNT state.

E.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

our 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 CONTAINERS clause cannot be used in queries on the REVENUE table.

B.

The REVENUE table must be a list-partitioned table.

C.

The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

D.

The MAPTABLE table is a metadata-linked table.

E.

A container map exists for the REVENUE table, but is not enabled.

F.

The REVENUE table partitions are not pruned across the PDBs automatically.

.Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?

A.

The password for the encryption must be set up.

B.

Oracle wallet for the encryption must be set up.

C.

All the tablespaces in the database must be encrypted

D.

Oracle Database Vault must be enabled.

Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

A.

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

B.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F

C.

If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

D.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

E.

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A.

The number of table rows is considered when evaluating the cost of accessing a table using an index.

B.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

C.

The Statistics Advisor can help recommend the best way to gather statistics.

D.

Statistics collected using DBMS_STATS always yield the best optimizer result.

E.

The Statistics Advisor generates actions for all recommendations.

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

A.

Recovery begins from the beginning of the CURRENT redo log group.

B.

Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

C.

Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

D.

Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

E.

Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

F.

Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

A.

A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

B.

A PDB Lockdown profile can be created in an application root.

C.

A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

D.

A PDB Lockdown profile can be created in a regular PDB.

E.

A PDB Lockdown profile can be created in CDB$ROOT .

Choose two. Which two are true about Rapid Home Provisioning of Oracle software?

A.

It can be used for applications and middleware.

B.

It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

C.

It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

D.

It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

E.

It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

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