Oracle Database: Backup and Recovery Workshop Quiz Questions and Answers

Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

Answer :
  • Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
  • Use the DBMS_PDB package to clone an existing PDB
  • Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

Explanation :

Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks: * (A) Create a PDB by using the seed as a template Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB. * (C) Create a PDB by cloning an existing PDB Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB. The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files. * Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

Answer :
  • The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Explanation :

he stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window. References: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431

In Oracle Database 19c What is SPFILE?

Answer :
  • A Binary file that contains parameter for the DB instance.

Explanation :

A Binary file that contains parameter for the DB instance.

In Oracle Database 19c ‘DB_RECOVERY_FILE_DEST’ parameter uses OMF.

Answer :
  • True

Explanation :

The above statement is correct

In Oracle Database 19c PFILE and SPFILE contains majority of dynamic parameters that can be changed without restarting the DB instance.

Answer :
  • True

Explanation :

The above statement is correct

In Oracle Database 19c Loss of control file of database won’t impact the database availability.

Answer :
  • False

Explanation :

The above statement is wrong