网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）
A
Insert finding directives for ADDM tasks in the future.
B
Create a baseline on a pair of snapshots spanning the peak-load period.
C
Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
D
Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
参考答案
参考解析
解析：
暂无解析
更多 “单选题Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）A Insert finding directives for ADDM tasks in the future.B Create a baseline on a pair of snapshots spanning the peak-load period.C Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.D Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots” 相关考题
考题
多选题Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL *Loader.DNew data conforms to the constraint， but existing data is not checked.EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue（）ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.DDecrease the number of redo log members if there are more than one redo log members available in eachredo log group.
考题
单选题The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects. Which statement is true in this scenario（）A
The statistics collection continues until all objects are processed.B
The job is terminated and the statistics collected are restored to a time before the job started.C
This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.D
The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened
考题
单选题User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A
It fails to delete the records because the records are locked in SHARE mode.B
It deletes the rows successfully because the table is locked in SHARE modeC
It fails to delete the records because the table is locked in EXCLUSIVE mode.D
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
单选题Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）A
Archiver Process （ARCn）： 1， 2， 5B
System Monitor Process （SMON）： 1， 4， 5C
Process Monitor Process （PMON）： 4， 5， 6D
Database Writer Process （DBWn）： 1， 3， 4
考题
多选题Which two activities are NOT supported by the Data Recovery Advisor DRA（）ARecover from failures in the RAC environment.BDiagnose and repair a data file corruption online.CDiagnose and repair a data file corruption offline.DDiagnose and repair failures on a standby database
考题
单选题Identify the logical structure that will never have more than one data segment created for it.（）A
external tableB
partitioned tableC
partitioned indexD
nonclustered tableE
global temporary table
考题
单选题You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）A
CLOBB
BLOBC
BFILED
LONG RAW
考题
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A
7， 1， 5， 2， 3， 6， 4B
1， 2， 3，7， 5， 6， 4C
7， 1， 4， 5， 2， 3， 6D
1， 7， 5， 4， 2， 3， 6
热门标签
最新试卷
