1z0-043
单选题You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）A the alert log file and the trace filesBthe redo log fi
题目
the alert log file and the trace files
the redo log files
the control file
the change tracking file
相似问题和答案
第1题：
You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）
- A、Add the user， SYSTEM， to the schemas option.
- B、Add the network_link = devdb.us.oracle.com option.
- C、Change the dumpfile option to schema.dat@devdb.us.oracle.com.
- D、Replace the schemas option with the network_link = devdb.us.oracle.com
- E、Replace the dumpfile option with the network_link = devdb.us.oracle.com
正确答案:E
第2题：
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose？（）
- A、 flash back the corrupted blocks
- B、 use the DBMS_REPAIR package
- C、 use the RMAN TSPITR command
- D、 use the RMAN BLOCKRECOVER command
- E、 use the RESTORE DATABASE and RECOVER DATABASE commands
- F、 investigate the time at which the corruption occurred and perform a point-in-time recovery
正确答案:D
第3题：
You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
第4题：
You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）
- A、the alert log file and the trace files
- B、 the redo log files
- C、 the control file
- D、 the change tracking file
正确答案:A
第5题：
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 package
- B、 by using the DB_BLOCK_CHECKING parameter
- C、 by using the DBVERIFY utility
- D、 will not be completely resolved until the hardware fault is corrected
正确答案:D
第6题：
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctl>START What statement is true？（）
- A、It would attempt to start the default listener
- B、It would start the most recently created listener.
- C、It would display an error with a message asking for the listener name to be specified.
- D、It would show you a list of listeners and prompts for the listener name that you want to start.
正确答案:A
第7题：
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
正确答案:C
第8题：
You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）
- A、ORA_PATH
- B、ORACLE_SID
- C、ORACLE_BASE
- D、ORACLE_HOME
- E、LD_LIBRARY_PATH
正确答案:B
第9题：
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）
- A、V$DATABASE
- B、DBA_TABLES
- C、SYSAUD$
- D、EMP
正确答案:B
第10题：
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 package
- B、 by using the DBVERIFY utility
- C、 by using Block Media Recovery
- D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
正确答案:C