1z1-034 試験問題を無料オンラインアクセス

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 a case of parallelization of the backup set.
• B.It is the use of asynchronous I/O by RMAN.
• C.It is an implementation of a multisection backup.
• D.The RMAN multiplexing level is 4.

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.sorted hash clustered table
• B.heap table
• C.hash clustered table
• D.global temporary table
• E.object table
• F.external table

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MMDD. The default format of which two data types would be affected by this setting?

• A.INTERVAL YEAR TO MONTH
• B.DATE
• C.TIMESTAMP
• D.INTERVAL DAY TO SECOND
• E.TIMESTAMP WITH LOCAL TIME ZONE

Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

• A.all DDL statements having bind variables
• B.distributed transactions
• C.direct path load of data from external files
• D.flashback query
• E.logging in and logging out of sessions

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.
Which statement is true while performing a tape backup in an RMAN session?

• A.The tape buffer is allocated from the Program Global Area (PGA)
• B.The tape buffer is allocated from the System Global Area (SGA)
• C.The tape I/O performed is asynchronous
• D.Oracle I/O uses an interrupt mechanism to determine when each I/O completes