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...
3730 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
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.
3048 0
|
数据库 存储
OCP-052考试题库汇总(48)-CUUG内部解答版
Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.
739 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.
821 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'...
791 0
|
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.
853 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
|
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
|
数据库 关系型数据库 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 ...
708 0