1Z0-034 Exam Questions
152 real 1Z0-034 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #101
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...
- Question #102
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?
- Question #103
The DB_BLOCK_CHECKING parameter is set to FULL. What checks occur each time the DBWnprocess(es) writes?
- Question #104
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...
- Question #105
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?
- Question #106
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...
- Question #107
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...
- Question #108
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...
- Question #109
Which two statements are true about the duplexing of the backups taken by RMAN?
- Question #110
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...
- Question #112
Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?
- Question #113
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.)
- Question #114
Which four resources can directives be specified by using the Oracle Resource Manager?
- Question #115
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?
- Question #116
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...
- Question #117
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...
- Question #118
Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)
- Question #119
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>...
- Question #120
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...
- Question #121
Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?
- Question #122
Which three statements are true about windows?
- Question #123
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...
- Question #124
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...
- Question #125
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...
- Question #126
Identify three key features of Oracle Data Pump (Choose three.)
- Question #127
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...
- Question #128
Which statement is true about a Scheduler-generated event?
- Question #129
Which three elements can a job chain process involve? (Choose three)
- Question #130
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...
- Question #131
Which three tasks can be performed using a duplicate database? (Choose three.)
- Question #132
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...
- Question #133
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...
- Question #134
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...
- Question #135
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)
- Question #136
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...
- Question #137
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?
- Question #138
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...
- Question #139
You executed the following command In Recovery Manager {RMAN): RMAN>REPORTNEEDBACKUPdays 3; What is the output of this command?
- Question #140
Examine the parameter settings in your database. Which statement is correct about the database?
- Question #142
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...
- Question #143
The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?
- Question #144
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...
- Question #145
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...
- Question #146
Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)
- Question #148
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?
- Question #149
Identify two correct statements about the Active Session History (ASH) data.
- Question #150
Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).
- Question #151
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...
- Question #152
Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)
- Question #153
Which statement is true regarding the VALIDATE DATABASE command?