随笔分类 -  block

摘要:You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is p 阅读全文
posted @ 2017-11-16 16:45 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
摘要:Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?A. a cumulative level 1 backupB. a different 阅读全文
posted @ 2017-11-16 16:36 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
摘要:The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?A. The Oracle database will perform block checki 阅读全文
posted @ 2017-11-16 14:41 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
摘要:You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these 阅读全文
posted @ 2017-11-16 13:57 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
摘要:You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are tru 阅读全文
posted @ 2017-11-16 13:41 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. Yo 阅读全文
posted @ 2017-11-15 17:37 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
摘要:Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking 阅读全文
posted @ 2017-11-15 16:10 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
摘要:Which two statements are true about an image copy backup? (Choose two.)A. It may only be taken to disk.B. It will contain only the used blocks.C. It w 阅读全文
posted @ 2017-11-15 13:40 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
摘要:While querying the EMPLOYEES table, you receive an ORA-01578 message indicating blockcorruption in File# 1201 and Block# 1968. You analyze the table a 阅读全文
posted @ 2017-11-14 10:11 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
摘要:Which of the following are correct about block media recovery? (Choose all that apply.) A. Physical and logical block corruption is recorded automatic 阅读全文
posted @ 2017-11-13 18:33 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
摘要:Which of the following methods can be used to detect block corruption?A. ANALYZE operationsB. dbvC. SQL queries that access the potentially corrupt bl 阅读全文
posted @ 2017-11-13 18:27 巴啦啦大魔王 阅读(134) 评论(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 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)
摘要: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)