网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?()
A

The ASM instance is shut down, but the other instances are still running.

B

It results in an error because other database instances are connected to it.

C

All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

D

HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.


参考答案

参考解析
解析: 暂无解析
更多 “单选题You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL shutdown immediate; What is the result of executing this command?()A The ASM instance is shut down, but the other instances are still running.B It results in an error because other database instances are connected to it.C All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.D HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.” 相关考题
考题 You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL shutdown immediate; What is the result of executing this command?()A、All the instances, including the ASM instance, are shut down in the ABORT modeB、The ASM instance is shut down, but the other instances are still running C、The ASM instance is still functional, but the other instances are shut down D、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. E、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode F、HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode

考题 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

考题 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

考题 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 three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL shutdown immediate; What is the result of executing this command?()A、The ASM instance is shut down, but the other instances are still running.B、It results in an error because other database instances are connected to it.C、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.D、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

考题 When an ASM instance receives a SHUTDOWN NORMAL command,what command does it pass on to all database instances that rely on the ASM instances disk groups?()A、 TRANSACTIONALB、 IMMEDIATEC、 ABORTD、 NORMAL

考题 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

考题 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

考题 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 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? ()A、 RMAN 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).B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMFC、 RMAN would relocate all the database files to an ASM disk group.D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

考题 You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()A、The ASM compatibility attribute controls the format of the disk group metadata.B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

考题 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?()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 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 BACKUPSETB、 BACKUP AS COPYC、 BACKUP AS COMPRESSED BACKUPSETD、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

考题 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?()A、RMAN would relocate all the database files to an ASM disk group.B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.C、RMAN 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).D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location, defined using OMF

考题 单选题You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL shutdown immediate; What is the result of executing this command?()A All the instances, including the ASM instance, are shut down in the ABORT modeB The ASM instance is shut down, but the other instances are still running C The ASM instance is still functional, but the other instances are shut down D All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. E HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode F HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode

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

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

考题 单选题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?()A RMAN would relocate all the database files to an ASM disk group.B RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.C RMAN 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).D RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location, defined using OMF

考题 多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.   SQL STARTUP;   Which two activities are performed during a successful start up operation?()AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

考题 单选题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 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? ()A  RMAN 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).B  RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMFC  RMAN would relocate all the database files to an ASM disk group.D  RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

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

考题 单选题When an ASM instance receives a SHUTDOWN NORMAL command,what command does it pass on to all database instances that rely on the ASM instances disk groups?()A  TRANSACTIONALB  IMMEDIATEC  ABORTD  NORMAL

考题 单选题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 three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL shutdown immediate; What is the result of executing this command?()A The ASM instance is shut down, but the other instances are still running.B It results in an error because other database instances are connected to it.C All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.D HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

考题 单选题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?()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 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 BACKUPSETB  BACKUP AS COPYC  BACKUP AS COMPRESSED BACKUPSETD  BACKUP INCREMENTAL LEVEL n CUMULATIVE