摘要：
Which two statements are true about checkpointing? (Choose two.)A. The checkpoint frequency decreases with the smaller redo log file size.B. It ensure 阅读全文
摘要：
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)A.The MTTR advisor wi 阅读全文
摘要：
Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications 阅读全文
摘要：
You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. T 阅读全文
摘要：
Given below is a list of scenarios:1) A user terminates his session abnormally.2) The connection between the server and the client application termina 阅读全文
摘要：
In which of the scenarios will the DBA perform recovery? (Choose all that apply.)A.The alert log file is corrupted.B.A tablespace is accidentally drop 阅读全文
摘要：
Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly becaus 阅读全文
摘要：
View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experience 阅读全文
摘要：
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are manag 阅读全文
摘要：
In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the syst 阅读全文
摘要：
Which two statements are true about alerts? (Choose two.)A.Clearing an alert sends the alert to the alert history.B.Response actions cannot be specifi 阅读全文
摘要：
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:SQL> SELECT reason,met 阅读全文
摘要：
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of t 阅读全文
摘要：
Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_ 阅读全文
摘要：
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)A.The ADDM requires at least four AWR snapshots for 阅读全文
摘要：
Which statement is true about the Manageability Monitor (MMON) background process?A.It transfers statistics from memory to disk at regular intervals.B 阅读全文
摘要：
Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be 阅读全文
摘要：
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?A.Optimizer statistics ar 阅读全文
摘要：
Examine the command:SQL> DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');Which statement describes the effect of the above command?A 阅读全文
摘要：
You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on 阅读全文