9.11. Review Questions

  1. Extents in an ASM file are allocated in units of which size?

    1. 100KB

    2. 10MB

    3. 1MB

    4. 64KB

  2. To prevent connections to an ASM instance, you can use which of the following commands? (Choose the best answer.)

    1. ALTER SYSTEM ENABLE RESTRICTED SESSION

    2. SHUTDOWN IMMEDIATE

    3. ALTER SYSTEM DISABLE CONNECTIONS

    4. ALTER DATABASE ENABLE RESTRICTED SESSION

  3. Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?

    1. ASM_DISKMOUNT

    2. ASM_DISKGROUP

    3. ASM_DISKSTRING

    4. ASM_MOUNTGROUP

  4. Which of the following command options is not valid for an ASM instance?

    1. STARTUP OPEN

    2. STARTUP NOMOUNT

    3. STARTUP MOUNT

    4. STARTUP OPEN RESTRICT

    5. SHUTDOWN ABORT

  5. When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instance's disk groups?

    1. TRANSACTIONAL

    2. IMMEDIATE

    3. ABORT

    4. NORMAL

    5. None of the above

  6. When creating a disk group, what keyword must be specified if you need to reuse a disk that has previously been used as part of another disk group?

    1. NOFORCE

    2. REUSE

    3. USE

    4. FORCE

    5. INCLUDING CONTENTS

  7. Which of the following ASM file templates is not striped as fine?

    1. FLASHBACK

    2. ARCHIVELOG

    3. CONTROLFILE

    4. ONLINELOG

  8. You want to migrate your database to ASM, so you've 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 running an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?

    1. STARTUP NOMOUNT

    2. ALTER DATABASE OPEN RESETLOGS

    3. SQL "ALTER DATABASE RENAME 'logfile1 path' TO '+dgrp4 '""  # plus all other log files

    4. SWITCH DATABASE TO COPY

    5. BACKUP AS COPY DATABASE FORMAT '+dgrp4'

    6. ALTER DATABASE MOUNT

    7. RESTORE CONTROLFILE FROM 'controlfile_location'

    1. 2, 5, 3, 1, 7, 6, 4

    2. 1, 7, 6, 5, 4, 3, 2

    3. 5, 1, 2, 7, 4, 6, 3

    4. 7, 3, 1, 5, 6, 2, 4

  9. How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?

    1. Issue the ALTER DISKGROUP ... ADD DISK command.

    2. Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    3. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    4. Retrieve the disk from the recycle bin after the operation completes.

  10. 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 filename for this ASM file?

    1. dev19/+DG2A/datafile/users02.701.2

    2. +DG2A/dev19/datafile/users02.701.2

    3. +DG2A/dev19/users02/datafile.701.2

    4. +DG2A.701.2

    5. +DG2A/datafile/dev19.users.02.701.2

  11. Which background process coordinates the rebalance activity for disk groups?

    1. ORBn

    2. OSMB

    3. RBAL

    4. ASMn

  12. 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 following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

    1. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001
CREATE DISKGROUP DATA2 NORMAL REDUNDANCY
  FAILGROUP DATA1A DISK '/dev/raw/raw3
  FAILGROUP DATA1B DISK '/dev/raw/raw4
ALTER DISKGROUP DATA1 UNDROP DISKS

    2. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;
CREATE DISKGROUP DATA2 HIGH REDUNDANCY
  FAILGROUP DATA1A DISK '/dev/raw/raw3'
  FAILGROUP DATA1B DISK '/dev/raw/raw4'
ALTER DISKGROUP DATA1 UNDROP DISKS;

    3. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;
CREATE DISKGROUP DATA2 NORMAL REDUNDANCY
  FAILGROUP DATA1A DISK '/dev/raw/raw3'
  FAILGROUP DATA1B DISK '/dev/raw/raw4';
ALTER DISKGROUP DATA1 UNDROP DATA1_0001;

    4. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001
  ADD DISKGROUP DATA2 NORMAL REDUNDANCY
  FAILGROUP DATA1A DISK '/dev/raw/raw3'
  FAILGROUP DATA1B DISK '/dev/raw/raw4';
ALTER DISKGROUP DATA1 UNDROP DISKS;

  13. Which type of database file is spread across all disks in a disk group?

    1. All types of files are spread across all disks in the disk group.

    2. Datafiles

    3. Redo log files

    4. Archived redo log files

    5. Control files

  14. How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed?

    1. Issue the ALTER DISKGROUP ... ADD DISK command.

    2. Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    3. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    4. Retrieve the disk from the recycle bin after the operation completes.

  15. Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?

    1. ADD DIRECTORY

    2. DROP DISK

    3. RESIZE DISK

    4. REBALANCE

    5. ADD FAILGROUP

  16. If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?

    1. The command fails unless you specify the FORCE option.

    2. The command fails unless you specify the REUSE option.

    3. The command must be reissued with a more specific discovery string.

    4. The other disks already part of the disk group are ignored.

  17. Choose the set of the following initialization parameters that is valid and recommended for an ASM instance.

    1. INSTANCE_TYPE=RDBMS
ASM_POWER_LIMIT=2
LARGE_POOL_SIZE=8MB
DB_UNIQUE_NAME=+ASM
ASM_DISKGROUPS=DATA1,DATA2

    2. INSTANCE_TYPE=ASM
ASM_POWER_LIMIT=2
LARGE_POOL_SIZE=8MB
DB_UNIQUE_NAME=+ASM
ASM_DISKGROUPS=DATA1,DATA2

    3. INSTANCE_TYPE=ASM
ASM_POWER_LIMIT=15
LARGE_POOL_SIZE=8MB
DB_UNIQUE_NAME=+ASM
ASM_DISKGROUPS=DATA1,DATA2

    4. INSTANCE_TYPE=ASM
ASM_POWER_LIMIT=2
LARGE_POOL_SIZE=4MB
DB_UNIQUE_NAME=+ASM
ASM_DISKGROUPS=DATA1,DATA2

  18. Which of the following scenarios concerning ASM instance shutdown is correct?

    1. When an ASM instance is shut down with NORMAL, IMMEDIATE, or TRANSACTIONAL, the same shutdown command is passed to the dependent instances and the ASM instance waits for all dependent instances to shut down before it shuts down.

    2. When an ASM instance shuts down with NORMAL, an alert is sent to all dependent instances, notifying the DBA to shut down the dependent instances manually before the ASM instance shuts down.

    3. When an ASM instance shuts down with the TRANSACTIONAL option, all dependent instances shut down with NORMAL, IMMEDIATE, or TRANSACTIONAL, depending on the dependent database's default.

    4. When an ASM instance is shut down with NORMAL, IMMEDIATE, or TRANSACTIONAL, the same shutdown command is passed to the dependent instances and the ASM instance does not wait for all dependent instances to shut down before it shuts down.

    5. When an ASM instance shuts down with the IMMEDIATE option, the ASM instance shuts down immediately and all dependent instances shut down with ABORT.

  19. A database can create datafiles in how many different disk groups? (Choose the best answer.)

    1. Each datafile in the database can reside in a different disk group.

    2. One

    3. Disk groups manage tablespaces, not datafiles.

    4. A maximum of two, one for SYSTEM and SYSAUX and the other tablespaces in another disk group.

  20. ASM supports all of the following file types except for which of the following? (Choose all that apply.)

    1. Database files

    2. SPFILEs

    3. Redo log files

    4. Archived log files

    5. RMAN backup sets

    6. Password files

    7. init.ora files

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset