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

B

CONTROL_FILES

C

LARGE_POOL_SIZE

D

LOG_ARCHIVE_DEST

E

LOG_ARCHIVE_FORMAT

F

DB_CREATE_FILE_DEST


参考解析

解析: 暂无解析

相关考题:

You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you notice that the system identifier (SID) for the instance is set to ’+ASM’. What is the purpose of this instance?()A、 This instance is being used to manage the operating system files.B、 This instance is being used to manage the files of other databases.C、 This instance is being used to manage the instances of other databases.D、 This instance is being used to manage the background processes of other instances.

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

n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、 Oracle Migration AssistantB、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?()A、ASM_POWER_LIMITB、ASM_DISKSTRINGC、ASM_DISKGROUPSD、INSTANCE_TYPE

You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()  A、 Data Pump Export and ImportB、 conventional export and importC、 the CONVERT command of RMAND、 the BACKUP AS COPY. command of RMAN

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

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

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 to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task?()A、the CONVERT command of RMANB、Data Pump Export and Import into the same databaseC、conventional export and import into the same databaseD、the BACKUP DATABASE and RESTORE DATABASE commands of RMANE、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()A、the CONVERT command of RMANB、Data Pump Export and Import into the same databaseC、conventional export and import into the same databaseD、the BACKUP DATABASE and RESTORE DATABASE commands of RMANE、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

单选题n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A Oracle Migration AssistantB Recovery Manager (RMAN)C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance

单选题You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager (RMAN), you migrate the complete production database to use the ASM instance. Which statement is true?()ARMAN would relocate all the database files to an ASM disk group.BRMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.CRMAN would relocate all the data files to an ASM disk group and other files to an operating system location, defined using Oracle Managed Files (OMF).DRMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location, defined using OMF

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

单选题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?()Amount the new disk group in the ASM instanceBrestart the ASM instance and the production database instanceCregister the new disk groups in the production database instanceDrestart the ASM instance without restarting the production database instanceEinclude the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

单选题You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager(RMAN), you migrate the complete production database to use the ASM instance. Which statement is true?()ARMAN would relocate all the database files to an ASM disk group.BRMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.CRMAN would relocate all the data files to an ASM disk group and other files to an operating system location, defined using Oracle Managed Files (OMF).DRMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMF

多选题You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task?()Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and import into the same databaseDthe BACKUP DATABASE and RESTORE DATABASE commands of RMANEthe BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

单选题You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you notice that the system identifier (SID) for the instance is set to ’+ASM’. What is the purpose of this instance?()A This instance is being used to manage the operating system files.B This instance is being used to manage the files of other databases.C This instance is being used to manage the instances of other databases.D This instance is being used to manage the background processes of other instances.

单选题In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance?()AOracle Migration AssistantBRecovery Manager (RMAN)COracle Data Pump Export and ImportDconventional Oracle Export and ImportEoperating system utilities to copy the files to the ASM instance

单选题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 want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and import into the same databaseDthe BACKUP DATABASE and RESTORE DATABASE commands of RMANEthe BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

单选题You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()A Data Pump Export and ImportB conventional export and importC the CONVERT command of RMAND the BACKUP AS COPY. command of RMAN

单选题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 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?()ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.

单选题You are using an Automatic Storage Management (ASM) instance to manage the database files of your production database. After adding a new disk group to the ASM instance, you execute the following command:  ALTER DISKGROUP dg3 REBALANCE POWER 0; What would be the result of this command?()AThe rebalancing of the disk group would be stopped.BThe rebalancing of the disk group would be completed as fast as possible.CThe command would result in an error because the value of POWER cannot be 0.DThe rebalancing of the disk group would be completed without affecting the disk group DG3.EThe command would result in an error because the disk groups cannot be manually rebalanced.