1z1-034問題集、Oracle実際の試験問題

質問 1

Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

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

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

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

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

正解: C,D

質問 2

Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which perquisite must be met before accomplishing the backup?

A. No setup is required as it is a default encryption method.

B. Set up an Oracle wallet for the encryption.

C. Both Oracle wallet and password must be set up for the encryption.

D. Provide a password for the encryption.

正解: B

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

質問 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. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

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. Multiple change tracking files can be created for a database.

正解: A,B

質問 4

In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It takes more time to install or uninstall compared with conventional patching.

B. It consumes more memory compared with conventional patching.

C. It does not require down time to apply or remove unlike conventional patching.

D. It is not persistent across instance startup and shutdown unlike conventional patching.

E. It can be installed and uninstalled via OPatch unlike conventional patching.

正解: B,C

質問 5

For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

A. Index-Organized Tables (IOTs)

B. temporary tables

C. views

D. heap tables

E. fixed tables

F. external tables

正解: A,D

質問 6

ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A. The data is decrypted during SORT and JOIN operations.

B. The data remains encrypted when it is stored in the redo logs.

C. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

D. The data remains encrypted when it is read into memory.

正解: B

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z1-034 模擬練習