随笔分类 -  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 阅读全文
posted @ 2017-11-09 17:59 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:55 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:49 巴啦啦大魔王 阅读(170) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:45 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:42 巴啦啦大魔王 阅读(67) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:40 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:19 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:13 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:11 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:10 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:05 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:01 巴啦啦大魔王 阅读(76) 评论(0) 推荐(0)
摘要:Compressed backups work with which of the following commands?A. copy as backupB. backup as copyC. backupD. copy Compressed backups work only wtih back 阅读全文
posted @ 2017-11-09 16:58 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
摘要:Consider the following command:Backup database plus archivelog delete input;How many backup sets would be created by this command if the following wer 阅读全文
posted @ 2017-11-09 16:53 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 16:46 巴啦啦大魔王 阅读(109) 评论(0) 推荐(0)
摘要:How is block-change tracking enabled?A. With alter database enable block change trackingB. With alter system enable block change trackingC. With an in 阅读全文
posted @ 2017-11-09 16:38 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 16:31 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 16:27 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 16:21 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 16:18 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)