题目内容（请给出正确答案）

[多选题]

用下面的命令关闭asm实例SQL>SHUTDOWNABORT;下面哪两项描述了上面命令的顺序（)。

A.磁盘组顺序卸载

B.当前连接的asm客户端被终止

C.css守护进程关闭，在asm实例重启之前重启该进程

D.asm实例需要恢复当下次启动的时候

查看答案

如果结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装优题宝APP，拍照搜题省时又省心！

更多“用下面的命令关闭asm实例SQL>SHUTDOWNABORT…”相关的问题

第1题

作为一个oracleDBA，你运行以下的SQL命令查询ASM实例，查询结果的含义是什么？()SQL>select group_number,name,state from v$ASM_DISKGROUP;GROUP_NUMBER NAME STATE 0 DGROUP1DISMOUNTED2 DGROUP2 MOUNTED3 DGROUP3 MOUNTED

A.这个查询在ASM实例中没有意义

B.一个多余的磁盘(DGROUP1)将在磁盘组中丢失

C.一个数据文件丢失，原因是DGROUP1磁盘组正在进入DISMOUNTED状态

D.DGROUP1磁盘组被其他的DBA卸载了

点击查看答案

第2题

数据库的关闭过程包括:

A.关闭进程

B.关闭数据库

C.卸载数据库

D.关闭数据库实例

点击查看答案

第3题

Which two statements are true regarding an Automatic Storage Management （ASM) instance？ ()

A. As ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

点击查看答案

第4题

在oracle数据库中，执行下面的命令SQL>ALTERUSERskd ACCOUNTLOCK;有关执行结果下面哪两项描述正确？（)

A.SKD用户的对象不能被任何用户访问

B.用户SKD密码过期，在下次登陆时强制用户修改密码

C.用户SKD不能登陆数据库实例

D.其它用户可以访问SKD用户的对象，当用户已经在访问对象的时候

点击查看答案

第5题

Which two statements are true regarding an Automatic Storage Management （ASM) instance？() （Choosetwo.)

A. As ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

点击查看答案

第6题

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuratio

n. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL＞ STARTUP;Which two activities are performed during a successful start up operation？（）

A. The databases configured to use the ASM instance are mounted

B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

点击查看答案

第7题

You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initial

ization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.Which two statements are true in this scenario for the features enabled for ASM？（）

A. The ASM-preferred mirror read feature is enabled.

B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.

D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

点击查看答案

第8题

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instanc

e. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL＞ shutdown immediate;What is the result of executing this command？（）

A. The ASM instance is shut down, but the other instances are still running.

B. It results in an error because other database instances are connected to it.

C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

点击查看答案

第9题

You are managing an Oracle Database 11g database with the ASM storage. The database is hav

ing big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.What configuration would you effect to achieve your objective？（）

A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

点击查看答案