网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
SQL Server 2008 在安装之前，应注意的事项
A.任何版本在安装时都不用考虑操作系统的制约#B.安装对硬件的要求不作任何限制#C.在安装之前，必须在操作系统级启用TCP/IP#D.在Windows NT Server 4.0上安装SQL Server 2000时，最低的要求是必须安装Service Pack 4(SP4)以上参考答案和解析
安装SQL Server 2008时，必须先安装.NET Framework3.5以上版本。
更多 “SQL Server 2008 在安装之前，应注意的事项A.任何版本在安装时都不用考虑操作系统的制约#B.安装对硬件的要求不作任何限制#C.在安装之前，必须在操作系统级启用TCP/IP#D.在Windows NT Server 4.0上安装SQL Server 2000时，最低的要求是必须安装Service Pack 4(SP4)以上” 相关考题
考题
SQLServer2008在安装之前,应注意的事项:()。
A.在WindowsNTServer4.0上安装SQLServer2008时，最低的要求是必须安装ServicePackB.SQLServer2008的任何版本在安装时都不用考虑操作系统的制约C.SQLServer2008在安装之前，必须在操作系统级启用TCP/IPD.SQLServer2008的安装对硬件的要求不作任何限制
考题
在哪里可以查看SQL Server 2008中的当前日志()。
A.SQL Server Management Studio中的安全性——SQL Server日志B.SQL Server Management Studio中的数据库——SQL Server日志C.SQL Server Management Studio中的管理——SQL Server日志D.SQL Server Management Studio中的管理——维护计划
考题
下列关于SQL Server 2008身份验证模式的说法，错误的是（ ）。A.在“Windows身份验证模式”下，不允许sa登录到SQL Server服务器B.在“Windows身份验证模式”下，所有Windows用户都自动具有登录到SQL Server服务器的权限C.不管是哪种身份验证模式，Windows中的Administrator无需授权就可登录到SQL Server服务器D.安装好SQL Server之后，可以根据需要随时更改身份验证模式
考题
你正在设计一个计划迁移Microsoft SQL Server 2008数据库SQL Azure。你不计划来迁移SQL Server数据库SQL Server 2008 R2，你需要推荐一个方法执行批量数据传输从SQL Server数据库SQL Azure。你推荐什么？（）A、使用bcp工具。B、使用dta效用。C、使用SQL Server导入和导出向导。D、附上每个SQL Server数据库SQL Azure。
考题
你正在设计一个计划对现有的Microsoft SQL Server 2008数据库迁移到SQL Azure数据库包含一个SQL服务器代理工作，清理应用程序日志表。您需要推荐一个方法确保SQL Server代理工作继续不加修改地运行。你推荐（）A、使用SQL Azure数据同步服务。B、在SQL Azure运行SQL Server代理。C、使用SQL Server集成服务（ssi）连接到SQL Azure。D、连接现有的本地SQL Server代理工作SQL Azure。
考题
下列关于MS SQL Server2000的叙述中，正确的是（）。A、在MS SQL Server2000中不能够处理XML数据B、在MS SQL Server2000中可以方便安全地通过Web访问数据C、在MS SQL Server2000中并没有使现有的OLAP多维数据集在Web上链接和分析D、在MS SQL Server2000中不提供多实例支持，不允许在单个机器上安装多个孤立的SQL Server
考题
在哪里可以查看SQL Server 2008中的当前日志（）。A、SQL Server Management Studio中的安全性——SQLServer日志B、SQL Server Management Studio中的数据库——SQLServer日志C、SQL Server Management Studio中的管理——SQLServer日志D、SQL Server Management Studio中的管理——维护计划
考题
You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A、 Use the bcp utility.B、 Use the dta utility.C、 Use the SQL Server Import and Export Wizard.D、 Attach each SQL Server database to SQL Azure.
考题
You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table. You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification. What should you recommend？（）A、 Use the SQL Azure Data Sync service.B、 Run the SQL Server Agent in SQL Azure.C、 Use SQL Server Integration Services （SSIS） to connect to SQL Azure.D、 Connect the existing on-premise SQL Server Agent jobs to SQL Azure.
考题
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 on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances. Which service should you start?（） A、Server B、SQL Server Agent C、SQL Server Browser D、SQL Active Directory Helper
考题
单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A
Use the bcp utility.B
Use the dta utility.C
Use the SQL Server Import and Export Wizard.D
Attach each SQL Server database to SQL Azure.
考题
单选题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.
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （）A
The SQL Server 2008 Upgrade Advisor should be used B
You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes C
You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes D
You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes.
考题
单选题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.
考题
单选题公司有一个Active Directory域。公司中的所有服务器都运行 Windows Server 2008 或 Windows Server 2003。名为WSS2的Windows Server 2003 服务器运行 Microsoft SQL Server 2005 SP2 和 Microsoft Windows SharePoint Services（WSS）2.0。公司计划迁移到名为 WSS3 的 Windows Server 2008 服务器上的WSS 3.0。您需要将配置和内容从WSS2迁移到WSS3。该怎么做？（）A
备份 WSS2 上的 SharePoint 配置和内容。在 WSS3 上安装 WSS 3.0。将备份从 WSS2 还原到 WSS3。B
将 WSS2 升级为 Windows Server 2008。备份 WSS2 上的 SharePoint 配置和内容。 在 WSS3 上安装 WSS 3.0。将备份从 WSS2 还原到 WSS3。C
备份 WSS2 上的 SQL Server 2005 配置和 WSS 2.0 数据库。在 WSS3 上安装 SQL Server 2005。将 SQL Server 2005 备份从 WSS2 还原到 WSS3。D
备份 WSS2 上的 WSS 2.0 配置和内容。在 WSS3 上安装 WSS 2.0。将备份从 WSS2 还原到 WSS3。在 WSS3 上执行从 WSS 2.0 到 WSS 3.0 的就地升级。
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?（）A
You should use the Database Engine Tuning Advisor. B
In Microsoft SQL Server Management Studio, you should create a maintenance plan C
You should use the SQL Server Configuration Manager D
In Microsoft SQL Server Management Studio, you should create a policy
热门标签
最新试卷
