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 groups？（）

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

A . Oracle Migration Assistant B . Recovery Manager （RMAN） C . Oracle Data Pump Export and Import D . conventional Oracle Export and Import E . operating system utilities to copy the files to the ASM instance

A . Thread creation must be routed through a dispatcher process B . The local listener may spawn a now process and have that new process create a thread C . Each Oracle process runs an SCMN thread. D . Each multithreaded Oracle process has an SCMN thread. E . The local listener may pass the request to an existing process which in turn will create a thread.

A .  OPEN B .  MOUNT C .  NORMAL D .  NOMOUNT

A .  The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances. B .  RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group. C .  The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk. D .  ASM compatibility controls which features for the ASM will be enabled.

A .  100KB default， 10TB maximum B .  256KB default， 1024MB maximum C .  10MB default， 126PB maximum D .  64KB default， 1EB maximum E .  1MB default， 64MB maximum

A .  SGA B .  Database processes C .  Database datafiles D .  Control files E .  Database parameter file or spfile

A .  ASMB B .  PMON C .  RBAL D .  SMON

A . 100KB default, 10TB maximum B . 256KB default, 1024MB maximum C . 10MB default, 126PB maximum D . 64KB default, 1EB maximum E . 1MB default, 64MB maximum

A .  If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down. B .  If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately. C .  If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down. D .  If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

A .  int ia = new int [15]； B .  float fa = new float [20]； C .  char ca = “Some String”； D .  Object oa = new float[20]； E .  Int ia = （4， 5， 6） （1， 2， 3）

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

A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

A . The RDBMSs connected will shutdown abort too B . CLUSTER SERVICE will shutdown C . ASM wil do instance recovery after startu

A .  ASM_DISKMOUNT B .  ASM_DISKGROUP C .  ASM_DISKSTRING D .  ASM_MOUNTGROUP

A . The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, and DGROUP3. The underlying disks for these disk groups have apparently been lost. B . The format of the ASM_DISKGROUPS parameter is incorrect. It should reference the disk group numbers, not the names of the disk groups C . The ASM_POWER_LIMIT parameter is incorrectly set to 1. It should be set to the number of disk groups being attached to the ASM instance. D . The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible. E . There is insufficient information to solve this problem.

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

A . ASMB B . PMON C . RBAL D . SMON

A .  ALTER SYSTEM KILL SESSION B .  ALTER SYSTEM DISCONNECT SESSION C .  ALTER SYSTEM QUIESCE RESTRICTED D .  ALTER SYSTEM ENABLE RESTRICTED SESSION

A .  DB_CACHE_SIZE B .  SHARED_POOL_SIZE C .  LARGE_POOL_SIZE D .  JAVA_POOL_SIZE E .  SGA_MAX_SIZE F .  SORT_AREA_SIZE

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL＞ CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK ‘/devices/diska1‘, ‘/devices/diska2‘FAILGROUP controller2 DISK ‘/devices/diskb1‘, ‘/devices/diskb2‘ ;What happens when the whole CONTROLLER1 Failure group is damaged？（） A. The transactions that use the disk group will halt. B. The mirroring of allocation units occurs within the CONTROLLER2 failure group. C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered. D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

A.increasethenumberofcheckpointprocesses B.definethePOWERoptionwhileaddingorremovingthedisks C.increasethenumberofDBWRprocessesbysettingupahighervalueforDB_WRITER_PROCESSES D.increasethenumberofslavedatabasewriterprocessesbysettingupahighervaluefor DBWR_IO_SLAVES E.increasethenumberofASMRebalanceprocessesbysettingupahighervalueforASM_POWER_LIMITduringthediskadditionorremovalprocess

A. Thread creation must be routed through a dispatcher process B. The local listener may spawn a now process and have that new process create a thread C. Each Oracle process runs an SCMN thread. D. Each multithreaded Oracle process has an SCMN thread. E. The local listener may pass the request to an existing process which in turn will create a thread.

A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5; B. ALTER DISKGROUP dg1 UNDROP; C. ALTER DISKGROUP dg1 UNDROP DISKS; D. You cannot cancel the pending disk drops.