1Z0-034 Online Practice Questions and Answers

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

A. ALTER DISKGROUP misc MOUNT;

B. ALTER DISKGROUP misc DROP DISK misc2;

C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;

D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;

E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators.

In addition, reports are generated using complex joins with non-equality operators. What table organization is the best for this workload?

A. heap table

B. object table

C. external table

D. sorted hash clustered table

E. global temporary table

F. hash clustered table

Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and

control files regularly.

You are informed that some important tables in the BILLING tablespace have been dropped on February

28, 2007 at 10.30 AM and must be recovered.

You decide to perform an incomplete recovery using the following command:

SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';

Identify the files that must be restored to recover the missing tables successfully.

A. Restore the backup of all the data files.

B. Restore the backup of all the data files and the control file.

C. Restore the backup of only the data files that contain the dropped tables.

D. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.

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 read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.

Which of the following steps are required to transport a tablespace from the database to the targetdatabase:

1.

Make the tablespace read-only at the source database.

2.

Export metadata from the source database.

3.

Convert data filed by using Recovery Manager (RMAN).

4.

Transfer the dump file and data filed to the target machine.

5.

Import metadata at the target database.

6.

Make the tablespace read/write at the target database.

Exhibit: A. 2, 4, and 5

B. All the steps

C. 2, 3, 4 and 5

D. 1, 2, 4, 5 and 6

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.

What two are the prerequisites for enabling Flashback Database?

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined

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 basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:

1.

Restore an autobackup of the server parameter file.

2.

Restore the control file

3.

Start the target database instance

4.

Mount the database

5.

Restore the data files

6.

Open the database with RESETLOGS option

7.

Recover the data files

8.

Set DBID for the target database

Which option illustrates the correct sequence that you must use?

A. 8, 1, 3, 2, 4, 5, 7, 6

B. 1, 8, 3, 4, 2, 5, 7, 6

C. 1, 3, 4, 2, 8, 5, 6, 7

D. 1, 3, 2, 4, 6, 5, 7, 8

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

A. Testing the backup and recovery procedures

B. Testing the upgrade of an Oracle database to a new release

C. Testing the effect of an application changes on database performance

D. Continuously updating archive log files from the target database to support failover

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 server to be accessed using Direct NFS.

3.

Replace the ODM library libodm11.so_stub with libodm11.so.

A. 2 and 3

B. 1 and 3

C. 1 and 2

D. 1, 2 and 3

Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

A. configuring control file autobackup to be ON

B. backing up data filed only and not the archived redo log files

C. running the recovery catalog database in NOARCHIVELOG mode.

D. setting the retention policy to a REDUNDANCY value greater than 1

E. backing up the recovery catalog to the same disk as that of the target database