ITPub博客

（540）Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?A. ADD DIRECTORYB. DROP DISKC. RESIZE DISKD. REBALANCEE. ADD FAILGROUP答案：（A）

（539）How can you reverse the effects of an ALTER DISKGROUP...DROP DISK command if it has already completed?A. Issue the ALTER DISKGROUP...ADD DISK command.B. Issue the ALTER DISKGROUP...UNDROP DISKS command.C. Issue the ALTER DISKGROUP...DROP DISK CANCEL command.D. Retrieve the disk...

（538）Which type of database file is spread across all disks in a disk group?A. All types of files are spread across all disks in the disk group.B. DatafilesC. Redo log filesD. Archived redo log filesE. Control files答案：（A）解析：只要是存储在ASM存储系统中的文件，...

（537）On the development database rac0,there are six raw devices: /dev/raw/raw1 through/dev/raw/raw6./dev/raw/raw1 and/dev/raw/raw2 are 8GB each,and the rest are 6GB each.An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2.Which series of the followi...

（536）Which background process coordinates the rebalance activity for disk groups?A. ORBnB. OSMBC. RBALD. ASMn答案：（C）解析：RBALASM Rebalance Master ProcessCoordinates rebalance activity...

（535）To reference existing ASM files,you need to use a fully qualified ASM filename.Your development database has a disk group named DG2A, the database name is DEV19,and the ASM file that you want to reference is a datafile for the USERS02 tablespace.Which of the following is a valid ASM fi...

（534）How can you reverse the effects of an ALTER DISKGROUP...DROP DISK command if it has not yet completed?A. Issue the ALTER DISKGROUP...ADD DISK command.B. Issue the ALTER DISKGROUP...UNDROP DISKS command.C. Issue the ALTER DISKGROUP...DROP DISK CANCEL command.D. Retrieve the disk...

（533）You want to migrate your database to ASM,so you have done a clean shutdown,made a closed backup of the entire database,noted the location of your control files and online redo log files,and changed your spfile to use OMF.The last step is to run an RMAN script to do the conversion.U...

（532）As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database.Using ASM,you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data(you do not have advanced SAN mirroring technology available to...

（531）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 three disk groups:DGROUP1,DGROUP2,and DGROUP3.     The underlying disks for these disk groups have apparently ...

（530）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. TRANSACTIONALB. IMMEDIATEC. ABORTD. NORMAL答案：（C）

（529）Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?A. ASM_DISKMOUNTB. ASM_DISKGROUPC. ASM_DISKSTRINGD. ASM_MOUNTGROUP答案：（B）

（528）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,1024MB maximumC.10MB default,126PB maximumD.64KB default,1EB maximumE.1MB default,64MB maximum答案：（E）解析：Determ...

（527）What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?A.The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.B.The ASM rebalance operation will consume fewer resources and complete in...

（526）Which of the following is a benefit of ASM fast disk resync?A. Failed disks are taken offline immediately but are not dropped.B. Disk data is never lost.C. By default,the failed disk is not dropped from the disk group ever,protecting you from loss of that disk.D. The failed dis...

（525）What components are present in an ASM instance?(Choose three.)A. SGAB. Database processesC. Database datafilesD. Control filesE. Database parameter file or spfile答案：（A、B、E）

（524）What are three benefits of using ASM?(Choose three.)A. Ease of disk administration and maintenanceB. Load balancing across physical disksC. Software RAID-1 data redundancy with double or triple mirrorsD. Automatic recovery of failed disks答案：（A、B、C）...

（523）The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements?(Choose all that apply.)A. Date formatB. Decimal characterC. Group separatorD. First day of the monthE. None of the aboveF. All of the above答案...

（522）The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?A. Languages for server messagesB. Day and month names and abbreviationsC. Symbols to represent a.m.,p.m.,AD,and BCD. Affirmative and negative response stri...

（521）You notice that a job in a chain has not completed on a nonconstrained RAC database.Which of these are valid reasons why that might occur?A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B. The job affinity is to a service and one...