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?()
第1题:
Your archive-log destination directory runs out of space. What is the impact of this on the database?()
第2题:
在网页页面上输出"HelloWorld"的正确Javascript语法是()。
第3题:
You are working on the Certkiller database. What is the default name of the alert log file in this database?()
第4题:
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?()
第5题:
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?()
第6题:
You work as a database administrator for Supportcenter.cn. 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?()
第7题:
Do nothing.
Restart the database.
Perform recovery on the database.
Restore the alert log from the last backup.
第8题:
alert_ Certkiller .log
alertlog_ Certkiller .log
alert_log_ Certkiller .log
Certkiller _alert_log.log
log_alert_: Certkiller .log
trace_alert_ Certkiller .log
第9题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第10题:
USER_DUMP_DEST
CORE_DUMP_DEST
ALERT_LOG_DEST
ALERT_DUMP_DEST
TRACE_DUMP_DEST
BACKGROUND_DUMP_DEST
第11题:
None of the data definition language (DDL) statements are logged in the trace file.
Only DDL commands that resulted in errors are logged in the alert log file.
A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
Only DDL commands that resulted in the creation of new database files are logged.
第12题:
On each server in your office, use Performance Logs and Alers to create a baseline log. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.
From a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.
On each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.
From a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.
第13题:
在JavaScript中,输出不到网页的是()。
第14题:
A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log?()
第15题:
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?()
第16题:
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()
第17题:
You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()
第18题:
You are one of the network administrators for All network servers run Windows Server 2003. TestKing operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: 1. Track all performance changes on the servers. 2. Record performance data to anticipate the need for future upgrades. What should you do?()
第19题:
The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
Before the instance starts, you receive an error about the missing redo log files of a group.
The instance starts and the database opens with an error message written to the alert log file.
The instance starts and the database opens because two redo log groups still exist.
The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
第20题:
MTTR Advisor would be disabled.
Redo Log Advisor would be disabled.
Automatic tuning of checkpoint would be disabled.
Checkpoint information would not be written to the alert log file.
第21题:
The SGA advisor will be disabled.
The MTTR advisor will be disabled.
Automatic checkpoint tuning will be disabled.
Checkpoint information will not be written to the alert log file.
第22题:
Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
All DDL commands are logged in the alert log file.
All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
Only DDL commands that resulted in the creation of new segments are logged.
All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
第23题:
Archiving will be disabled because the destination for the redo log files is missing.
The database instance will shut down and the error details will be logged in the alert log file.
Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.
Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
第24题:
The database instance aborts.
The database operation temporarily halts till the member becomes available.
Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.