随笔分类 -  ASM

摘要:What happens if you shutdown abort ASM instance?A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance 阅读全文
posted @ 2017-11-17 13:40 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
摘要:Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?A. A 阅读全文
posted @ 2017-11-16 16:01 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
摘要:You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You 阅读全文
posted @ 2017-11-16 15:03 巴啦啦大魔王 阅读(148) 评论(0) 推荐(0)
摘要:You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK dis 阅读全文
posted @ 2017-11-16 15:02 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
摘要:What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes i 阅读全文
posted @ 2017-11-16 14:44 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:Which two statements are true regarding an Automatic Storage Management (ASM) instance?(Choose two.)A. As ASM instance mounts an ASM control fileB. An 阅读全文
posted @ 2017-11-16 14:39 巴啦啦大魔王 阅读(191) 评论(0) 推荐(0)
摘要:The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration.You executed the following command to startup the Automati 阅读全文
posted @ 2017-11-16 14:09 巴啦啦大魔王 阅读(228) 评论(0) 推荐(0)
摘要:View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).Why does the 阅读全文
posted @ 2017-11-16 11:26 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
摘要:A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP 阅读全文
posted @ 2017-11-15 17:03 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:The following command is executed to shut down an Automatic Storage Management (ASM) instance:SQL>SHUTDOWN ABORT;Which two statements describe the con 阅读全文
posted @ 2017-11-15 14:15 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要:Users are connected to a database instance that is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the A 阅读全文
posted @ 2017-11-15 13:26 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0)
摘要:As the DBA, you run the following query on your ASM instance.What is the implication of the results of the query? (Choose two.)SQL> select group_numbe 阅读全文
posted @ 2017-11-08 13:49 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
摘要:Which background process coordinates the rebalance activity for disk groups?A. ORBnB. OSMBC. RBALD. ASMn RBAL coordinates rebalance activity for a dis 阅读全文
posted @ 2017-11-07 17:41 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
摘要:To reference existing ASM files, you need to use a fully qualified ASM filename. Your developmentdatabase has a disk group named DG2A, the database na 阅读全文
posted @ 2017-11-07 17:36 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
摘要:You want to migrate your database to ASM, so you have done a clean shutdown, made a closedbackup of the entire You wa database, noted the location of 阅读全文
posted @ 2017-11-07 13:54 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0)
摘要:As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in yourdatabase. Using ASM, you want to create a disk group 阅读全文
posted @ 2017-11-07 13:33 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
摘要:When starting up your ASM instance, you receive the following error: What is the cause of the error?A. The ASM_DISKGROUPS parameter is configured for 阅读全文
posted @ 2017-11-07 13:22 巴啦啦大魔王 阅读(155) 评论(0) 推荐(0)
摘要:When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instances disk gr 阅读全文
posted @ 2017-11-07 13:12 巴啦啦大魔王 阅读(169) 评论(0) 推荐(0)
摘要:Which initialization parameter in an ASM instance specifies the disk groups to be automaticallymounted at instance startup?A. ASM_DISKMOUNTB. ASM_DISK 阅读全文
posted @ 2017-11-07 12:23 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?A. 100KB default, 10TB maximumB. 256KB default, 102 阅读全文
posted @ 2017-11-07 12:18 巴啦啦大魔王 阅读(347) 评论(0) 推荐(0)