单选题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.

单选题
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.


参考解析

解析: 暂无解析

相关考题:

YouhaveconfiguredtheASMinstanceforthePRODdatabaseofiPodCorporation.Youhavespecifiedthefollowingparametervaluesintheinitializationparameterfile: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’Youhaveaddedanewredologgroupthatcontainstworedologmembers.Wherearetheredologmembersstored?()A.Boththememberswillbestoredinthe’devices/grp1/P’directory.B.Boththememberswillbestoredinthe’devices/d_grp2/Q’directory.C.Boththememberswillbestoredinthe’devices/d_grp3/R’directory.D.Onememberwillbestoredinthe’devices/d_grp2/Q’directoryandtheotherinthe’devices/d_grp3/R’directory.

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.

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD?() A、DB_BLOCK_SIZEB、CONTROL_FILESC、LARGE_POOL_SIZED、LOG_ARCHIVE_DESTE、LOG_ARCHIVE_FORMATF、DB_CREATE_FILE_DEST

You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each. In the parameter file of the production database, the following parameters have been specified: DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting?()A、When a new log group is added, it would have one member in each disk group.B、When a new log group is added, it would have two members in each disk group.C、When a new tablespace is added, it would have one data file in each disk group.D、When a new log file is added, it would have one member spread across the disk groups.

You work as a database administrator for Certkiller .com. In your production  database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task?()A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective?()  A、 Set the ASM compatibility attribute for the ASM disk group to 11.1.0.B、 Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.C、 Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.D、 Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()A、to enable the ASM instance to identify the alert log fileB、to enable the ASM instance to identify the server parameter fileC、to enable the ASM instance to define the locations for Oracle Managed Files (OMF)D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?()A、Set DB_FLASH_CACHE_SIZE=64GB、Set D3_FLASH_CACHE_SIZE=64G, 64GC、Set D3_FLASK_CACKE_SI2E=128GD、db_flash_cache_SI2E is automatically configured by the instance at startup

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_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT

You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file:  DB_BLOCK_CHECKING = TRUE;  What will be the result of setting this parameter?()A、 Only data blocks of the SYSTEM tablespace will be checked.B、 Only data blocks of the SYSAUX tablespace will be checked.C、 A checksum will occur only on the checkpoint.D、 A checksum will occur every time a block is modified.

You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD?()A、 LARGE_POOL_SIZEB、 DB_CREATE_FILE_DESTC、 LOG_ARCHIVE_DESTD、 CONTROL_FILESE、 LOG_ARCHIVE_FORMATF、 DB_BLOCK_SIZE

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 valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

单选题You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file:  DB_BLOCK_CHECKING = TRUE;  What will be the result of setting this parameter?()A Only data blocks of the SYSTEM tablespace will be checked.B Only data blocks of the SYSAUX tablespace will be checked.C A checksum will occur only on the checkpoint.D A checksum will occur every time a block is modified.

单选题You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()A mount the new disk group in the ASM instanceB restart the ASM instance and the production database instanceC register the new disk groups in the production database instanceD restart the ASM instance without restarting the production database instanceE include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

单选题You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD?()A LARGE_POOL_SIZEB DB_CREATE_FILE_DESTC LOG_ARCHIVE_DESTD CONTROL_FILESE LOG_ARCHIVE_FORMATF DB_BLOCK_SIZE

单选题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 valueB only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

单选题You work as a database administrator for Certkiller .com. In your production  database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task?()AYou must have started the database instance in restricted mode.BYou must have started the database instance inNORMALmode.CYou must have started the database instance with server parameter file.DYou must have started the database instance but must not have mounted.EYou must have started the database instance but must not have opened.

单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()Ato enable the ASM instance to identify the alert log fileBto enable the ASM instance to identify the server parameter fileCto enable the ASM instance to define the locations for Oracle Managed Files (OMF)Dto enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1and DG2with one device each. In the parameter file of the production database, the following parameters have been specified:  DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting?()A When a new log group is added, it would have one member in each disk group.B When a new log group is added, it would have two members in each disk group.C When a new tablespace is added, it would have one data file in each disk group.D When a new log file is added, it would have one member spread across the disk groups.

单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each.  In the parameter file of the production database, the following parameters have been specified:  DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting?()AWhen a new log group is added, it would have one member in each disk group.BWhen a new log group is added, it would have two members in each disk group.CWhen a new tablespace is added, it would have one data file in each disk group.DWhen a new log file is added, it would have one member spread across the disk groups.

单选题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_TYPEB DB_UNIQUE_NAMEC ASM_DISKSTRINGD ASM_POWER_LIMIT

单选题You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?()ASet DB_FLASH_CACHE_SIZE=64GBSet D3_FLASH_CACHE_SIZE=64G, 64GCSet D3_FLASK_CACKE_SI2E=128GDdb_flash_cache_SI2E is automatically configured by the instance at startup

单选题You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD?()ADB_BLOCK_SIZEBCONTROL_FILESCLARGE_POOL_SIZEDLOG_ARCHIVE_DESTELOG_ARCHIVE_FORMATFDB_CREATE_FILE_DEST

单选题You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()AThe SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.BThe SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.CThe COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.DThe SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

单选题You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D Increase the value of the SGA_TARGET initialization parameter.