随笔分类 - OCP
OCP考试学习
摘要:The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value?(Choose all that apply.)A. The initialization parameter should
阅读全文
摘要:What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?A. CONFIGURE DEFAULT DEVICE TYPE TO TA
阅读全文
摘要:What feature comes into play to help ensure the completion of the backup should one of threebackup devices fail during a backup that is using three di
阅读全文
摘要:Which dynamic view displays the status of block-change tracking?A. V$BLOCK_CHANGEB. V$BLOCK_CHANGE_TRACKINGC. V$BLOCKCHANGED. V$BLOCK_TRACKING The V$B
阅读全文
摘要:Which of the following most closely represents an image copy?A. Unix cp command of a fileB. Bit-by-bit copy of a fileC. Windows COPY command of a file
阅读全文
摘要:Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?A. shutdown immediate from R
阅读全文
摘要:Which backup option defines a user-defined name for a backup?A. FORMATB. NAMEC. TAGD. FORMAT U% The TAG is used to name a backup with a user-defined c
阅读全文
摘要:Which type of backup must be performed first with an incremental backup?A. Level 1B. Level 0C. Level 2D. Level 3 A level-0 backup copies all the used
阅读全文
摘要:Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?A. Differential incremental backupB. D
阅读全文
摘要:Which of the following best describes a full backup?A. All datafiles of a databaseB. All datafiles, archive logs, and control filesC. All datafiles an
阅读全文
摘要:Which is the correct command to back up the database, back up the archived redo logs, and thenremove the backed-up archived redo logs?A. backup databa
阅读全文
摘要:Which command creates an image copy?A. backup as copyB. backup copyC. copy as backupD. copy back The backup as copy command is used to create an image
阅读全文
摘要:Compressed backups work with which of the following commands?A. copy as backupB. backup as copyC. backupD. copy Compressed backups work only wtih back
阅读全文
摘要:Consider the following command:Backup database plus archivelog delete input;How many backup sets would be created by this command if the following wer
阅读全文
摘要:What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup group The backup set is stored in a pr
阅读全文
摘要:How is block-change tracking enabled?A. With alter database enable block change trackingB. With alter system enable block change trackingC. With an in
阅读全文
摘要:During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you
阅读全文
摘要:You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/200
阅读全文
摘要:You have lost datafile 4 from your database.Which is typically the fastest way to restore your database?A. Restore and recover the datafile. B. Restor
阅读全文
摘要:What does the SCN represent?A. The system change number, which is a point in time relative to transactions within a given database.B. A number that re
阅读全文
浙公网安备 33010602011771号