Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 121:

  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.
  C. Flashback archive FDA1 retains all data and the retention period is increased by 2 years.

• Question 122:

  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.
  B. It creates a level 1 incremental backup set containing all the previously existing data files.
  D. It creates image copies of all the new data files.

• Question 123:

  Which three requirements must be met before a tablespace can be transported across different platforms? (Choose three.)

  A. Both the source and target databases must use the same character set.
  B. The platforms of both the source and target databases must have the same endian format.
  C. The compatible parameter value must be the same in the source and target databases.
  D. The minimum compatibility level for both the source and target databases must be 10.0.0.
  E. The tablespace to be transported must be in read-only mode.
  A. Both the source and target databases must use the same character set.
  D. The minimum compatibility level for both the source and target databases must be 10.0.0.
  E. The tablespace to be transported must be in read-only mode.

• Question 124:

  Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)

  A. The compatible initialization parameter is set to 10.2 or higher.
  B. There are no guaranteed restore points defined for the database.
  C. The default device for the backup must be set to disk.
  D. The tablespaces are locally managed.
  E. The fast recovery area is less than 50 percent free.
  A. The compatible initialization parameter is set to 10.2 or higher.
  B. There are no guaranteed restore points defined for the database.
  D. The tablespaces are locally managed.

• Question 125:

  Which two statements are true about a multitenant architecture? (Choose two.)

  A. Each pluggable database (PDB) has its own initialization parameter file.
  B. A PDB can have a private undo tablespace.
  C. Log switches occur only at the container database level.
  D. A PDB can have a private temporary tablespace.
  E. Each PDB has a private control file.
  C. Log switches occur only at the container database level.
  D. A PDB can have a private temporary tablespace.

• Question 126:

  Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Import metadata into the target database.

  4.

  Transfer the dump file and data files to the target machine.

  5.

  Convert data files by using Recovery Manager (RMAN).

  6.

  Make the tablespace read-write at the target database. Identify the required steps in the correct order.

  A. 2, 4, and 3
  B. 2, 4, 3, and 5
  C. 1, 5, 2, 4, 3, and 6
  D. 1, 2, 4, 3, and 6
  D. 1, 2, 4, 3, and 6

• Question 127:

  Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs).

  It was started up by using the command which executed successfully with no errors:

  SQL> STARTUP MOUNT

  Which two statements are true? (Choose two.)

  A. All redo logs are opened.
  B. All control files are opened.
  C. All tempfiles are opened.
  D. CDB$ROOT is opened.
  E. The SPFILE is opened.
  A. All redo logs are opened.
  D. CDB$ROOT is opened.

• Question 128:

  You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.

  While opening pdb_1, you get an error:

  SQL> alter pluggable database pdb_1 open;

  ORA-01157: cannot identify/lock data file 11 - see DBWR trace file

  ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf'

  To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:

  RMAN> REPAIR FAILURE;

  Which statement describes the consequence of the command?

  A. The command performs the recovery and closes the failure.
  B. The command produces an error because RMAN is not connected to the target database pdb_1.
  C. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.
  D. The command executes successfully, performs recovery, and opens PDB_1.
  C. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.

• Question 129:

  Which three statements are true about using RMAN without a recovery catalog? (Choose three.)

  A. No archive log deletion policies will be possible.
  B. The REPORT SCHEMA command will report only the current database schema.
  C. CONTROL_FILE_RECORD_KEEP_TIME may need to be increased.
  D. The RMAN backup retention can only be configured to use a redundancy based policy.
  E. Database duplication will require a connection to the target.
  F. CONTROL_FILE_RECORD_KEEP_TIME may need to be decreased.
  B. The REPORT SCHEMA command will report only the current database schema.
  C. CONTROL_FILE_RECORD_KEEP_TIME may need to be increased.
  D. The RMAN backup retention can only be configured to use a redundancy based policy.

• Question 130:

  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.
  A. The database must be in ARCHIVELOG mode.
  C. The Fast Recovery Area must be configured.