Which of the followi...

单项选择题X 纠错

Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）

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.

参考答案：

进入题库练习

单项选择题

You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）

A. INSTANCE_TYPE
B. DB_UNIQUE_NAME
C. ASM_DISKSTRING
D. ASM_POWER_LIMIT

点击查看答案进入题库练习

单项选择题

Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）

A. You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
B. You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
C. You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
D. You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

点击查看答案进入题库练习

单项选择题

You execute the following command to start an Automatic Storage Management （ASM） instance： SQL>STARTUP；
In which of the following modes will the ASM instance start？（）

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

点击查看答案进入题库练习

单项选择题

You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）

A. BACKUP AS BACKUPSET
B. BACKUP AS COPY
C. BACKUP AS COMPRESSED BACKUPSET
D. BACKUP INCREMENTAL LEVEL n CUMULATIVE

点击查看答案进入题库练习

单项选择题

You have configured the ASM instance for the PROD database of iPod Corporation. You have specified the following parameter values in the initialization parameter file：
DB_CREATE_FILE_DEST=’devices/grp1/P’
DB_CREATE_ONLINE_LOG_DEST_1=’devices/d_grp2/Q’
DB_CREATE_ONLINE_LOG_DEST_2=’devices/d_grp3/R’
BACKGROUND_DUMP_DEST=’devices/d_grp1/S’
You have added a new redo log group that contains two redo log members. Where are the redo log members stored？（）

A. Both the members will be stored in the ’devices/grp1/P’ directory.
B. Both the members will be stored in the ’devices/d_grp2/Q’ directory.
C. Both the members will be stored in the ’devices/d_grp3/R’ directory.
D. One member will be stored in the ’devices/d_grp2/Q’ directory and the other in the ’devices/d_grp3/R’ directory.

点击查看答案进入题库练习

单项选择题

During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）

A. incomplete names
B. incomplete names with templates
C. alias with template names
D. numeric names

点击查看答案进入题库练习

单项选择题

You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：
INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M
ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM
You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

A. only the INSTANCE_TYPE initialization parameter is set to an invalid value
B. only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
C. only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
D. both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

点击查看答案进入题库练习

单项选择题

You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.
Which information is NOT required during the migration process？（）

A. Database Identifier （DBID）
B. names and location of datafiles
C. names and location of control files
D. names and location of online redo log files

点击查看答案进入题库练习

单项选择题

You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）

A. ASMB
B. ARBn
C. RBAL in the ASM instance
D. RBAL in the database instance

点击查看答案进入题库练习

单项选择题

Consider the following configuration：
/devices/diskP1 is a member of disk group grp1.
/devices/diskP2 is a member of disk group grp1.
/devices/diskP3 is a member of disk group grp1.
/devices/diskP4 is a candidate disk.
/devices/diskQ1 is a member of disk group grp2.
/devices/diskQ2 is a member of disk group grp2.
/devices/diskQ3 is a member of disk group grp2.
/devices/diskQ4 is a candidate disk.
Which command will add the disk /devices/diskP4 to the disk group， grp1？（）

A. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP1’， ADD DISK ’/devices/diskP4’；
B. ALTER DISKGROUP grp1 ADD DISK ’/devices/disk*4’；
C. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP*’；
D. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskQ*’， ADD DISK ’/devices/diskP*’；

点击查看答案进入题库练习