OCP-052考试题库汇总(11)-CUUG内部解答版

简介: Which two are true about Optimizer Statistics?A)They are gathered by the Manageability Monitor(MMON) background process.

Which two are true about Optimizer Statistics?

A)They are gathered by the Manageability Monitor(MMON) background process.

B)They can be gathered by executing the PL/SQL procedures in the DBMS_STATES package.

C)They do not persist across instance restarts.

D)They can be used to determine the events on which a database instance waited.

E)They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements.

F)They are automatically updated when DDL statements execute.

Answer: BE

目录
相关文章
|
数据安全/隐私保护 关系型数据库 Oracle
OCP-052考试题库汇总(60)-CUUG内部解答版
Examine these facts about a database: The database default tablespace to EXAMPLE. DEFERRED_SEGMENT_CREATION is TRUE (原来为 FALSE,题目有错) Examine these co...
3728 0
OCP-052考试题库汇总(58)-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
768 0
|
数据库管理
OCP-052考试题库汇总(46)-CUUG内部解答版
Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Whi...
770 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(45)-CUUG内部解答版
You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column in a table to access the flat file.
1862 0
OCP-052考试题库汇总(42)-CUUG内部解答版
You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2'...
791 0
|
数据安全/隐私保护 关系型数据库 Oracle
OCP-052考试题库汇总(35)-CUUG内部解答版
Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A)If the directory used in the export operation has existing dump files, it overwrites them.
692 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(32)-CUUG内部解答版
Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN IN READ ONLY mode D)OPEN IN RESTRICTED mode E)MOUNT ...
708 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(29)-CUUG内部解答版
When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing.
1033 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(30)-CUUG内部解答版
Which two are true about the Inventory directory? A)It is shared by all Oracle software installations on a single server.
658 0
|
数据库
OCP-052考试题库汇总(26)-CUUG内部解答版
Which three of these must be accessible to keep a database open? A)Control file. B)All members of a redo log group. C)SYSTEM tablespace. D)SYSAUX tablespace. E)spfile Answer: ABC 赵: 1 nomount:实例已经启动,进程和内存已经分配。
675 0