单选题What happens if you shutdown abort ASM instance?（）A The RDBMSs connected will shutdown abort tooB CLUSTER SERVICE will shutdownC ASM wil do instance recovery after startup

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

查看答案

考题 What happens if you shutdown abort ASM instance?() A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance recovery after startup

查看答案

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

查看答案

考题 What are the consequences of executing the SHUTDOWN ABORT command？（）A、The database files are synchronized.B、Uncommitted changes are not rolled back.C、The database is closed， but the instance is still started.D、Database buffers and redo buffers are not written to the disk.E、The database undergoes automatic media recovery during the next startup.

查看答案

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

查看答案

考题采用ASM存储模式在Oracle10G数据库中，如果在数据库正常运转的情况下，采用shutdownimmediate在命令直接关闭了ASM实例，会出现以下（）情况。A、依赖该ASM实例的数据库在ASM实例关闭前以shutdown abort模式关闭B、依赖该ASM实例的数据库在ASM实例关闭后，以shutdown abort模式关闭C、依赖该ASM实例的数据库在ASM实例关闭前以shutdownimmediate模式关闭D、依赖该ASM实例的数据库在ASM实例关闭前，以shutdownimmediate模式关闭

查看答案

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

查看答案

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

查看答案

考题 What is the proper command to shut down the database in a consistent manner?（）A、shutdown abort B、shutdown kill C、Shutdown nowait D、shutdown immediateE、shutdown halt

查看答案

考题 You execute the following command to start an Automatic Storage Management （ASM） instance： SQLSTARTUP； In which of the following modes will the ASM instance start？（）A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT

查看答案

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

查看答案

考题 What happens if you shutdown abort ASM instance?（）A、The RDBMSs connected will shutdown abort tooB、CLUSTER SERVICE will shutdownC、ASM wil do instance recovery after startup

查看答案

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

查看答案

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

查看答案

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

查看答案

考题单选题What happens if you shutdown abort ASM instance?（）A The RDBMSs connected will shutdown abort tooB CLUSTER SERVICE will shutdownC ASM wil do instance recovery after startup

查看答案

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

查看答案

考题多选题What are the consequences of executing the SHUTDOWN ABORT command？（）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not written to the disk.EThe database undergoes automatic media recovery during the next startup.

查看答案

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

查看答案

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

查看答案

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

更多 “单选题What happens if you shutdown abort ASM instance?（）A The RDBMSs connected will shutdown abort tooB CLUSTER SERVICE will shutdownC ASM wil do instance recovery after startup” 相关考题

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

更多 “单选题What happens if you shutdown abort ASM instance?（）A The RDBMSs connected will shutdown abort tooB CLUSTER SERVICE will shutdownC ASM wil do instance recovery after startup” 相关考题

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