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.

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
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...
3766 0
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.
3087 0
|
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.
860 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...
805 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.
1888 0
OCP-052考试题库汇总(42)-CUUG内部解答版
You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2'...
836 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.
739 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 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。
682 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。
628 0
|
数据库 关系型数据库 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 ...
751 0