Oracle 1Z0-055 問題集

質問 1：
What are the advantages of variable extent size support for large ASM files? (Choose two.)
A. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
B. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
C. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
D. It improves performance in the extended cluster configuration by reading from a local copy of an extent.
正解：A,C

質問 2：
Which two statements are true regarding hot patching? (Choose two.)
A. It does not require database instance shutdown.
B. It can detect conflicts between two online patches.
C. It is available for installing all patches on all platforms.
D. It requires relinking of the Oracle binary.
E. It works only in a single database instance environment.
正解：A,B

質問 3：
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?
A. The backup fails because one of the archived redo log files is missing.
B. During backup, you are prompted for the alternative destination for the missing archived redo log file.
C. The backup succeeds because it fails over to one of the alternative archived redo log destinations.
D. The backup succeeds but it would be without the missing archived log.
正解：C

質問 4：
Which statement describes the effect of table redefinition on the triggers attached to the table?
A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.
B. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
C. All triggers on the table remain valid.
D. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
正解：A

質問 5：
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.
You issued the following RMAN commands to create a duplicate database:
RMAN> CONNECT target sys/sys@APPPROD
RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE
DATABASE DB_FILE_NAME_CONVERT '/oracle/oradata/prod/',
'/scratch/oracle/oradata/dupdb/' SPILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/',
'/scratch/oracle/oradata/dupdb/'
SET SGA_MAX_SIZE = '300M'
SET SGA_TARGET = '250M'
SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/',
'/scratch/oracle/oradata/dupdb/redo/';
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
A. The target database backups should be copied to the source database backup directories.
B. The source database should be open.
C. RMAN should be connected to both the instances as SYSDBA.
D. The target database should be in ARCHIVELOG mode if it is open.
E. The password file must exist for the source database and have the same SYS user password as the target.
正解：C,D,E

質問 6：
Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
A. The LOB values are automatically stored in encrypted mode.
B. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
C. The LOB values are cached by default in the buffer cache.
D. The LOB values are automatically compressed.
正解：B

質問 7：
You executed the following command:
RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';
Which statement regarding the above command is correct?
A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.
B. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.
C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.
D. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.
正解：B