网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
在SQL Server Management Studio中，对SQL Server数据文件的维护包括（）
- A、修改数据文件自动增长方式
- B、修改数据文件的物理文件名
- C、修改数据文件的文件类型
- D、修改数据文件的存储位置
参考答案
更多 “在SQL Server Management Studio中，对SQL Server数据文件的维护包括（）A、修改数据文件自动增长方式B、修改数据文件的物理文件名C、修改数据文件的文件类型D、修改数据文件的存储位置” 相关考题
考题
在哪里可以查看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数据库引擎服务BSQL Server Management StudioCSQL Server配置管理器DSQL Server 管理工具
考题
要让管理SQL-Server数据库的Management-Studio或者访问数据库的应用程序正常工作，（）必须处于启动状态。A、SQL-Server-Analysis-Servers服务B、SQL-Server服务C、SQL-Server-Browser服务D、SQL-Server-Agent服务
考题
A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A、 Use the SQL Server Profiler to capture all SQL activities.B、 Use a Dynamic Management View to analyze performance.C、 Use the Database Engine Tuning Advisor to analyze the workload.D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.
考题
下列关于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 SERVER2005提供的集成环境，它能完成访问、配置和管理SQL SERVER的所有任务。A、SQL SERVER Management StudioB、SQL SERVER配置管理器C、企业管理器D、查询分析器
考题
（）工具是Microsoft SQL Server2005提供的集成环境，这种工具可以完成访问、配置、控制、管理和开发SQL Server的所有工作。A、Microsoft SQL Server Management StudioB、SQL Server配置管理器C、Analysis ServicesD、SQL Server Business Intelligence Development Studio
考题
在哪里可以查看SQL Server 2008中的当前日志（）。A、SQLServer Management Studio中的管理——SQL Server日志B、SQLServer Management Studio中的管理——维护计划C、SQLServer Management Studio中的安全性——SQL Server日志D、SQLServer Management Studio中的数据库——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中的管理——维护计划
考题
公司A有一个名为SQL1的SQL Server 2005服务器。SQL1设置为SQL Server和Windows身份认证模式。使用Windows认证，在SQL1上你有sysadmin权限。使用SQL1工作的所有用户都反映说：使用SQL1的所有应用程序均停止响应。你的上司让你去调查此问题。在任务管理器中，你注意到CPU使用率为100%。你试图用SQL Server Management Studio连接到SQL1。但SQL1没有响应。你需要连接到SQL1才能诊断问题。哪两种方法可能让你达成此目标？（）A、用osql实用工具连接到SQL1B、使用专用管理员连接的sqlcmd实用工具连接到SQL1C、用SQL Server Management Studio连接到SQL1。打开一个查询窗口并执行以下语句：DBCC TRACEON 1244D、在SQL Server Management Studio中，在工具栏上，点击数据库引擎查询以打开连接到数据库引擎对话框。在服务器名称文本框内，敲入ADMIN：SQL1。选择SQL Server身份认证并提供你的sa身份。点击连接按钮
考题
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. The server hosts databases for several mission-critical applications. Microsoft SQL Server Management Studio executes queries and it has some effect. Now you intend to limit the effect by using the Resource Governor. You must make sure that queries initiated through SQL Server Management Studio is less than 20 percent of CPU utilization, besides this, you must make sure that queries initiated by the mission-critical applications can consume 100 percent of CPU utilization when required. So what action should you perform to achieve this goal? （）A、You should alter the default resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by SQL Server Management Studio. B、First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by SQL Server Management Studio. C、You should alter the default resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by the mission-critical applications. D、First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by the mission-critical applications.
考题
TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）A、In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.B、In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.C、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.D、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.
考题
单选题（）工具是Microsoft SQL Server2005提供的集成环境，这种工具可以完成访问、配置、控制、管理和开发SQL Server的所有工作。A
Microsoft SQL Server Management StudioB
SQL Server配置管理器C
Analysis ServicesD
SQL Server Business Intelligence Development Studio
考题
单选题在SQL Server Management Studio中，对SQL Server数据文件的维护包括（）A
修改数据文件自动增长方式B
修改数据文件的物理文件名C
修改数据文件的文件类型D
修改数据文件的存储位置
考题
多选题公司A使用SQL Server 2005。有用户反映一个订单处理程序在事务处理过程中停止响应。你调查并发现此用户的会话（会话标识85）被一错误进程阻止了。错误进程的会话标识是101。你需要尽快解决这种阻断情形，以使用户能继续使用此程序而不耽误工作。哪两种方法可能达成目标？（）A在SQL Server Management Studio打开一个新的查询窗口，执行以下语句：KILL 85B在SQL Server Management Studio打开一个新的查询窗口，执行以下语句：KILL 101C在SQL Server Management Studio打开活动监控器，打开进程信息页；右击会话标识85并选择终止进程。D在SQL Server Management Studio打开活动监控器，打开进程信息页；双击会话标识101以显示进程详细信息；点击终止进程按钮。
考题
单选题在哪里可以查看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中的管理——维护计划
考题
单选题（）管理工具是SQL SERVER2005提供的集成环境，它能完成访问、配置和管理SQL SERVER的所有任务。A
SQL SERVER Management StudioB
SQL SERVER配置管理器C
企业管理器D
查询分析器
考题
单选题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？（）A
Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.B
Query the sys.server_permissions table on Server1.C
Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.D
Query the sys.database_permissions and sys.database_principals tables in the MedDB database.
考题
单选题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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? （）A
You should use the Database Engine Tuning Advisor tool B
You should use the Windows System Monitor tool C
You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D
You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
考题
多选题公司A使用的是SQL SERVER 2005 数据库。一个用户报告说：订单处理应用在处理一个订单事务的过程中停止响应。这个用户对应的SQL SERVER 进程ID是54.你需要查出进程54是否被其他连接阻塞。如果是，你需要确定阻塞者的进程ID，下面哪两个方法可能达到这个目的？（）A在SQL Server Management Studio，打开活动监视器， 打开进程信息页，查看进程54的阻塞者列信息B在SQL Server Management Studio，打开活动监视器，打开按进程分类的锁页，查看进程54请求模式列C在SQL Server Management Studio ，打开新查询窗口并且执行如下语句：SELECT * FROM sys.dm_exec_requests WHERE session_id=54然后查看blocking_session_id列D在SQL Server Management Studio，打开新查询窗口并且执行如下语句：SELECT * FROM sys.dm_exec_sessionsWHERE session_id=54查看status列
考题
单选题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
考题
单选题A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A
Use the SQL Server Profiler to capture all SQL activities.B
Use a Dynamic Management View to analyze performance.C
Use the Database Engine Tuning Advisor to analyze the workload.D
Use Microsoft SQL Server Management Studio to analyze the SQL logs.
考题
多选题TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）AIn SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.BIn SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.CIn SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.DIn SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.
考题
单选题要让管理SQL-Server数据库的Management-Studio或者访问数据库的应用程序正常工作，（）必须处于启动状态。A
SQL-Server-Analysis-Servers服务B
SQL-Server服务C
SQL-Server-Browser服务D
SQL-Server-Agent服务
考题
问答题简述收缩数据库的作用以及在SQL Server Management Studio中收缩数据库的步骤。
热门标签
最新试卷