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

简介: Which two are true about Oracle's Optimizer statistics?A)They are automatically updated when ddl statements execute.

Which two are true about Oracle's Optimizer statistics?

A)They are automatically updated when ddl statements execute.

B)They can be calculated exactly.

C)They can be gathered on external tables.

D)They are automatically updated when dml statements execute.

E)They can be estimated.

Answer: BE

赵:

estimated adj. 估计的;预计的;估算的;

目录
相关文章
OCP-052考试题库汇总(59)-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 ...
2830 0
OCP-052考试题库汇总(57)-CUUG内部解答版
Examine these facts about a databases: 1.USERS is the database default tablespace. 2.USER1,USER2,and USER3 have the CREATE SESSION privilege 3.
741 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(49)-CUUG内部解答版
Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE.
968 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.
1864 0
|
SQL 存储 Oracle
OCP-052考试题库汇总(37)-CUUG内部解答版
Examine these facts about objects in the SYSTEM schema: 1.EMP is a table. 2.EMP_PK is a primary key constraint on EMP.
855 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.
697 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.
1040 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.
662 0
OCP-052考试题库汇总(24)-CUUG内部解答版
Which structure can span multiple data files? A)a bigfile tablespace B)a permanent tablespace C)a segment D)a temporary tablespace E)an extent Answer...
413 0
|
存储 数据库
OCP-052考试题库汇总(21)-CUUG内部解答版
Which two are true about the Archive (ARCn) processes? A)They archive redo directly from the redo log buffer.
2715 0