随笔分类 -  OCP

上一页 1 ··· 7 8 9 10 11 12 13 14 15 ··· 38 下一页
OCP考试学习
052-61
摘要：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 阅读全文
posted @ 2017-12-07 17:59 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-60
摘要：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 阅读全文
posted @ 2017-12-07 15:30 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
052-57
摘要：Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly becaus 阅读全文
posted @ 2017-12-07 15:18 巴啦啦大魔王 阅读(82) 评论(0) 推荐(0)
052-55
摘要：View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experience 阅读全文
posted @ 2017-12-07 15:04 巴啦啦大魔王 阅读(208) 评论(0) 推荐(0)
052-54
摘要：Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are manag 阅读全文
posted @ 2017-12-07 14:48 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
052-51
摘要：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 阅读全文
posted @ 2017-12-07 14:18 巴啦啦大魔王 阅读(181) 评论(0) 推荐(0)
052-50
摘要：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 阅读全文
posted @ 2017-12-07 13:25 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-49
摘要：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 阅读全文
posted @ 2017-12-07 11:35 巴啦啦大魔王 阅读(77) 评论(0) 推荐(0)
052-48
摘要：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 阅读全文
posted @ 2017-12-07 11:26 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
052-47
摘要：Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_ 阅读全文
posted @ 2017-12-07 11:16 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
052-46
摘要：Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)A.The ADDM requires at least four AWR snapshots for 阅读全文
posted @ 2017-12-07 11:06 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
052-45
摘要：Which statement is true about the Manageability Monitor (MMON) background process?A.It transfers statistics from memory to disk at regular intervals.B 阅读全文
posted @ 2017-12-07 10:58 巴啦啦大魔王 阅读(73) 评论(0) 推荐(0)
052-44
摘要：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 阅读全文
posted @ 2017-12-07 10:53 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
052-43
摘要：In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?A.Optimizer statistics ar 阅读全文
posted @ 2017-12-07 10:48 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
052-42
摘要：Examine the command:SQL> DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');Which statement describes the effect of the above command?A 阅读全文
posted @ 2017-12-07 10:44 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
052-41
摘要：You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on 阅读全文
posted @ 2017-12-07 10:22 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
052-40
摘要：You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be o 阅读全文
posted @ 2017-12-05 16:43 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
052-38
摘要：To make audit information more productive, the DBA executes the following command before starting an audit operation:SQL> ALTER SYSTEM SET AUDIT_TRAIL 阅读全文
posted @ 2017-12-05 16:39 巴啦啦大魔王 阅读(80) 评论(0) 推荐(0)
052-37
摘要：You execute the following command to audit database activities:SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of 阅读全文
posted @ 2017-12-05 16:30 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
052-36
摘要：In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the 阅读全文
posted @ 2017-12-05 15:51 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)

上一页 1 ··· 7 8 9 10 11 12 13 14 15 ··· 38 下一页