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: C
OCP-052考试题库汇总（24）-CUUG内部解答版
2019-08-08
410
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《
阿里云开发者社区用户服务协议》和
《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写
侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
Which structure can span multiple data files?A)a bigfile tablespaceB)a permanent tablespaceC)a segmentD)a temporary tablespaceE)an extentAnswer...
目录
相关文章
|
数据安全/隐私保护
关系型数据库
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...
3730
0
0
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
...
2827
0
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.
736
0
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
...
768
0
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.
963
0
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.
8258
0
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
----...
890
0
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.
695
0
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。
598
0
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 是客户端工具程序，它们既可以在客户端使用，也可以在服务端使用。
648
0
0