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考试题库汇总(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.
771 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 ...
800 0
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.
1007 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...
798 0
OCP-052考试题库汇总(44)-CUUG内部解答版
Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL.
8280 0
OCP-052考试题库汇总(41)-CUUG内部解答版
Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; NAME VALUE ----...
918 0
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.
732 0
OCP-052考试题库汇总(34)-CUUG内部解答版
Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Diagnostic Repository(ADR) E)master table (MT) Answer: E 赵: 题译:哪里有一个 Exdp 操作跟踪? Master table 是一个临时 table,专门为 import pump 和 export pump 创建的,一旦完成就会自动被 drop。
624 0
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 ...
742 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.
543 0
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等