1Z0-034 Exam Questions

The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS optio...

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?

The DB_BLOCK_CHECKING parameter is set to FULL. What checks occur each time the DBWnprocess(es) writes?

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks...

Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the n...

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

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

Which two statements are true about the duplexing of the backups taken by RMAN?

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30...

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

View the Exhibit to examine the replay settings for replay parameters. What is the implication for setting the values for replay parameters? (Choose all that apply.)

Which four resources can directives be specified by using the Oracle Resource Manager?

View the Exhibit and examine the RMAN commands. Which statement describes the effect of a backup retention policy on the backup of a backup set?

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios in which you must have...

View the Exhibit to observe the error. You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is confi...

Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

Given below are RMAN commands to enable backup optimization and set the retention policy: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE BACKUP OPTIMIZATION ON; RMAN>...

View the Exhibit. You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four files using the External Table Population method. You execute the command...

Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?

Which three statements are true about windows?

Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>; 2. SELECT * FROM <table> AS OF SCN 123456; 3. FLASHBACK TABLE <table> TO BEFOR...

View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error: SQ...

View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECU...

Identify three key features of Oracle Data Pump (Choose three.)

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

Which statement is true about a Scheduler-generated event?

Which three elements can a job chain process involve? (Choose three)

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily...

Which three tasks can be performed using a duplicate database? (Choose three.)

Refer to the exhibit. Examine the Following commands and their output: View the Exhibit and examine the Flashback Version Query that was executed after the preceding commands. What...

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condi...

You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the...

Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

Which steps are mandatory to enable Direct NFS? 1. Mount all required file systems using the kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS s...

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?

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance...

You executed the following command In Recovery Manager {RMAN): RMAN>REPORTNEEDBACKUPdays 3; What is the output of this command?

Examine the parameter settings in your database. Which statement is correct about the database?

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

The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?

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

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

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

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

Identify two correct statements about the Active Session History (ASH) data.

Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).

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

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

Which statement is true regarding the VALIDATE DATABASE command?