Oracle Database Administration II

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which two are true about gathering optimizer statistics?

System statistics can be gathered only while the CDB is in MOUNT state.
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB. (correct)
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT. (correct)

Choose the minimum required steps in the correct order to recover the database.

1,3, 5, 6, 10
1,2, 5, 7, 4, 10
1,3,5, 6, 9
1,3, 5, 7, 10 (correct)
1,3, 5, 6, 10
1,3, 5, 8, 6, 10

By default, AWR snapshots are retained for 7 days.

True (A)

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive __________ activity, thereby degrading performance.

hard parse Signup and view all the answers

Match the following flashback technologies with their purpose:

FLASHBACK TABLE customers TO TIMESTAMP = Revert the table to a specific point in time SELECT * FROM customers AS OF SCN = View the table as of a specific system change number FLASHBACK TABLE customers TO BEFORE DROP = Recover the table before it was dropped Signup and view all the answers

Which three are true about RMAN archival backups with the RESTORE POINT clause?

Use of a recovery catalog is always required to support the creation and use of archival backups. (B), Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored. (F), The SPFILE is included in the archival backup. (G) Signup and view all the answers

Which three are true about backing up the control file?

It can be backed up manually as a trace file containing SQL statements for control file recreation. (B), It can be backed up manually as a binary copy. (C), It can get backed up automatically as a binary copy. (D) Signup and view all the answers

Which two are true about gathering optimizer statistics?

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT. (D), Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB. (E) Signup and view all the answers

Which two are true about Recovery Manager (RMAN) diagnostic message output?

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only. (D), RMAN error stacks should be read from the top down as that is the order in which errors are generated. (E) Signup and view all the answers

Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted. To recover from this critical failure, you execute these commands: What will be the outcome?

It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' Signup and view all the answers

You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

The recovery catalog is synchronized from the target database control file with a full resync at the next backup. (B) Signup and view all the answers

You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

Cloning the non-CDB as a PDB (D), The DBMS_PDB package (E), Data Pump full database export and import (F) Signup and view all the answers

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

Tables or table partitions can be recovered by using an auxiliary instance only. (A), Tables or table partitions from the system and sysaux tablespaces cannot be recovered. (D) Signup and view all the answers

Which three are true about an application seed pluggable database (PDB)?

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes. (A), A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes. (E) Signup and view all the answers

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?

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 takes noticeably less time than an actual backup, then write I/O is a likely bottleneck. (C) Signup and view all the answers

Study Notes