开发者社区数据库文章正文

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

2019-08-14 792

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介： 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.

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.

B)SRVCTL can be used to shut down Oracle instances.

C)SQL* Plus can be used to create databases.

D)SQL*Plus can be used to startup Oracle instances.

E)DBCA can be used to upgrade databases.

F)RMAN can be used to startup Oracle instances.

Answer: BCDF

赵：

SRVCTL 命令可以控制 RAC 数据库中的 instance、listener 以及 services。通常 SRVCTL 在 ORACLE 用户下执行。

1、通过 SRVCTL 命令来 start/stop/check 所有的实例：$ srvctl start|stop|status database -d

2、start/stop 指定的实例： $ srvctl start|stop|status instance -d -i

3、列出当前 RAC 下所有数据库： $ srvctl config database -d

文章标签：

关系型数据库

Oracle

SQL

数据库

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

2827 0 0

bjcuug

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 ...

bjcuug

768 0 0

bjcuug

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.

bjcuug

3048 0 0

bjcuug

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.

bjcuug

963 0 0

bjcuug

SQL 存储 Oracle

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

Examine these facts about objects in the SYSTEM schema: 1.EMP is a table. 2.EMP_PK is a primary key constraint on EMP.

bjcuug

853 0 0

bjcuug

数据安全/隐私保护关系型数据库 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.

bjcuug

692 0 0

bjcuug

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 是客户端工具程序，它们既可以在客户端使用，也可以在服务端使用。

bjcuug

648 0 0

bjcuug

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。

bjcuug

598 0 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

708 0 0

bjcuug

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.

bjcuug

1033 0 0

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

热门文章

最新文章

相关课程

相关电子书