Aaudit trail
Balert log file
Cuser trace file
Donline trace file
Ebackground trace file
Foperating system event viewer
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
单选题查看答案
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?()
单选题查看答案
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()
单选题查看答案
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
单选题查看答案
Given: When line 14 is reached, how many objects are eligible for the garbage collector?()
单选题查看答案
Exhibit, error You work as a database administrator for Supportcenter.cn. When you try to connect to the database, you get an error (See exhibit). What could be the possible reason for getting such an error?()
单选题查看答案
When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()
多选题查看答案
You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command: LSNRCTL>STATUS listener1 Which information will NOT be displayed when you issue the above command?()
单选题查看答案
You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason, and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem?()
单选题查看答案