Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 31:

  You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user

  who owns the base recovery catalog is CATOWNER.CATOWNER executes the following command to grant privileges 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 packaged procedure.
  A. They execute and create a virtual catalog for pre-Oracle 11g clients.

• Question 32:

  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.
  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.

• Question 33:

  Examine the following command that is used to duplicate a database on the same host:

  RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }

  Which two statements describe the effect after the database is duplicated successfully? (Choose two)

  A. The data files of the read-only tablespaces in the target database are not duplicated
  B. The read-only tablespaces in the target database are still defined in new the database
  C. The read-only tablespaces in the target database are changed to online after duplication
  D. The data files of the read-only tablespaces in the target database get duplicated
  E. The read-only tablespaces in the target database are not defined in the new database
  A. The data files of the read-only tablespaces in the target database are not duplicated
  B. The read-only tablespaces in the target database are still defined in new the database

• Question 34:

  Which statements are true regarding system-partitioned tables? (Choose all that apply.)

  A. Only a single partitioning key column can be specified.
  B. All DML statements must use partition-extended syntax.
  C. The same physical attributes must be specified for each partition.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.

• Question 35:

  In which two aspects does hot patching differ from conventional patching? (Choose two.)

  A. It consumes more memory compared with conventional patching.
  B. It can be installed and uninstalled via OPatch unlike conventional patching.
  C. It takes more time to install or uninstall compared with conventional patching.
  D. It does not require down time to apply or remove unlike conventional patching.
  E. It is not persistent across instance startup and shutdown unlike conventional patching.
  A. It consumes more memory compared with conventional patching.
  D. It does not require down time to apply or remove unlike conventional patching.

• Question 36:

  Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:

  RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; }

  Which statement is true about the duplicate database in this scenario?

  A. It contains data till the last backup
  B. It contains all data from target database until the current time
  C. It contains all data from only the committed transactions in the target database
  D. It contains all data except that which is used by the transactions in the current online redo file of target database
  D. It contains all data except that which is used by the transactions in the current online redo file of target database

• Question 37:

  Examine the parameter settings in your database.

  

  Which statement is correct about the database?

  A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.
  B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set.
  C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET andSGA_TARGET are set.
  D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
  D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

• Question 38:

  You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the

  DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

  ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';

  To which disks in the disk group will the new value be applicable?

  A. all disks in the disk group
  B. all disks that are currently in OFFLINE mode
  C. all disks that are not currently in OFFLINE mode
  D. all disks in the disk group only if all of them are ONLINE
  C. all disks that are not currently in OFFLINE mode

• Question 39:

  Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following

  error:

  ERROR at line I:

  ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status

  What would be the most efficient way to rectify this error?

  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
  B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
  C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re- create it with new tempfiles.
  D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.
  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

• Question 40:

  Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

  

  A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
  B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
  C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
  D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.
  C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.