Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 71:

  Which two statements are true about encrypting RMAN backups?

  A. The transparent encryption of backups uses the encryption wallet.
  B. The database uses the same encryption key for every encrypted backup.
  C. The password encryption of backups only uses the password while creating and restoring backups.
  D. If transparent encryption is configured, you cannot use the set encryption by password command to make password-protected backups.
  A. The transparent encryption of backups uses the encryption wallet.
  C. The password encryption of backups only uses the password while creating and restoring backups.

• Question 72:

  Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?

  A. Perform Export before TSPITR and Import after TSPITR
  B. Move objects to another schema that has the same tablespace assigned
  C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
  D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
  A. Perform Export before TSPITR and Import after TSPITR

• Question 73:

  You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

  A. Its entries are specific to a single database.
  B. It contains file systems that have been mounted by Direct NFS.
  C. It is globally available to all Oracle 11g databases on the machine.
  D. It contains file systems that have been mounted by the kernel NFS system.
  C. It is globally available to all Oracle 11g databases on the machine.
  D. It contains file systems that have been mounted by the kernel NFS system.

• Question 74:

  Which two statements are true about a job chain? (Choose two.)

  A. A job chain can contain a nested chain of jobs.
  B. The jobs in a job chain cannot have more than one dependency.
  C. A job of the CHAIN type can be run using event-based or time-based schedules.
  D. The jobs in a job chain can be executed only by using the events generated by the Scheduler
  A. A job chain can contain a nested chain of jobs.
  C. A job of the CHAIN type can be run using event-based or time-based schedules.

• Question 75:

  The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.

  How would you achieve this?

  A. Implement a profile for the users.
  B. Implement external roles for the users.
  C. Set the threshold for the undo tablespace.
  D. Implement a Database Resource Manager plan.
  B. Implement external roles for the users.

• Question 76:

  There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?

  A. the DBNEWID utility
  B. the DBVERIFY utility
  C. the ANALYZE command
  D. the RMAN REPORT command
  E. the RMAN CROSSCHECK command
  F. the CHECK_OBJECT procedure of the DBMS_REPAIR package
  B. the DBVERIFY utility

• Question 77:

  Which two statements are correct about database transportation? (Choose two.)

  A. The source and target platforms must be the same
  B. Redo logs, control files and temp files are also transported
  C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed
  D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
  E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
  D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
  E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

• Question 78:

  Examine the following ALTER command:

  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

  What is the purpose of the command?

  A. It cancels all pending disk drops within the disk group.
  B. It adds previously dropped disks back into the disk group.
  C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
  D. It mounts disks in the disk group for which the drop-disk operation has already been completed.
  E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.
  A. It cancels all pending disk drops within the disk group.

• Question 79:

  You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.

  Which of these methods would you use to achieve this? (Choose all that apply.)

  A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.
  B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
  C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
  D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
  B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
  C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
  D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

• Question 80:

  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.
  A. They execute and create a virtual catalog for pre-Oracle 11g clients.