网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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
考题
Examine the section of the Health Check report given below:Which two statements are true regarding the Health Check report?()
A. Health Check was performed manually.B. Health Check was performed to check the disk image block corruptions.C. Health Check was performed to check interblock and intersegment corruption.D. Health Check was performed to verify the integrity of database files and report failures.E. Health Check was performed by the Health Monitor automatically in response to a critical error.
考题
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.
考题
Which two statements are true about the RMAN validate database command?()
A. It checks the database for intrablock corruptions.B. It can detect corrupt pfiles.C. It can detect corrupt spfiles.D. It checks the database for interblock corruptions.E. It can detect corrupt block change tracking files.
考题
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN >BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）A. Corrupted blocks, if any, are repaired.B. Checks are performed for physical corruptions.C. Checks are performed for logical corruptions.D. Checks are performed to confirm whether all database files exist in correct locationsE. Backup sets containing both data files and archive logs are created.
考题
Which two statements are true about the RMAN validate database command?（）A、It checks the database for intrablock corruptions.B、It can detect corrupt pfiles.C、It can detect corrupt spfiles.D、It checks the database for interblock corruptions.E、It can detect corrupt block change tracking files.
考题
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）A、Corrupted blocks, if any, are repaired.B、Checks are performed for physical corruptions.C、Checks are performed for logical corruptions.D、Checks are performed to confirm whether all database files exist in correct locationsE、Backup sets containing both data files and archive logs are created.
考题
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
考题
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.
考题
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 backups B、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 consumed.D、Using this command to create backups improves the performance of the backup process
考题
Which of the following are correct about block media recovery？（）A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONB、 Logical corruptions are repairable by BMRC、 Physical corruptions are repairable by BMRD、 RMAN can use any backup for a BMR restoreE、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore
考题
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.
考题
Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（） A、 Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.B、 Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.C、 Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.D、 Health Monitor checks are always initiated manually when there is some critical error.
考题
You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A、 Create a backup of the database and recover all corrupted blocks found in the backup.B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
考题
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？（）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
考题
单选题You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A
Create a backup of the database and recover all corrupted blocks found in the backup.B
Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C
Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D
Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E
Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
考题
多选题You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）ACorrupted blocks, if any, are repaired.BChecks are performed for physical corruptions.CChecks are performed for logical corruptions.DChecks are performed to confirm whether all database files exist in correct locationsEBackup sets containing both data files and archive logs are created.
考题
单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A
You can perform online whole database backups.B
You can performofflinewhole database backups.C
You cannot perform schema-level export/import operations.D
You can perform the backup of only the SYSTEM tablespace when the database is open.
考题
单选题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.
考题
多选题Which two statements are true about the RMAN validate database command?（）AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect corrupt block change tracking files.
考题
单选题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 backups B
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 consumed.D
Using this command to create backups improves the performance of the backup process
考题
单选题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？（）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
考题
单选题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
考题
单选题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
考题
单选题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？（）A
RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B
RMAN reads the block change tracking file when it performs both incremental backups.C
RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D
RMAN does not read the block change tracking file when it performs either incremental backup.
考题
多选题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.
考题
单选题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
热门标签
最新试卷