网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题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 utilityB the DBVERIFY utilityC the ANALYZE commandD the RMAN REPORT commandE the RMAN CROSSCHECK commandF the CHECK_OBJECT procedure of the DBMS_REPAIR package” 相关考题
考题
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
考题
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;
考题
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.
考题
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
考题
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.AB.BC.CD.D
考题
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.
考题
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.
考题
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 logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
考题
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 utilityB、the DBVERIFY utilityC、the ANALYZE commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the CHECK_OBJECT procedure of the DBMS_REPAIR package
考题
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 CHECKB、 ALTER DISKGROUP data CHECK DISKC、 ALTER DISKGROUP data CHECK FILED、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
考题
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 operationC、 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).
考题
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.
考题
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.
考题
单选题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 LDSB
Use Dsdbutil.exe tool to create installation media that corresponds only to the ADLDS instanceC
Move AD LDS database and log files on a separate volume and use windows server backup utilityD
None of the above
考题
单选题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 utilityB
the DBVERIFY utilityC
the ANALYZE commandD
the RMAN REPORT commandE
the RMAN CROSSCHECK commandF
the CHECK_OBJECT procedure of the DBMS_REPAIR package
考题
单选题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 fileB
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
考题
单选题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 technologyB
restore the data files from backup and perform a complete recoveryC
restore only the corrupted data file and perform tablespace recoveryD
restore the data files from backup and perform cancelbased recoveryE
restore the entire database from the most recent backup and start the instance and open the database
考题
多选题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)?()Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace
考题
单选题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.
考题
多选题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)ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure
考题
单选题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
考题
单选题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 operationC
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).
考题
多选题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?()AOn startup, SMON coordinates instance recovery.BOn startup, CKPT coordinates instance recovery.COn startup, use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup, perform media recovery and then instance recovery.FOn startup, all the files will be synchronized and you get both committed and uncommitted data.
考题
单选题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.
考题
多选题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)?()ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure
考题
单选题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 CHECKB
ALTER DISKGROUP data CHECK DISKC
ALTER DISKGROUP data CHECK FILED
ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
考题
单选题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.
考题
单选题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 fileB
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
热门标签
最新试卷