单项选择题

You have configured the ASM instance for the PROD datab……

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.

<上一题目录下一题>

热门试题

单项选择题Duringtablespacecreation，whichfilenameformatisNOTusedforcreatingdatafilesassociatedwithatablespace？（）

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

单项选择题YouaretheDatabaseAdministratorforWonderWeb，whichhasrecentlyacquiredamediacompanyTXGlobal.YouhavebeenassignedthetasktomigrateallthedatabaseapplicationsofTXGlobaltothedatabaseserverofWonderWeb.Toaccommodatemoredatabaseapplications，youneedtoadddiskstotheexistingdiskgroup.Wheneveryouaddorremovedisksfromthediskgroup，AutomaticStorageManagement（ASM）rebalancingdistributesthedataevenlyacrossallthedisksofthediskgroup.Whichbackgroundprocessperformsthisactualrebalancingactivity，resultinginthemovementofdataextentsinthediskgroups？（）

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*’；