多选题You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）AIn Event Viewer， view the system log.BIn Event Viewer， view the application log.CIn Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.DIn Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.EIn Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.
多选题
You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）
A
In Event Viewer， view the system log.
B
In Event Viewer， view the application log.
C
In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.
D
In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.
E
In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.
参考解析
解析：
暂无解析
相关考题：
You are the administrator of two Microsoft Windows 2000 computers. One computer is running Internet Information Services (IIS), and the other is running SQL Server 2000. Company partners need to connect by means of the Internet and query data stored on the SQL Server computer. Some of these partners have computers that do not use Microsoft operating systems or Web browsers.You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer.You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)A．Configure the IIS virtual directory to allow URL queries.B．Configure the IIS virtual directory to allow template queries.C．Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.D．Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.E．Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.
You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.You cancel the SQL Server upgrade wizard.You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.Which three actions should you take? (Each correct answer presents part of the solution. Choose three)A. Install SQL Server 2000 as a named instance.B. Install SQL Server 2000 as the default instance.C. Configure the new instance for Mixed Mode Authentication.D. Configure the new instance for Windows Authentication.E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.F. Configure the server to use the Multiprotocol Net-Library.
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use theSQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
You are the domain administrator for TestKing‘s Active Directory domain. Thedomain consists of four domain controllers named TestkingDC1, TestkingDC2,TestkingDC3, and TestkingDC4. TestkingDC1 and TestkingDC2 run Windows 2000Server and have the latest service pack installed. TestkingDC3 and TestkingDC4run Windows Server 2003. All client computers run Windows XP Professional andhave the latest service pack installed.You have a new client computer that you plan to use to perform domainadministration functions.You need to be able to manage Active Directory users and computers remotely.What should you do?（）A. Install the Windows Support Tools from the Windows Server 2003 installation CD on your client computer.B. Install the Adminpak.msi file from the Windows Server 2003 installation CD on your client computer.C. Use the Help and Support Center tools on your client computer to connect to the domain controller that you need to manage.D. Use Computer Management on your client computer to connect to the domain controller that you need to manage.
In a CRS cluster with Standby Servers, which of the following statements are true? （）A、The Standby Server can be installed across the WAN from the active server. B、MS SQL 2000 must be installed for the datastores. C、MS SQL 2000 or MSDE can be installed for the datastores. D、On the Standby Server, you must install the same components that are installed on its corresponding active server. E、The Standby Server can be installed on one of the CallManager servers.F、The active server can be installed on one of the CallManager servers.
You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）A、In Event Viewer， view the system log.B、In Event Viewer， view the application log.C、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.D、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.E、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.
You need to identify the combinations of the Windows operating system and SQL Server 2005 version that will be the most appropriate for the new RD configuration， which will include the Research， Parts， and Engineering databases.Which two combinations will be the most appropriate？（）A、Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise EditionB、Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise EditionC、Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise EditionD、Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. More than a month ago， the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore， you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view （DMV）， you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition， the impact on database users should e cut to the least. Which action should be performed to achieve the goal？（）A、To achieve the goal， the UPDATE STATISTICS command should be excuted.B、To achieve the goal， the SQL Server Service should be restarted.C、To achieve the goal， the SQL Server computer should be restarted.D、To achieve the goal， the statistics in the dynamic management view （DMV） should be reset.
You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However， client computers cannot connect to the SQL Server instance.You need to identify the most likely cause of the connection issues. What should you do first？（）A、Ensure that port 1433 is open in your firewall.B、Ensure that port 443 is open in your firewall.C、Ensure that client computers connect by using Shared Memory protocol.D、Ensure that the server is not paused.
Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use? （）A、 Default B、 SAFE C、 EXTERNAL_ACCESS D、 UNSAFE
ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance.
You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）A、Internet Information ServicesB、SQL Server BrowserC、SQL Server AgentD、Microsoft Distributed Transaction Coordinator
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
多选题In a CRS cluster with Standby Servers, which of the following statements are true? （）AThe Standby Server can be installed across the WAN from the active server.BMS SQL 2000 must be installed for the datastores.CMS SQL 2000 or MSDE can be installed for the datastores.DOn the Standby Server, you must install the same components that are installed on its corresponding active server.EThe Standby Server can be installed on one of the CallManager servers.FThe active server can be installed on one of the CallManager servers.
多选题You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）ASet the appropriate local password policies for all computers on which SQL Server is installed.BSet the server authentication mode of all SQL Server instances to Windows Authentication mode.CInstall all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.DCreate SQL Server logins that have CHECK_POLICY enabled.
单选题You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）AMicrosoft SQL Server 2005 Mobile EditionBMicrosoft SQL Server 2005 Express EditionCMicrosoft SQL Server 2005 Standard EditionDMicrosoft SQL Server 2005 Workgroup Edition
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）ATo achieve the goal， DBCC DBREINDEX should be utilized.BTo achieve the goal， SELECT * FROM sys.indexes should be utilized.CTo achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.DTo achieve the goal， DBCC INDEXDEFRAG should be utilized.
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）AThe SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.BThe SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.CThe SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.DThe SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.
单选题You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）AInstall a separate instance of SQL Server 2005 for each of the databases on a single server.BCreate a SQL Server database for each of the databases in a single instance of SQL Server 2005.CImport the data from each of the databases into a single database in an instance of SQL Server 2005.DInstall a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.
单选题Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use? （）A Default B SAFE C EXTERNAL_ACCESS D UNSAFE
单选题You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do？（）AUse the SQL Server 2005 Management Studio to review the permissions of the default database objects.BQuery the sys.server_permissions table on Server1.CExecute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.DQuery the sys.database_permissions and sys.database_principals tables in the MedDB database.
单选题Application developers in TestKing.com create an assembly that contains a CLR function.This CLR function reads data from a spreadsheet， performs some calculations， and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use？（）ADefaultBSAFECEXTERNAL ACCESSDUNSAFE
单选题You manage a SQL Server 2005 database that contains a table with many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）Asys.dm fts index populationBsys.dm exec query statsCsys. dm db index usage statsDsys.dm db index physical stats
单选题ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （）AYou should install SQL Server 2008 as the default instance, and configure the new application to use the default instance BYou should upgrade the SQL Server 2005 application to use SQL Server 2008 CYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance DYou should install SQL Server 2008 as a named instance, and make the new application use the new instance.
单选题You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）Aone SQL Server 2005 computer with one instanceBtwo SQL Server 2005 computers， each with two instancesCtwo SQL Server computers， one with one instance and one with three instancesDone SQL Server 2005 computer with two instances
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as the administrator of a SQL Server 2005 computer， and the computer is called SQL01. The users complain the slow response of all client applications which connect to SQL01. You find that the CPU and memory utilization of SQL01 is low. In addition， the disk activity is low. The cause of the performance problem should be identified. Which action should be performed？（）ASystem Monitor should be utilized to have SQL1s cache hit ratio examined.BThe sys.dm_db_index_physical_stats dynamic management function （DMF） should be examined.CThe sys.dm_db_partition_stats dynamic management view （DMV） should be examined.DTask Manager should be utilized to have utilization of SQL1s network adapter examined.
多选题You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）AInternet Information ServicesBSQL Server BrowserCSQL Server AgentDMicrosoft Distributed Transaction Coordinator