网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use?()
A

 FILE

B

 PARFILE

C

 LOGFILE

D

 FEEDBACK


参考答案

参考解析
解析: 暂无解析
更多 “单选题You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use?()A  FILEB  PARFILEC  LOGFILED  FEEDBACK” 相关考题
考题 You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?()A、 LogMinerB、 The DBNEWID utilityC、 The DBVERIFY utilityD、 The ANALYZE commandE、 The RMAN REPORT commandF、 The RMAN CROSSCHECK command.G、 The RMAN BLOCKRECOVER command.

考题 You want to check the EMP table in the user, Scott’s schema for block corruption. You also want to fix the corrupted blocks, if any. How will you accomplish the required task?()A、by using the ANALYZE utilityB、by using the DBVERIFY utilityC、by using the DB_BLOCK_CHECKING parameterD、by using the DBMS_REPAIR package

考题 You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data

考题 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、 The block change tracking feature must be enabled.B、 OMF must be configured on your database.C、 The database must be in ARCHIVELOG mode.D、 A USERID must be supplied.

考题 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 are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.

考题 You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use?()A、 FILEB、 PARFILEC、 LOGFILED、 FEEDBACK

考题 You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data.

考题 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 issued the following command to analyze the SCOTT.EMP table for block corruption:   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE;  You received the following error:   ORA-01578: ORACLE data block corrupted  (file # %s, block # %s)   How will you resolve the block corruption problem?()A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected

考题 You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()A、 Use the CHANGE_PASSWORD command of the Listener control utility.B、 Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.C、 Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.D、 Manually modify the listener.ora file to include the password for the listener and restart the listener.

考题 You issue the following statement:   SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE;  You receive the following error:         01578: ORACLE data block corrupted (file# 6, block # 54)        ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

考题 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 have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 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 a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?()  A、You should run the bulk copy program utility along with an output file and no format fileB、You should run the SQLCmd utility and save the output to a fileC、You should run the SQL Import and Export Data Wizard and save the output to a file.D、You should run the bulk copy program utility along with a format file and an output file.

考题 单选题You issue the following statement:   SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE;  You receive the following error:         01578: ORACLE data block corrupted (file# 6, block # 54)        ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A  by using the DBMS_REPAIR packageB  by using the DBVERIFY utilityC  by using Block Media RecoveryD  by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

考题 单选题You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?()A  LogMinerB  The DBNEWID utilityC  The DBVERIFY utilityD  The ANALYZE commandE  The RMAN REPORT commandF  The RMAN CROSSCHECK command.G  The RMAN BLOCKRECOVER command.

考题 单选题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 check the EMP table in the user, Scott’s schema for block corruption. You also want to fix the corrupted blocks, if any. How will you accomplish the required task?()A by using the ANALYZE utilityB by using the DBVERIFY utilityC by using the DB_BLOCK_CHECKING parameterD by using the DBMS_REPAIR package

考题 单选题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 are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A  The target database must be in the MOUNT mode to ensure restoration of the datafiles.B  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C  The control file must be recreated.D  The database must be opened with the RESETLOGS option.

考题 单选题You issued the following command to analyze the SCOTT.EMP table for block corruption:   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE;  You received the following error:   ORA-01578: ORACLE data block corrupted  (file # %s, block # %s)   How will you resolve the block corruption problem?()A  by using the DBMS_REPAIR packageB  by using the DB_BLOCK_CHECKING parameterC  by using the DBVERIFY utilityD  will not be completely resolved until the hardware fault is corrected

考题 单选题Using vi, you want to save changes to the file myfile with :w!, but vi complains it cannot write to the file. Therefore, you want to check the write permissions on the file. To do this without leaving vi, you type:()A  :!ls-I myfileB  :/ls-l myfileC  esc :Is -I myfileD  :?ls-l myfile

考题 单选题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  The block change tracking feature must be enabled.B  OMF must be configured on your database.C  The database must be in ARCHIVELOG mode.D  A USERID must be supplied.

考题 单选题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 have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()A  You will need to open the database with the resetlogs command.B  All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C  You will use the resetlogs version of the create controlfile command.D  You will use the noresetlogs version of the create controlfile command.E  You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 单选题You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()A  Use the CHANGE_PASSWORD command of the Listener control utility.B  Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.C  Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.D  Manually modify the listener.ora file to include the password for the listener and restart the listener.