网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Your alert log file has the following information： Tue May 25 17：43：38 2004 ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly？（）
A
examine the trace file and kill the session that caused the deadlock
B
examine the trace file and kill both the sessions responsible for the deadlock
C
examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
D
examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
E
examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
参考答案
参考解析
解析：
暂无解析
更多 “单选题Your alert log file has the following information： Tue May 25 17：43：38 2004 ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly？（）A examine the trace file and kill the session that caused the deadlockB examine the trace file and kill both the sessions responsible for the deadlockC examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock” 相关考题
考题
You executed the following command:RMAN RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()
A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails
考题
Youralertlogfilehasthefollowinginformation：TueMay2517：43：382004ORA-00060：Deadlockdetected.Moreinfoinfile/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly？（）A.examinethetracefileandkillthesessionthatcausedthedeadlockB.examinethetracefileandkillboththesessionsresponsibleforthedeadlockC.examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransactionD.examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabaseE.examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock
考题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this?（）A. The listener is not running on the database node.B. The TNS_ADMIN environment variable is set to the wrong value.C. The orcl.oracle.com database service is not registered with the listener.D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E. The listener is running on a different port.
考题
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)A、An entry is created in the alert log file and the database instance continues to function normallyB、The log switch hangs occur for transactions until free space is available in the flash recovery areaC、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaD、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
考题
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 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 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
考题
Your tnsnames.ora file has the following entry for the service alias ORCL： ORCL = （DESCRIPTION = （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521）） （CONNECT_DATA = （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com） ） ） The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command： SQL CONNECT scott/tiger@orcl What could be the reason for this？（）A、The listener is not running at the server.B、The TNS_ADMIN environmental variable is set to a wrong value.C、The orcl.oracle.com database service is not registered with the listener.D、The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.
考题
You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（） A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
考题
You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyB、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC、 Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfD、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
考题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL CONNECT scott/tiger@orcl What could be the reason for this?（）A、The listener is not running on the database node.B、The TNS_ADMIN environment variable is set to the wrong value.C、The orcl.oracle.com database service is not registered with the listener.D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E、The listener is running on a different port.
考题
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
考题
What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）A、MTTR Advisor would be disabled.B、Redo Log Advisor would be disabled.C、Automatic tuning of checkpoint would be disabled.D、Checkpoint information would not be written to the alert log file.
考题
Examine the following values of the initialization parameters in the database having the SID ORCL： BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value： ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository （ADR） home？（）A、 /u01/app/oracle/product/11.1.0/db_1B、 /u01/app/oracleC、 $ORACLE_HOME/bdumpD、 $ORACLE_HOME/log
考题
Your alert log file has the following information： Tue May 25 17：43：38 2004 ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly？（）A、examine the trace file and kill the session that caused the deadlockB、examine the trace file and kill both the sessions responsible for the deadlockC、examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
考题
What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（） A、The filename format. B、Information stored inside a data dictionary table. C、Information stored in the ALERT.LOG file for the corresponding instance. D、Information stored inside the corresponding initialization parameter file for the instance.
考题
单选题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
考题
单选题Your tnsnames.ora file has the following entry for the service alias ORCL： ORCL = （DESCRIPTION = （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521）） （CONNECT_DATA = （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com） ） ） The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command： SQL CONNECT scott/tiger@orcl What could be the reason for this？（）A
The listener is not running at the server.B
The TNS_ADMIN environmental variable is set to a wrong value.C
The orcl.oracle.com database service is not registered with the listener.D
The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA 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
考题
单选题What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）A
MTTR Advisor would be disabled.B
Redo Log Advisor would be disabled.C
Automatic tuning of checkpoint would be disabled.D
Checkpoint information would not be written to the alert log file.
考题
单选题Examine the following values of the initialization parameters in the database having the SID ORCL： BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value： ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository （ADR） home？（）A
/u01/app/oracle/product/11.1.0/db_1B
/u01/app/oracleC
$ORACLE_HOME/bdumpD
$ORACLE_HOME/log
考题
单选题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
考题
单选题Your alert log file has the following information： Tue May 25 17：43：38 2004 ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly？（）A
examine the trace file and kill the session that caused the deadlockB
examine the trace file and kill both the sessions responsible for the deadlockC
examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD
examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE
examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
考题
单选题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
考题
单选题You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（）A
The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B
The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C
Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D
Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
考题
单选题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
考题
单选题The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL CONNECT scott/tiger@orcl What could be the reason for this?（）A
The listener is not running on the database node.B
The TNS_ADMIN environment variable is set to the wrong value.C
The orcl.oracle.com database service is not registered with the listener.D
The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E
The listener is running on a different port.
考题
单选题You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）A
The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyB
The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC
Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfD
Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
热门标签
最新试卷
