单选题There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）Athe DBNEWID utilityBthe DBVERIFY utilityCthe ANALYZE commandDthe RMAN R

题目
单选题
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）
A

 the DBNEWID utility

B

 the DBVERIFY utility

C

 the ANALYZE command

D

 the RMAN REPORT command

E

 the RMAN CROSSCHECK command

F

 the CHECK_OBJECT procedure of the DBMS_REPAIR package

相似考题

1.Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure

2.You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.What should you do?A．Select the commit on successful completion check box of the DTS package.B．Select the commit transaction on successful completion of this step check box of the customers transform. data task.C．Select the commit transaction on successful completion of this step check box of the sales transform. data task.D．Select the commit transaction on successful completion of this step check box of both transform. data tasks.

3.Your data recovery strategy must meet the following requirements:·Back up all data files and folders in C:\Data.·Restore individual files and folders in C:\Data.·Ensure that data is backed up to and restored from external media.What should you do?（）A.AB.BC.CD.D

4.You want to perform the following operations for the DATA ASM disk group:Which command accomplishes these tasks?()A. ALTER DISKGROUP data CHECK;B. ALTER DISKGROUP data CHECK DISK;C. ALTER DISKGROUP data CHECK FILE;D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

参考答案和解析
正确答案： D
解析： 暂无解析
更多“There was media failure and you need to check the data files”相关问题

  • 第1题：

    You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.What should you do?（）

    A.A

    B.B

    C.C

    D.D


    参考答案：C

  • 第2题：

    You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

    • A、On startup， SMON coordinates instance recovery.
    • B、On startup， CKPT coordinates instance recovery.
    • C、On startup， use RMAN to perform instance recovery.
    • D、Uncommitted changes will be rolled back after the database is opened.
    • E、On startup， perform media recovery and then instance recovery.
    • F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

    正确答案:A,D

  • 第3题：

    There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） 

    • A、the DBNEWID utility
    • B、the DBVERIFY utility
    • C、the ANALYZE command
    • D、the RMAN REPORT command
    • E、the RMAN CROSSCHECK command
    • F、the CHECK_OBJECT procedure of the DBMS_REPAIR package

    正确答案:B

  • 第4题：

    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

    • A、 You do not need to restore all the data files.
    • B、 You do not need to open the database with the RESETLOGS operation
    • C、 You do not need to perform a full backup after the RESETLOGS operation.
    • D、 You do not need to recover all the data files to the same system change number （SCN）.

    正确答案:C

  • 第5题：

    When you use Microsoft Windows Media Player to begin playback of a music file， you receive the following error message： "You do not have the rights to play this file."  You need to configure Windows Media Player to ensure playback of protected digital media.  What should you do？ （）

    • A、Disable the Set clock on devices automatically option.
    • B、Enable the Automatically check if protected files need to be refreshed option.
    • C、Enable the Update music files by retrieving media info from the Internet option.
    • D、Enable the Download usage rights automatically when I play or sync a file option.

    正确答案:D

  • 第6题：

    单选题
    There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）
    A

    the DBNEWID utility

    B

    the DBVERIFY utility

    C

    the ANALYZE command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the CHECK_OBJECT procedure of the DBMS_REPAIR package


    正确答案： E
    解析： 暂无解析

  • 第7题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）
    A

    On startup， SMON coordinates instance recovery.

    B

    On startup， CKPT coordinates instance recovery.

    C

    On startup， use RMAN to perform instance recovery.

    D

    Uncommitted changes will be rolled back after the database is opened.

    E

    On startup， perform media recovery and then instance recovery.

    F

    On startup， all the files will be synchronized and you get both committed and uncommitted data.


    正确答案： B,F
    解析： 暂无解析

  • 第11题：

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files， USERDATA01.dbf， in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


    正确答案： E,F
    解析： 暂无解析

  • 第12题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Certkiller .com has a file server named Certkiller -SR07 that stores old inventory files. Certkiller .com has given you the task of creating an application to archive these old inventory files.The inventory files have to be compressed prior to being uploaded to Certkiller .com‘s Web server.You are currently writing a method that will receive a byte array and compress it into a new file.You need to ensure that a data corruption check takes place during the decompression process.What should you do?（）

    A.

    B.

    C.

    D.


    参考答案：D

  • 第14题：

    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

    • A、 redo logs
    • B、 control file
    • C、 temporary files of temporary tablespace
    • D、 the latest backup of only the damaged data file
    • E、 the latest backup of all the data files In the USERS tablespace

    正确答案:A,B,D

  • 第15题：

    You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk.  -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？

    • A、 ALTER DISKGROUP data CHECK
    • B、 ALTER DISKGROUP data CHECK DISK
    • C、 ALTER DISKGROUP data CHECK FILE
    • D、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1

    正确答案:A

  • 第16题：

    You are the network administrator for The network consists of a single Active Directory domain named The domain contains Windows Server 2003 computers and Windows XP Professional computers. All confidential company files are stored on a file server named TestKing1. The written company security states that all confidential data must be stored and transmitted in a secure manner. To comply with the security policy, you enable Encrypting File System (EFS) on the confidential files. You also add EFS certificates to the data decryption field (DDF) of the confidential files for the users who need to access them. While performing network monitoring, you notice that the confidential files that are stored on TestKing1 are being transmitted over the network without encryption. You must ensure that encryption is always used when the confidential files on TestKing1 are stored and transmitted over the network. What are two possible ways to accomplish this goal? （）(Each correct answer presents a complete solution. Choose two)

    • A、Enable offline files for the confidential files that are stored on TestKing1, and select the Encrypt offline files to secure data check box on the client computers of the users who need to access the files.
    • B、Use IPSec encryption between TestKing1 and the client computers of the users who need to access the confidential files.
    • C、Use Server Message Block (SMB) signing between TestKing1 and the client computers of the users who need to access the confidential files.
    • D、Disable all LM and NTLM authentication methods on TestKing1.
    • E、Use IIS to publish the confidential files. Enable SSL on the IIS server. Open the files as a Web folder.

    正确答案:B,E

  • 第17题：

    单选题
    You are formulating the backup strategy for Active Directory Lightweight Directory Services （AD LDS） to ensure that data and log files are backed up regularly. This will also ensure the continued availability of data to applications and users in the event of a system failure. Because you have limited media resources， you decided to backup only specific ADLDS instance instead of taking backup of the entire volume.  What should you do to accomplish this task（）
    A

    Use Windows Server backup utility and enable checkbox to take only backup of database and log files of AD LDS

    B

    Use Dsdbutil.exe tool to create installation media that corresponds only to the ADLDS instance

    C

    Move AD LDS database and log files on a separate volume and use windows server backup utility

    D

    None of the above


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


    正确答案： C
    解析： 暂无解析

  • 第19题：

    多选题
    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
    A

    redo logs

    B

    control file

    C

    temporary files of temporary tablespace

    D

    the latest backup of only the damaged data file

    E

    the latest backup of all the data files In the USERS tablespace


    正确答案： A,B,D
    解析： 暂无解析

  • 第20题：

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


    正确答案： D,B
    解析： 暂无解析

  • 第21题：

    单选题
    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
    A

     You do not need to restore all the data files.

    B

     You do not need to open the database with the RESETLOGS operation

    C

     You do not need to perform a full backup after the RESETLOGS operation.

    D

     You do not need to recover all the data files to the same system change number （SCN）.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You are the network administrator for The network consists of a single Active Directory domain All network servers run Windows Server 2003. One member server hosts a folder named F:/TestKingData. Thousands of users constantly request and updates files in F:/TestKingData. You use the Backup utility to perform an incremental backup of F:/TestKingData on magnetic tape. The backup completes normally, but you see an error indicator illuminated on the tape server. You need to verify that you can restore F:/TestKingData from the backup tape. The verification process must not affect existing files. What should you do?（）
    A

    In the Backup utility, use the Restore and Manage Media tab to select the original tape media. Ensure that files will be restored to their original location. Start the restoration and verify that all files are restored successfully.

    B

    In the Backup utility, use the Restore and Manage Media tab to select the original tape media. Ensure that files will be restored to a new location. Start the restoration and verify that all files are restored successfully.

    C

    In the Backup utility, select the Verify data after the backup completes option. Use the original backup tape to perform another incremental backup. Ensure that all files are verifies successfully.

    D

    In the Backup utility, select the Verify data after the backup completes option. Use a new backup tape to perform another incremental backup. When the verification phase of the backup begins, replace the new tape with the original tape. Ensure that all files are verified successfully.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk.  -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？
    A

     ALTER DISKGROUP data CHECK

    B

     ALTER DISKGROUP data CHECK DISK

    C

     ALTER DISKGROUP data CHECK FILE

    D

     ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


    正确答案： A
    解析： 暂无解析

相关内容