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？（）

相似题目

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

  A .  import the database from the last export B .  restore all the members in the group from the last backup C .  drop the lost member from the database and then add a new member to the group D .  restore all the database files from the backup and then perform a complete recovery E .  restore all the database files from the backup and then perform an incomplete recovery

  查看最佳答案

• You are working on the Certkiller database.  What is the default name of the alert log file in this database？（）

  A . alert_ Certkiller .log B . alertlog_ Certkiller .log C . alert_log_ Certkiller .log D . Certkiller _alert_log.log E . log_alert_： Certkiller .log F . trace_alert_ Certkiller .log

  查看最佳答案

• A cluster node has been started and has not acquired the resources in the resource groups.  Which log file will show the details of any event script processing that has occurred？（）  

  A .  /tmp/hacmp.out B .  /tmp/clstrmgr.debug C .  /usr/es/adm/cluster.log D .  /var/adm/hacmp/hacmp.out

  查看最佳答案

• When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）

  A . RMAN keeps a list of archive logs in a text file. B . The DBA must manually tell RMAN which archive logs to backup. C . RMAN has access to target control file and/or catalog information. D . RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

  查看最佳答案

• Identify the situations in which you use the alert log file in your database to check the detail.（）

  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 . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

  查看最佳答案

• You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?（）

  A . Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files B . Execute the PURGE BINARY LOGE NOT USED command C . Remove all of the binary log files that have a modification date earlier than today D . Edit the .index file to remove the files you want to delete E . Ensure that none of the attached slaves are using any of the binary logs you want to delete

  查看最佳答案

• A System p administrator has just configured logging system messages with the syslogd daemon.  At boot time which file starts the syslog daemon（）

  A . /etc/rc.tcpip B . /sbin/rc.boot C . /etc/rc.net D . /etc/rc.d

  查看最佳答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

  A . import the database from the last export B . restore all the members in the group from the last backup C . drop the lost member from the database， and then add a new member to the group D . restore all the database files from the backup， and then perform a complete recovery  E . restore all the database files from the backup， and then perform an incomplete recovery

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

  A . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.

  查看最佳答案

• You executed the following commands to find the location of the alert log file： https://assets.asklib.com/images/image2/2018080116265875293.jpg Where is the alert log file stored（）

  A . in the BACKGROUND_DUMP_DEST location； in text format B . in the BACKGROUND_DUMP_DEST location； in XML format C . in the BACKGROUND_DUMP_DEST location； in both text and XML format D . in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in text format E . in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in XML format F . in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in both text and XML format

  查看最佳答案

• You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

  A . Archiving will be disabled because the destination for the redo log files is missing. B . The database instance will shut down and the error details will be logged in the alert log file. C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly. D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

  查看最佳答案

• You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）

  A . NOCHECKSUM B . MAXCORRUPT C . CHECK LOGICAL D . BACKUP INCREMENTAL E . CONFIGURE DEVICE TYPE ... PARALLELISM

  查看最佳答案

• Identify the two situations in which you use the alert log file in your database to check the 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 . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

  查看最佳答案

• Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）

  A . until the last commit B . cannot be recovered C . until the last offline backup D . until the beginning of the last transactio

  查看最佳答案

• Your network contains a domain controller that runs Windows Server 2008 R2.  You need to change the location of the Active Directory log files.   Which tool should you use（）

  A . Dsamain B . Dsmgmt C . Dsmove D . Ntdsutil

  查看最佳答案

• Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）

  A . Transactions are rolled back using redo log files. B . Transactions are rolled forward using redo log files. C . Transactions are rolled back using redo log files and archived log files. D . Transactions are rolled forward using redo log files and rolled back using redo log files.

  查看最佳答案

• You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

  A . The database crashes. B . The DBA needs to re-create the file. C . The file gets re-created automatically. D . The file gets restored automatically from the last backup. E . The DBA needs to perform a complete database recovery. F . The DBA needs to perform an incomplete database recovery.

  查看最佳答案

• You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

  A . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.&e

  查看最佳答案

• 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 rollback 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

  查看最佳答案

• The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） 

  A .  The database will hang. B .  The database will be crashed. C .  The database will be shut down. D .  The LGWR process writes redo log entries to the other redo log member of the Group2 grou

  查看最佳答案

• 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）.

  查看最佳答案

• While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）

  A . Activating the MySQL Enterprise thread pool plugin B . Relocating your data and log files to separate storage devices C . Disconnecting idle localhost client sessions D . Implementing storage engine data compression optio

  查看最佳答案

• If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  A .  Complete database recovery. B .  Incomplete database recovery. C .  Approximate database recovery. D .  Archived database recovery. E .  The database could not be recovered with RMAN.

  查看最佳答案

• The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）

  A .  Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile. B .  Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile. C .  Issue the SERVICES command at the LSNRCTL> prompt. D .  Issue the STATUS command at the LSNRCTL> prompt.

  查看最佳答案