Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 91:

  You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

  A. The backup as copy can only be taken to disk

  B. The backup as copy can only be taken to tape

  C. Backup can be performed only when the instance is shutdown

  D. Backup will constitute all used and unused blocks in the database

  Correct Answer: AD

• Question 92:

  For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

  A. fixed tables

  B. heap tables

  C. external tables

  D. temporary tables

  E. Index-Organized Tables (IOTs)

  F. views

  Correct Answer: BE

• Question 93:

  The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

  A. The tape I/O performed is asynchronous

  B. The tape buffer is allocated from the System Global Area (SGA)

  C. The tape buffer is allocated from the Program Global Area (PGA)

  D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

  Correct Answer: C

• Question 94:

  What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

  A. An upper limit on how far you can flash back the database, depending on the information in the redo logs

  B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

  C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

  D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space

  Correct Answer: C

• Question 95:

  To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

  A. Multiple change tracking files can be created for a database.

  B. The change tracking file must be created after the first level 0 backup.

  C. RMAN does not support backup and recovery of the change tracking file.

  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

  Correct Answer: CD

• Question 96:

  Examine the following command for RMAN backup:

  RMAN> RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

  BACKUP

  INCREMENTAL LEVEL = 0

  (DATAFILE 1,4,5 CHANNEL c1)

  (DATAFILE 2,3,9 CHANNEL c2)

  (DATAFILE 6,7,8 CHANNEL c3);

  SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

  Which statement is true regarding the approach in the command?

  A. The RMAN multiplexing level is 4.

  B. It is the use of asynchronous I/O by RMAN.

  C. It is a case of parallelization of the backup set.

  D. It is an implementation of a multi section backup.

  Correct Answer: C

• Question 97:

  Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

  A. It's only supported for the backups performed on the tape

  B. It is not supported for backup operations that produce image copies C. Duplex backups need a parallelism for the device to be equal to number of copies

  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

  Correct Answer: BD

• Question 98:

  You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The

  PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog.

  The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes the

  following command to grantprivileges to a new user VPC1 using Oracle Database 11g RMAN executables:

  RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;

  Then you issue the following commands:

  RMAN> CONNECT CATALOG vpc1/oracle@catdb;

  RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"

  What is the outcome of the above commands?

  A. They execute and create a virtual catalog for pre-Oracle 11g clients.

  B. They produce an error because PROD1 and PROD2 databases belong to the older version.

  C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

  D. They produce an error because you need to connect to the target database to execute this packagedprocedure.

  Correct Answer: A

• Question 99:

  The DB_BLOCK_CHECKING parameter is set to FALSE.

  What level of block checking will be performed?

  A. The Oracle database will not perform block checking for any of the data blocks.

  B. The Oracle database will perform block checking for the default permanent tablespace only.

  C. The Oracle database will perform block checking for the data blocks in all user tablespaces.

  D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

  E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

  Correct Answer: D

• Question 100:

  As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the source database are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.

  Which of the following steps are required to transport a tablespace from the database to the targetdatabase:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Convert data filed by using Recovery Manager (RMAN).

  4.

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

  5.

  Import metadata at the target database.

  6.

  Make the tablespace read/write at the target database.

  Exhibit: A. 2, 4, and 5

  

  B. All the steps

  C. 2, 3, 4 and 5

  D. 1, 2, 4, 5 and 6

  Correct Answer: D