1z1-034 Exam Training Practice Tests (Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP)]

Question 1

Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

A. It is opened in RESTRICT mode after a duplicating operation. B. It is a copy or a subset of the target database. C. It is created by using backups and archived redo log files from the target database. D. It is created with the same database identifier (DBID) as that of target database.

Correct Answer: B,C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

Your database is in NOARCHIVELOG mode.
One of the two data files belonging to the SYSTEM tablespace is corrupt.
You discover that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file using RMAN?

A. Shut down the instance if not already shut down, restart in mount state, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance. B. Shut down the instance if not already shut down, restart in mount state, restore all data files for the entire database from the last backup, and restart the instance. C. Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance. D. Shut down the instance if not already shut down, restart In MOUNT state, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance. E. Shut down the instance if not already shut down, restart in MOUNT state, restore both data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

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. RMAN does not support backup and recovery of the change tracking file. C. The change tracking file must be created after the first level 0 backup. D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Correct Answer: B,D

Question 4

Which two statements are true regarding hot patching? (Choose two.)

A. It works only in a single database instance environment. B. It does not require database instance shutdown. C. It requires relinking of the Oracle binary. D. It can detect conflicts between two online patches. E. It is available for installing all patches on all platforms.

Correct Answer: B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.
You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:
SQL> SELECT object_name, original_name, droptime FROM recyclebin;

What would be the outcome of the precedent statement?

A. It retrieves the latest version of the table from the recycle bin B. It retrieves the version of the table for which undo information is available C. It retrieves the oldest version of the table from the recycle bin D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

Correct Answer: A

Question 6

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:
SQL> startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
Why did the instance fail to start?
Exhibit:

A. Because the PGA_AGGREGATE_TARGET parameter is not set B. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal C. Because both the SGA_TARGET and MEMORY_TARGET parameters are set. D. Because the STATISTICS_LEVEL parameter is set to BASIC

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?

A. Incomplete Recovery with system change number (SCN) B. Complete Recovery with online redo log C. Tablespace Point-in-Time Recovery (TSPITR) D. Complete Recovery with archived redo log

Correct Answer: C

Question 8

You observed the following output for a user session:

What do you infer from the preceding output?

A. The threshold warning limit is exceeded for the tablespace that is used by the user session B. The user session has entered into a deadlock C. The database instance is enabled to use asynchronous commit D. Resumable set for session with sid 18

Correct Answer: D

Question 9

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
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
Which statement is true regarding the approach in the command?

A. It is the use of asynchronous I/O by RMAN. B. It is an implementation of a multi section backup. C. The RMAN multiplexing level is 4. D. It is a case of parallelization of the backup set.

Correct Answer: D

Question 10

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 that are not currently in OFFLINE mode B. all disks in the disk group only if all of them are ONLINE C. all disks that are currently in OFFLINE mode D. all disks in the disk group

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z1-034 Exam Practice Test