Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 181:

  You enable Flashback Data Archive for a table for which you want to track and save all transactions for

  four years. After some time, the requirement changes for keeping transactions from four to two years.

  You execute the following command to change the requirement:

  SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTION 2 YEAR;

  What is the outcome?

  A. An error is returned because the retention period cannot be reduced.

  B. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

  C. All historical data older than two years, if any, is purged from the flashback archive FDA1.

  D. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.

  Correct Answer: D

• Question 182:

  You execute the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2; RMAN> BACKUP DATABASE;

  Which two statements are true? (Choose two.)

  A. One channel is allocated.

  B. Two channels are allocated.

  C. The backup set is created in parallel in two locations.

  D. The backup set is created in parallel only in one location.

  E. The backup set is created serially in only one location.

  Correct Answer: BC

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

• Question 183:

  An incremental level 1 backup is taken every week day. A new tablespace is created before the backup is performed.

  You execute:

  RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;

  Which two are true? (Choose two.)

  A. It returns an error because there is no existing level 0 backup for the new data files.

  B. It creates a level 1 incremental backup set containing all the previously existing data files.

  C. It creates a level 0 backup set containing all the new data files.

  D. It creates image copies of all the new data files.

  E. It creates a level 1 incremental backup set containing all the new data files.

  Correct Answer: BD

• Question 184:

  Which four are true about Consolidated Database Replay? (Choose four.)

  A. The workload capture and replay servers must run the same operating system (OS).

  B. Multiple workload captures from multiple databases can be replayed simultaneously.

  C. A subset of the captured workload can be replayed.

  D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

  E. Multiple replay schedules can be defined for a consolidated replay.

  F. A single replay schedule can be defined for a consolidated replay.

  G. A superset of the captured workload can be replayed.

  Correct Answer: BCEF

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/ratug/using-consolidateddatabase-replay.html

• Question 185:

  You are required to migrate your 11.2.0.3 database to an Oracle 12c database.

  Examine the list of steps that might be used to accomplish this task:

  1.

  Place all user-defined tablespaces in read-only mode on the source database.

  2.

  Use the RMAN convert command to convert data files to the target platform's endian format, if required.

  3.

  Perform a full transportable export on the source database with the parameters VERSION=12, TRANSPORTABLE=ALWAYS, and FULL=Y.

  4.

  Transport the data files for all the user-defined tablespaces.

  5.

  Transport the export dump file to the target database.

  6.

  Perform an import on the target database by using the FULL, NETWORK_LINK, and TRANSPORT_DATAFILES parameters.

  7.

  Perform an import on the target database by using the full and TRANSPORT_DATAFILES parameters.

  Identify the minimum required steps in the correct order.

  A. 1, 3, 5, 4, 2, and 7

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

  C. 2, 4, 5, 3 and 7

  D. 1, 4, 5, 2 and 6

  E. 3, 5, 4, 2, and 7

  Correct Answer: A

• Question 186:

  Which two are true about Oracle Secure Backup (OSB)? (Choose two.)

  A. It can be used to take proxy copies to tape.

  B. It can be used to take image copy backups to tape.

  C. It can be used to manage tape backup and restore operations for files.

  D. RMAN can backup up databases to OSB without requiring media manager channel parameters.

  E. It can be used to manage tape backup and restore operations for files systems.

  Correct Answer: CE

  Reference: https://docs.oracle.com/cd/B19306_01/backup.102/b14234/obadm_arc.htm

• Question 187:

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

  SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

  Which two are required for the successful execution? (Choose two.)

  A. The database must be in ARCHIVELOG mode.

  B. Flashback Database must be enabled.

  C. The Fast Recovery Area must be configured.

  D. The database must be mounted.

  E. Undo retention guarantee must be enabled.

  F. The database must be opened.

  Correct Answer: AC

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

• Question 188:

  Flashback Data Archive has been configured to retain data on all transactions that modify a table for a

  period of four years.

  Three years later, it is decided to change the retention period.

  You execute this command:

  SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;

  Which is true?

  A. An error is returned because the retention period cannot be reduced.

  B. Data from the first and third years is purged from the flashback archive FDA1.

  C. Flashback archive FDA1 retains all data and the retention period is increased by 2 years.

  D. Data older than two years, if any, is purged from the flashback archive FDA1.

  E. Data from the third year is purged from the flashback archive FDA1.

  Correct Answer: C

• Question 189:

  Your database is in ARCHIVELOG mode and is open.

  You issue this command successfully:

  

  Which two are true? (Choose two.)

  A. Online logs are backed up.

  B. The backup becomes obsolete after one day.

  C. The restore point is automatically deleted after one day.

  D. The restore point TESTDB06 is created.

  E. The existing restore point TESTDB06 is updated.

  F. Archived redo logs are backed up.

  Correct Answer: BE

  Reference: https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV835

• Question 190:

  Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

  A. to report on the database schema at an earlier point in time

  B. to store backups that would cause the controlfile to become too large

  C. to allow database duplication without a connection to the target instance

  D. to allow database duplication without a connection to the auxiliary instance

  E. to store backup metadata that would cause the controlfile to become too large

  Correct Answer: ABC