AI 助理
备案控制台
开发者社区 数据库 文章 正文

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

2019-08-09 746
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 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 外部表不占用数据库空间

文章标签：
机器学习/深度学习
关系型数据库
Oracle
数据库
bjcuug
目录
相关文章
bjcuug
|
数据安全/隐私保护 关系型数据库 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...
bjcuug
3742 0
bjcuug
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 ...
bjcuug
2839 0
bjcuug
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.
bjcuug
755 0
bjcuug
|
Oracle 关系型数据库 数据库管理
OCP-052考试题库汇总（47）-CUUG内部解答版
Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Oracle ‘s best practices.
bjcuug
836 0
bjcuug
|
SQL 数据库 关系型数据库
OCP-052考试题库汇总（43）-CUUG内部解答版
Which is true about external tables? A)Segments are allocated for external tables. B)They may have indexes.
bjcuug
2146 0
bjcuug
|
数据库 关系型数据库 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.
bjcuug
751 0
bjcuug
|
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.
bjcuug
812 0
bjcuug
|
数据库 关系型数据库 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 ...
bjcuug
727 0
bjcuug
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.
bjcuug
532 0
bjcuug
|
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.
bjcuug
631 0