网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 filesB the redo log filesC the control fileD the change tracking file” 相关考题
考题
Where do you find information about a missing redo log file？（）A、trace fileB、audit trailC、control fileD、alert log fileE、event viewer
考题
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.
考题
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， 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 blocksB、use the DBMS_REPAIR packageC、use the RMAN TSPITR commandD、use the RMAN BLOCKRECOVER commandE、use the RESTORE DATABASE and RECOVER DATABASE commandsF、investigate the time at which the corruption occurred and perform a point-in-time recovery
考题
You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）A、 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.B、 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.C、 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.D、 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
考题
Identify the two situations in which the alert log file is updated with details. （）A、Running a query on a table returns "ORA-600： Internal Error."B、Inserting a value in a table returns "ORA-01722： invalid number."C、Creating a table returns "ORA-00955： name is already used by an existing object."D、Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."E、Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.
考题
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A、Shared pool B、Control file C、SGA D、PGA
考题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
考题
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）A、audit trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer
考题
You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file？（）A、USER_DUMP_DESTB、CORE_DUMP_DESTC、ALERT_LOG_DESTD、ALERT_DUMP_DESTE、TRACE_DUMP_DESTF、BACKGROUND_DUMP_DEST
考题
In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）A、The database instance aborts.B、The database operation temporarily halts till the member becomes available.C、Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.D、The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.E、The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
考题
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 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 filesB、 the redo log filesC、 the control fileD、 the change tracking 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 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 blocksB
use the DBMS_REPAIR packageC
use the RMAN TSPITR commandD
use the RMAN BLOCKRECOVER commandE
use the RESTORE DATABASE and RECOVER DATABASE commandsF
investigate the time at which the corruption occurred and perform a point-in-time recovery
考题
单选题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
考题
多选题In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）AThe database instance aborts.BThe database operation temporarily halts till the member becomes available.CWriting proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.DThe member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.EThe status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
考题
单选题Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： 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 blocksB
use the DBMS_REPAIR packageC
use the RMAN TSPITR commandD
use the RMAN BLOCKRECOVER commandE
use the RESTORE DATABASE and RECOVER DATABASE commandsF
investigate the time at which the corruption occurred and perform a pointintime recovery
考题
单选题When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）A
audit trailB
alert log fileC
user trace fileD
online trace fileE
background trace fileF
operating system event viewer
考题
单选题You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）A
The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.B
The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.C
The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.D
The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
考题
单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A
Shared pool B
Control file C
SGA D
PGA
考题
多选题Identify the two situations in which the alert log file is updated with details. （）ARunning a query on a table returns ORA-600： Internal Error.BInserting a value in a table returns ORA-01722： invalid number.CCreating a table returns ORA-00955： name is already used by an existing object.DInserting a value in a table returns ORA-00001： unique constraint （SYS.PK_TECHP） violated.ERebuilding an index using ALTER INDEX ...REBUILD fails with an error ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.
考题
单选题You created a response file and want to check it before starting installations in silent mode. You started installation of Oracle software in interactive mode by providing the response file. In the middle of the installation， you realize that the behavior of the Oracle Universal Installer （OUI） is not consistent with the response file. What action would you take to detect the cause of this behavior？（）A
Compare the contents of the install.log file with the response file.B
Refer to the contents of the oraInst.loc file to verify the steps performed by OUI.C
Compare the contents of the installActions.log file with that of the response file.D
Refer to the alert log file for information regarding the actions performed by OUI during installation.
考题
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）A
online redo log filesB
alert log filesC
control fileD
datafiles associated with the SYSTEM tablespace
考题
单选题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 managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A
One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B
One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C
One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D
One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
考题
单选题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 work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file？（）A
USER_DUMP_DESTB
CORE_DUMP_DESTC
ALERT_LOG_DESTD
ALERT_DUMP_DESTE
TRACE_DUMP_DESTF
BACKGROUND_DUMP_DEST
热门标签
最新试卷
