单选题Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database. What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）A datafileB alert logC dynamic viewsD control file script
单选题
Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database. What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）
A
datafile
B
alert log
C
dynamic views
D
control file script
参考解析
解析：
暂无解析
相关考题：
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.
The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?() A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle database will perform block checking for the default permanent tablespace onlyD. The Oracle database will perform block checking for the data blocks in all user tablespacesE. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A、 The Oracle database will not perform block checking for any of the data blocks.B、 The Oracle database will perform block checking for the default permanent tablespace only. C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A、 Block Media Recovery must be used with RMAN.B、 You must perform complete recovery of individual blocks.C、 You must have a full RMAN backup， not an incremental backup.D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.
You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（） A、 Repair the corrupted blocks. If any. In the backup createdB、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocksC、 Back up the database after checking whether array of the files have corrupted blocksD、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewE、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?（）A、The Oracle database will perform block checking for the index blocks only B、The Oracle database will not perform block checking for any of the data blocks C、The Oracle database will perform block checking for the default permanent tablespace only D、The Oracle database will perform block checking for the data blocks in all user tablespaces E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）A、Use the Data Block Wizard and base the relation on a REF pointer. B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（） A、 The Oracle database will perform block checking for the index blocks onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
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 are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）A、 You must ensure that the SALES database is mounted or open.B、 You must restore a backup control file to perform a block media recovery.C、 You must take the tools01.dbf data file offline before you start a block media recovery.D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.
The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A、The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent
You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A、 Only data blocks of the SYSTEM tablespace will be checked.B、 Only data blocks of the SYSAUX tablespace will be checked.C、 A checksum will occur only on the checkpoint.D、 A checksum will occur every time a block is modified.
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB、 Use the ANALYZE utility.C、 Use the DBVERIFY utility.D、 Use the DBMS_REPAIR package.
Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A、Rebuild the index using the online option. B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
单选题You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A Only data blocks of the SYSTEM tablespace will be checked.B Only data blocks of the SYSAUX tablespace will be checked.C A checksum will occur only on the checkpoint.D A checksum will occur every time a block is modified.
单选题While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A Block Media Recovery must be used with RMAN.B You must perform complete recovery of individual blocks.C You must have a full RMAN backup， not an incremental backup.D You must use the DBVERIFY utility before using the Block Media Recovery feature.
单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?（）AThe Oracle database will perform block checking for the index blocks only BThe Oracle database will not perform block checking for any of the data blocks CThe Oracle database will perform block checking for the default permanent tablespace only DThe Oracle database will perform block checking for the data blocks in all user tablespaces EThe Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle
单选题Which statement is true regarding the VALIDATE DATABASE command?（）AIt checks the database for intrablock corruptions only.BIt checks for block corruption in the valid backups of the database.CIt checks the database for both intrablock and interblock corruptions.DIt checks for only those corrupted blocks that are associated with data files.
单选题he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）AUse the Data Block Wizard and base the relation on a REF pointer. BIn the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.CUse the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. DThis task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
单选题Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）ARebuild the index using the online option. BTake the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. CWithout setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. DTake the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
单选题The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A The Oracle database will not perform block checking for any of the data blocks.B The Oracle database will perform block checking for the default permanent tablespace only. C The Oracle database will perform block checking for the data blocks in all user tablespaces.D The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
单选题You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB Use the ANALYZE utility.C Use the DBVERIFY utility.D Use the DBMS_REPAIR package.
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has the Products table. Now you have to replicate the Products table to the SQL Server instances at remote locations, so you create a Merge Replication topology and a Publication to do this. The Publication has a 21-day retention period. There is a user who goes on a business trip, 30 days later he comes back and finds that data in his database is not the latest. The Windows Event log states the following error message: "Replication: expired subscription dropped." You must get the latest data in the user's database and make sure that future data changes are appropriately replicated. So what action should you perform to achieve this goal? （）AYou should recreate the publication BYou should upload unsynchronized changes. CYou should reinitialize the publication and generate a new snapshot at once. DYou should upload unsynchronized changes, and then reinitialize the publication
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A V$FLASHBACK_DATABASE_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT
单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）A The Oracle database will perform block checking for the index blocks onlyB The Oracle database will not perform block checking for any of the data blocksC The Oracle database will perform block checking for the default permanent tablespace onlyD The Oracle database will perform block checking for the data blocks in all user tablespacesE The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
单选题The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）AThe Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.BDBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.CThe Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.DThe Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.EThe Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent