单选题Which statement is true regarding the VALIDATE DATABASE command?（）A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock

题目内容(请给出正确答案)

单选题

Which statement is true regarding the VALIDATE DATABASE command?（）

It checks the database for intrablock corruptions only.

It checks for block corruption in the valid backups of the database.

It checks the database for both intrablock and interblock corruptions.

It checks for only those corrupted blocks that are associated with data files.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You have the following requirements in relation to the detection of block corruption for your database instance： Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically？（）ASet the DB_SECUREFILE parameter to PERMITTEDBSet the DB_ULTRA_SAFE parameter to DATA_ONLYCSet the DB_LOCK_CHECKSUM parameter to TYPICALDSet the DB_LOST_WRITE_PROTECT parameter to TYPICAL

点击查看答案
第2题

单选题Which statement is true regarding the VALIDATE DATABASE command?（）A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock corruptions.D It checks for only those corrupted blocks that are associated with data files.

点击查看答案
第3题

单选题You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）A DBCC DBREINDEXB SELECT * FROM sys.dm_db_index_physical_statsC DBCC INDEXDEFRAGD SELECT * FROM sys.indexes

点击查看答案
第4题

单选题You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?（）A A different procedure is required to restore a database from compressed backupsB The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.C Using this command to create backups minimizes the bandwidth consumedD Using this command to create backups improves the performance of the backup process

点击查看答案
第5题

单选题You enable block change tracking. You issue the following command： BACKUP INCREMENTAL LEVEL 0 DATABASE； The next day，you issue the following command： BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE； Which statement about the use of the change tracking file is true？（）ARMAN reads the block change tracking file only when it performs the incremental level 0 backup.BRMAN reads the block change tracking file when it performs both incremental backups.CRMAN reads the block change tracking file only when it performs the incremental level 1 backup.DRMAN does not read the block change tracking file when it performs either incremental backup.

点击查看答案
第6题

多选题Which two statements are true regarding the database in ARCHIVELOG mode？（）AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

点击查看答案
第7题

单选题You have the following requirements in relation to the detection of block corruption for your database instance: 1. Check for logical self-consistency of data blocks when modified in memory. 2. Checksums are calculated before and after the block change. 3. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically? （）A Set the DB_SECUREFILE parameter to PERMITTEDB Set the DB_ULTRA_SAFE parameter to DATA_ONLYC Set the DB_LOCK_CHECKSUM parameter to TYPICALD Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

点击查看答案

单选题Which statement is true regarding the VALIDATE DATABASE command?（）A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容