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 ...
791 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.
993 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...
789 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.
1877 0
|
SQL
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.
8272 0
|
XML SQL 数据库
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 ----...
913 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.
723 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 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。
673 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.
680 0
|
关系型数据库 Oracle 存储
OCP-052考试题库汇总(23)-CUUG内部解答版
11g版本的OCP考试持续了好几年,一直比较稳定,直到2018年4月份左右,052考试不断的出现新的考题,虽然我们收集整理了不少,但新题还是难避免,这样出现一部分新题,我们收集一部分,持续了不短的时间。
1087 0