1z1-034試験無料問題集（148題）「Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP 認定」

出題：1

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 auxdb SKIP READONLY; }
Which two statements describe the effect after the database is duplicated successfully? (Choose two)

A. The read-only tablespaces in the target database are changed to online after duplication

B. The read-only tablespaces in the target database are not defined in the new database

C. The data files of the read-only tablespaces in the target database are not duplicated

D. The read-only tablespaces in the target database are still defined in new the database

E. The data files of the read-only tablespaces in the target database get duplicated

正解：C,D 解答を投票する

出題：2

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

A. Only one nested subplan is allowed per parent plan

B. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

C. Nested plans control only the degree of parallelism and I/O requests

D. Nested plans only control resources used by recursive SQL

E. The plans can be nested up to four levels.

正解：B 解答を投票する

出題：3

Which two statements are true about the duplexing of the backups taken by RMAN?

A. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

B. It's only supported for the backups performed on the tape

C. It is not supported for backup operations that produce image copies

D. Duplex backups need a parallelism for the device to be equal to number of copies

正解：A,C 解答を投票する

出題：4

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?

A. Move objects to another schema that has the same tablespace assigned

B. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

C. Perform Export before TSPITR and Import after TSPITR

D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

正解：C 解答を投票する

出題：5

Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

B. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.

C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.

D. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.

正解：C 解答を投票する

出題：6

While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours.
Which view would you query to determine the name and status of the stopped job?

A. DBA_DATAPUMP_SESSIONS

B. DBA_JOBS

C. V$SESSION_LONGOPS

D. V$SESSION

E. DBA_DATAPUMP_JOBS

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z1-034試験無料問題集「Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP 認定」