1Z0-034 Online Practice Questions and Answers

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 option?

A. Control files

B. Password file

C. Inactive online redo log file

D. Archived log files required to perform recovery

E. Newly created tablespace which is not backed up

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

A. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

B. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

C. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.

D. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.

E. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

You executed the following command In Recovery Manager {RMAN):

RMAN>REPORTNEEDBACKUPdays 3;

What is the output of this command?

A. a list of files that require a backup within three days

B. a list of files requiring more than 3 days of archive logs to apply

C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

D. a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them

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

View the following SQL statements: Transaction T1

SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT;

Transaction T2

SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT;

Transaction T3

SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5;

You want to back out transaction T2. Which option would you use?

A. It is possible, but transaction T3 also backs out.

B. It is possible with the NOCASCADE_FORCE option.

C. It is possible with the NONCONFLICT_ONLY option.

D. It is not possible because it has conflicts with transaction T3.

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

Exhibit: A. The COMMIT order in the captured workload is preserved during replay.

B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

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

A. You can use RMAN stored scripts.

B. Recovery is faster if data is stored in catalog in addition to the control file.

C. You can store backup information of all registered databases in one place.

D. Database backups are automatically deleted when they are older than the specified time period.

Given below is a list of scenarios:

1) A user terminates his session abnormally.

2) The connection between the server and the client application terminates because of a network failure.

3) A schema is accidentally dropped.

4) The tablespace is accidentally dropped from the database.

5) The hard disk gets corrupted and the data files in the disk are lost.

6) The database instance abnormally shuts down because of power failure.

Which scenarios require DBA intervention to perform recovery?

A. 1, 3, and 6

B. 4, 5, and 6

C. 3, 4, and 5

D. 1, 2, and 6

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