网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
【单选题】货币数据类型在SQL Server 2008中用（)表示 。
A．int
B．datetime
C．money
D．tinyint
参考答案和解析
money
更多 “【单选题】货币数据类型在SQL Server 2008中用（)表示 。A．intB．datetimeC．moneyD．tinyint” 相关考题
考题
在哪里可以查看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中的管理——维护计划
考题
你正在设计一个计划迁移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。
考题
在SQL Server中，修改表中列定义的正确的SQL语句是（）。A、ALTER TABLE 表名 ALTER COLUMN 列名 数据类型B、ALTER TABLE 表名 ALTER 列名 数据类型C、ALTER TABLE MODIFY COLUMN 列名 数据类型D、ALTER TABLE 表名 ADD 列名 数据类型
考题
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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features. These features will be discontinued. What should you do？ （）A、The SQL Server 2008 Upgrade Advisor should be used. B、The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. C、A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used D、A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.
考题
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.
考题
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 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 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.
考题
单选题关于sql server常用的数据类型，以下说法是错误的（）。A
Image数据类型可以用来存储图像。B
使用字符数据类型时，可以改变长度信息。C
使用整数数据类型时，可以改变长度信息。D
Bit数据类型为1位长度，可以存储表示是/否的数据。
考题
单选题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.
热门标签
最新试卷
