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

题目内容 (请给出正确答案)
单选题
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 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 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 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 need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into the data center. What should you do?()A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

考题 You are evaluating a Windows Azure application. The application uses one instance of a web role. The role instance size is set to Medium. The application does not use SQL Azure.   You have the following requirements for scaling the application:   - Maximize throughput.  - Minimize downtime while scaling. - Increase system resources.   You need to recommend an approach for scaling the application.  What should you recommend?()  A、 Set up vertical partitioning.B、 Set up horizontal partitioning.C、 Increase the number of role instances.D、 Change the role instance size to large.

考题 You have an Exchange Server 2010 organization that contains 20 mailbox databases. You configure each database to retain all deleted items for 30 days.You need to ensure that all items that pass the retention period are permanently deleted daily between 02:00 and 06:00. Which cmdlet should you use?()A、Set-MailboxDatabaseB、Set-MailboxServerC、Set-OrganizationConfigD、Set-RetentionPolicy

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

考题 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 been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings, you find that the following parameter has been set in the parameter file of the database:  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE?()A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client

考题 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 have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DB  A. While observing the server settings, you find that the  following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE?()A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client

考题 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 in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?()A、You should set query governor cost limitB、You should set cost threshold for parallelismC、You should set priority boost D、You should set precompute rank

考题 You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose?()A、Place each database in a separate instance running on SQL2.B、Place each database in a separate instance running on SQL3.C、Place both databases in a single instance running on SQL2.D、Place both databases in a single instance running on SQL3.

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

考题 单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings, you find that the following parameter has been set in the parameter file of the database:  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE?()A to enable operating system authentication for a remote clientB to restrict the scope of administration to identical operating systemsC to allow the start up and shut down of the database from a remote clientD to enable the administration of the operating system from a remote clientE to disable the administration of the operating system from a remote client

考题 单选题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 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 need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into the data center. What should you do?()A Install a separate instance of SQL Server 2005 for each of the databases on a single server.B Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.C Import the data from each of the databases into a single database in an instance of SQL Server 2005.D Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

考题 单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?()A You should set query governor cost limitB You should set cost threshold for parallelismC You should set priority boost D You should set precompute rank

考题 单选题You are evaluating a Windows Azure application. The application uses one instance of a web role. The role instance size is set to Medium. The application does not use SQL Azure.   You have the following requirements for scaling the application:   - Maximize throughput.  - Minimize downtime while scaling. - Increase system resources.   You need to recommend an approach for scaling the application.  What should you recommend?()A  Set up vertical partitioning.B  Set up horizontal partitioning.C  Increase the number of role instances.D  Change the role instance size to large.

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

考题 单选题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 need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose?()A Place each database in a separate instance running on SQL2.B Place each database in a separate instance running on SQL3.C Place both databases in a single instance running on SQL2.D Place both databases in a single instance running on SQL3.

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