The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  

相似题目

• A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A .  Flash back all the tables in the data file， one by one. B .  Restore the data file to a new location and perform a media recovery. C .  Flash back the database， there is no need to restore the data file. D .  Restore the data file from the most recent backup and flash the database.

  查看最佳答案

• You want your Catalyst switch to implement a switching method that holds a packet in its memory until the data portion of the respected packet reaches the switch.Which method should you employ on your Catalyst switch?（）

  A . Fast Forward B . Store and forward C . Frag-free D . None of the above

  查看最佳答案

• ote the following structures in your database server： 1：Extents 2：OS Blocks 3：Tablespace  4：Segments  5：Oracle Data Block  Which option has the correct arrangement of these structures from the smallest to the largest（）

  A . 2， 5， 1， 4， 3 B . 1， 2， 3， 4， 5 C . 5， 2， 1， 3， 4 D . 2， 1， 5， 4， 3

  查看最佳答案

• Which of the following RMAN structures can data from a datafile span？（）

  A .  RMAN backup-set pieces spanning backup sets B .  RMAN backup-set pieces within a given backup set C .  RMAN backups D .  RMAN channels E .  None of the above

  查看最佳答案

• You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）

  A .  all the datafiles in the database B .  the datafiles associated with the SYSTEM tablespace C .  the datafiles associated with the DATA1 tablespace D .  all the datafiles in the database except those associated with the DATA1 tablespace

  查看最佳答案

• You need to design a method to encrypt confidential data. Your solution must address the concerns of the chief information officer. What should you do？（）

  A . Encrypt customer information when it is stored and when it is being transmitted B . Require encrypted connections to the public Web site， which is hosted on the Web server on the perimeter network C . Encrypt all marketing information on file servers and client computers D . Require encrypted connections to all file server

  查看最佳答案

• You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

  A . Restore and recover the datafile.  B . Restore and recover the tablespace.  C . Restore and recover the database.  D . Restore and recover the control file.  E . Restore and recover the parameter file.

  查看最佳答案

• The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMAN>CONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）

  A .  While performing the backup of the datafile，data1.dbf，one backup set is created. B .  While performing the backup of the datafile，data1.dbf，two backup sets are created. C .  While performing the backup of the datafile，data1.dbf，three backup sets are created. D .  While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.

  查看最佳答案

• 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 TRUE B .  Use the ANALYZE utility. C .  Use the DBVERIFY utility. D .  Use the DBMS_REPAIR package.

  查看最佳答案

• You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

  A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded inbitmapblocks. E . The space utilization description of the data blocks in segments is managed through free lists.MANUAL

  查看最佳答案

• hich of the following RMAN structures can data from a datafile span?（）

  A . RMAN backup-set pieces spanning backup sets  B . RMAN backup-set pieces within a given backup sets  C . RMAN backups  D . RMAN channels  E . None of the above

  查看最佳答案

• You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）

  A . The command must be issued in MOUNT state. B . The command succeeds only if the data file is offline. C . The command must be issued when the database is in the archivelog mode. D . The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

  查看最佳答案

• You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

  A . Upgrade the hardware/memory to accommodate the data. B . Load the data into your database by using the PARALLEL clause. C . Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES. D . Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

  查看最佳答案

•  You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）

  A . DEFAULT STORAGE  B . EXTENT MANAGEMENT  C . AUTOEXTEND  D . DATAFILE

  查看最佳答案

• You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

  A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded in bitmap blocks. E . The space utilization description of the data blocks in segments is managed through free lists.

  查看最佳答案

• You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  

  A .  Restore and recover the datafile. B .  Restore and recover the tablespace. C .  Restore and recover the database. D .  Restore and recover the control file. E .  Restore and recover the parameter file.

  查看最佳答案

• Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）

  A . Implement horizontal partitioning. B . Implement vertical partitioning. C . Implement a raw partition. D . Implement distributed partitioning.

  查看最佳答案

• Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）

  A . RESTORE DATAFILE ’/DISK2/user_data01.dbf’ B . RESTORE DATAFILE ’/DISK3/user_data01.dbf’ C . SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’ D . SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf&rsquo

  查看最佳答案

• You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

  A .  Restore the lost data file from the backup， and then flash back the database. B .  Restore the data file pertaining to index tablespace， and then recover the tablespace. C .  Restore all the data files， and then perform an incomplete recovery to get the tablespace back. D .  Restore all the data files， and then perform an incomplete recovery using the backup control file. E .  Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

  查看最佳答案

• If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  A .  Complete database recovery. B .  Incomplete database recovery. C .  Approximate database recovery. D .  Archived database recovery. E .  The database could not be recovered with RMAN.

  查看最佳答案

• A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A . flash back all the tables in the data file， one by one B . restore the data file to a new location and perform a media recovery C . flash back the database; there is no need to restore the data file D . restore the data file from the most recent backup and flash back the database

  查看最佳答案

• Note the following structures in your database server： 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest（）

  A . 2，5，1，4，3 B . 1，2，3，4，5 C . 5，2，1，3，4 D . 2，1，5，4，3

  查看最佳答案

• The procedure part of your method section should detail the procedures used in your experiment. Explain what you had participants do, how you collected data, and the order in which steps occurred.

  查看最佳答案

• The procedure part of your method section should detail the procedures used in your experiment. Explain what you had participants do, how you collected data, and the order in which steps occurred.

  查看最佳答案