随笔分类 - 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
阅读全文
摘要: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
阅读全文
摘要:The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?A. The Oracle database will perform block checki
阅读全文
摘要:You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these
阅读全文
摘要: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
阅读全文
摘要:In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. Yo
阅读全文
摘要:Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking
阅读全文
摘要: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
阅读全文
摘要:While querying the EMPLOYEES table, you receive an ORA-01578 message indicating blockcorruption in File# 1201 and Block# 1968. You analyze the table a
阅读全文
摘要:Which of the following are correct about block media recovery? (Choose all that apply.) A. Physical and logical block corruption is recorded automatic
阅读全文
摘要:Which of the following methods can be used to detect block corruption?A. ANALYZE operationsB. dbvC. SQL queries that access the potentially corrupt bl
阅读全文
摘要: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 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
阅读全文
摘要: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
阅读全文
浙公网安备 33010602011771号