fixed views
the alert log file
the parameter file
the server parameter file
dynamic performance views
第1题:
In your production database there is a job, CALC_STAT, which has been scheduled to run every Friday at 5:00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic, thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this?()
第2题:
A customer reports the optical drive is no longer responding. Which of the following questionsshould be asked FIRST?()
第3题:
My money______. Could you please lend me some?
A. has run out of
B. has run out
C. was run out of
D. has been run out
9.答案为B 我的钱用完了。你能借我点吗?run out“用完”,主语一般为物,无需用被动语态,run out of“用完,耗尽”,后需接宾语,主语一般是人。
第4题:
You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()
第5题:
During initial cluster planning session, a requirement is mandated that application monitoring will Be used to monitor the production database and three application servers. Since all the application servers rely on the database being active, only one resource group has been planned to manage the starting/stopping of the cluster resources. How ill the initial design impact the use of application monitoring?()
第6题:
The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information?()
第7题:
WebSphere Commerce has been successfully installed and tested. WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator. What could be the cause of this problem?()
第8题:
Where there has been delay in carrying goods, the measure of damages ________ generally the difference between the market value of the goods at the time when they ought to have been delivered and the time when they were in fact delivered.
A.have
B.has
C.are
D.is
第9题:
In your production database, data manipulation language (DML) operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information. Whataction would you take to achieve this task()
第10题:
Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However, when you observe the Memory Advisor on a Friday, you find that the statistics are available only for two days, Thursday and Friday, of that week. What would have caused the statistics to be removed?()