Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 191:

  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?

  A. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

  B. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

  C. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

  D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

  Correct Answer: A

• Question 192:

  Which two are true about RMAN image copies? (Choose two.)

  A. The can only be written to disk.

  B. They are the only backup option available for database in NOARCHIVELOG mode.

  C. They can be encrypted using Transparent Data Encryption (TDE).

  D. They can be used as a level 0 incremental backup.

  Correct Answer: AD

  Reference: https://docs.oracle.com/database/121/BRADV/rcmcncpt.htm

• Question 193:

  One of your databases is in ARRCHIVELOG mode.

  You back up the database by using RMAN with a recovery catalog.

  One data file and all the control files are corrupt due to corruption in the storage array.

  Examine this list of possible actions to recover the database:

  1.

  Restore the control files by using the RESTORE CONTROLFILE command.

  2.

  Mount the database.

  3.

  Restore the data files by using the RESTORE DATABASE command.

  4.

  Open the database with the RESETLOGS option.

  5.

  Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.

  6.

  Start the target database instance in NOMOUNT state.

  7.

  Connect to the target database and the recovery catalog database instance.

  8.

  Restore the SPFILE by using the RESTORE SPFILE command

  9.

  Restore the corrupt data file.

  10.

  Recover the restored data file.

  Identify the minimum required steps in the correct order.

  A. 7, 6, 1, 8, 2, 3, 5, 4

  B. 7, 6, 1, 2, 3, 5, 4

  C. 7, 2, 1, 3, 5, 4

  D. 7, 6, 1, 2, 9, 10, 4

  E. 7, 6, 1, 2, 3, 10, 4

  Correct Answer: D

• Question 194:

  Examine these RMAN commands:

  

  Which two statements are true about the DUPLICATE command? (Choose two.)

  A. It fails because connection to the AUXILIARY instance must be as SYSDBA.

  B. It fails because no parallel channels are allocated for the auxiliary database.

  C. It succeeds only if the target database is greater than 400M.

  D. No catalogued backup of the TARGET is used to duplicate the database.

  E. It succeeds.

  Correct Answer: CD

• Question 195:

  Which two are true about incremental backups? (Choose two.)

  A. A backup set can be used as the baseline for an incremental backup.

  B. Differential backups can be taken at level 0.

  C. An image copy can be used as the baseline for an incremental backup.

  D. A tablespace incremental level 1 backup always backs up all blocks in the backed up tablespace.

  E. Incremental backups are not permitted when using block change tracking.

  F. A database incremental level 0 backup always backs up all database blocks.

  Correct Answer: DF

  Reference: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm

• Question 196:

  Which two are true about data dictionary views and contents and output in a CDB? (Choose two.)

  A. DBA_views are a superset of CDB_views.

  B. CDB_views can be queried only from CDB$ROOT.

  C. Data dictionary metadata for user-created objects is contained in PDB system tablespaces.

  D. The data dictionary in CDB$ROOT stores only metadata for objects common to all its PDBs.

  E. Oracle-supplied data dictionary tables metadata is stored only in CDB$ROOT.

  Correct Answer: BE

  Reference: https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89248

• Question 197:

  You want to create a guaranteed restore point for your databases by executing the command:

  SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

  Identify two prerequisites for the successful execution of this command. (Choose two.)

  A. A database backup must be taken.

  B. Fast Recovery Area must be enabled.

  C. Undo retention guarantee must be enabled

  D. The recyclebin must be enabled for the database.

  E. Flashback Database must be enabled.

  F. The database must be running in ARCHIVELOG mode.

  Correct Answer: BF

  Reference: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm

• Question 198:

  Which two statements are true about service for pluggable databases (PDBs)? (Choose two.)

  A. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

  B. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

  C. A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB.

  D. When a PDB is created, a service with the same name as the PDB is created in the PDB.

  E. Only a common user can create additional services for a PDB.

  Correct Answer: BC

• Question 199:

  One of your database runs in ARCHIVELOG mode.

  Examine these initialization parameter settings:

  

  Which statement is true based on these settings?

  A. An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.

  B. An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations.

  C. An online redo log will not be overwritten only if an archived log cannot be created in at least one of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.

  D. An online redo log will not be overwritten only if an archived log cannot be created in LOG_ARCHIVE_DEST_4.

  Correct Answer: D

• Question 200:

  Which two methods can be used to create a PDB from a non-CDB Oracle 12c Database? (Choose two.)

  A. use the CREATE PLUGGABLE DATABASE command across a database link from CDB$ROOT to the non-CDB.

  B. Use Data Pump to export the non-CDB and import it into a newly created, empty PDB.

  C. Use only the DBMS_PDB package.

  D. Use the CREATE DATABASE command with an XML file created by executing DBMS_PDB in the non-CDB.

  E. Use only the DUPLICATE DATABASE command.

  Correct Answer: AC

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/spucs/create-pdb-using-a-noncdb.html#GUID-5DBBD832-B8D5-42CE-8D5C-986037656A7E