网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
SQL Server提供的Nchar、Nvarchar、Ntext等几种双字节数据类型实际上是一种()。
A
Unicode数据类型
B
ASCII数据类型
C
时间戳数据类型
D
数值型类型
参考答案
参考解析
解析:
暂无解析
更多 “单选题SQL Server提供的Nchar、Nvarchar、Ntext等几种双字节数据类型实际上是一种()。A Unicode数据类型B ASCII数据类型C 时间戳数据类型D 数值型类型” 相关考题
考题
设有职工表(职工号,姓名,地址1,地址2),其中,职工号为主码。现要求地址1和地址2组合起来不能有重复值。在SQL Server 2008环境中有下列创建该表的语句:1.CREATE TABLE职工表(职工号int PRIMARY KEY,姓名nchar(10),地址1 nvarchar(20),地址2 nvarchar(20),UNIQUE(地址1,地址2))Ⅱ:CREATE TABLE职工表(职工号int PRIMARY KEY,姓名nchar(10),地址1nvarchar(20).地址2 nvarchar(20)UNIQUE(地址1,地址2))Ⅲ.CREATE TABLE职工表(职工号int PRIMARY KEY.姓名nchar(10),地址1 nvarchar(20)UNIQUE,地址2 nvarchar(20)UNIQUE)IV.CREATE TABLE职工表(1职工号int PRIMARY KEY。姓名nchar(10),地址1 nvarchar(20)UNIQUE(地址1,地址2),地址2 nvarchar(20))上述语句能正确实现此约束的是( )。A.仅Ⅰ和ⅢB.仅Ⅱ和ⅣC.仅Ⅰ、Ⅱ和ⅣD.都正确
考题
sql server 2005中的nvarchar(MAX)和xml有什么区别
通过:Connection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns,newobject[]{null,null,tableName,null});得到的两种数据类型的属性完全一致,有其它方法区分吗?
考题
设有表M,将其中的Type列的数据类型改为NCHAR(4)。下列能实现该功能的语句是()。AALTER TABLE M ADD COLUMN Type NCHAR(4)BALTER TABLE M ALTER COLUMN Type NCHAR(4)CALTER TABLE M DROP COLUMN Type NCHAR(4)DALTER TABLE M ALTER Type NCHAR(4)
考题
在SQL Server中,修改表中列定义的正确的SQL语句是()。A、ALTER TABLE 表名 ALTER COLUMN 列名 数据类型B、ALTER TABLE 表名 ALTER 列名 数据类型C、ALTER TABLE MODIFY COLUMN 列名 数据类型D、ALTER TABLE 表名 ADD 列名 数据类型
考题
SQL Server提供的Nchar、Nvarchar、Ntext等几种双字节数据类型实际上是一种()。A、Unicode数据类型B、ASCII数据类型C、时间戳数据类型D、数值型类型
考题
设有表M,将其中的Type列的数据类型改为NCHAR(4)。下列能实现该功能的语句是()。A、ALTER TABLE M ADD COLUMN Type NCHAR(4)B、ALTER TABLE M ALTER COLUMN Type NCHAR(4)C、ALTER TABLE M DROP COLUMN Type NCHAR(4)D、ALTER TABLE M ALTER Type NCHAR(4)
考题
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. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query, and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table, and 50,000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal?()A、A primary XML index should be created on the XML column.B、Statistics should be created on the nvarchar columns.C、A view should be created, and only the four columns that the query utilizes are contained by a view.D、A composite index should be created on the three nvarchar columns, and INCLUDE should be specified for the XML column.
考题
单选题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. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query, and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table, and 50,000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal?()A
A primary XML index should be created on the XML column.B
Statistics should be created on the nvarchar columns.C
A view should be created, and only the four columns that the query utilizes are contained by a view.D
A composite index should be created on the three nvarchar columns, and INCLUDE should be specified for the XML column.
考题
问答题可以把输出参数分配为哪一种SQL,Server数据类型?
热门标签
最新试卷