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

简介: Which four database objects never have any segments?A)A partitioned indexB)A view selecting from a populated tableC)An empty indexD)An Oracle Loader type external tableE)An empty tableF)A view selecting from an empty tableG)An Oracle Data Pump type external tableAnswer: BDFG赵:视图和外部表不存在段。

Which four database objects never have any segments?

A)A partitioned index

B)A view selecting from a populated table

C)An empty index

D)An Oracle Loader type external table

E)An empty table

F)A view selecting from an empty table

G)An Oracle Data Pump type external table

Answer: BDFG

赵:视图和外部表不存在段。

B 译:从填充表中选择的视图。

小明:

B F 视图是虚拟对象,不占用物理空间(物化视图例外)

G D 外部表不占用数据库空间

目录
相关文章
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考试题库汇总(55)-CUUG内部解答版
Examine these facts about a database: 1.USER is the database default tablespace. 2.USER1, USER2, and USER3 have the CREATE SESSION privilege.
3048 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
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(39)-CUUG内部解答版
Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are always stored in the database.
732 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(33)-CUUG内部解答版
Which two can be exported by a non-administrative account by using Data Pump? A)directory objects B)tables C)tablespaces D)schemas E)database Answer: BD 赵: EXP 和 IMP 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。
647 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(31)-CUUG内部解答版
which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used to load data from text files.
792 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考试题库汇总(28)-CUUG内部解答版
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, and not specified.
611 0
OCP-052考试题库汇总(27)-CUUG内部解答版
Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file.
512 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...
409 0