ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGE
ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGE
RENAME TABLE CUSTOMER TO CUSTOMER_CHANGE
RENAME TABLE CUSTOMER CUSTOMER_CHANGE
第1题:
A.COMMENTONTABLECUSTOMERIS'客户姓名'
B.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAMEIS'客户姓名'
C.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户姓名'
D.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户姓名'
第2题:
假设有学生表,要将学号和姓名定义为学生表的候选索引,索引名是xhxm。请对下面的SQL 语句填空:ALTER TABLE 学生【 】学号+姓名 TAG xhxm
第3题:
A.COMMENTONTABLECUSTOMERIS'客户表'
B.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAMEIS'客户表'
C.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户表'
D.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户表'
第4题:
A.DROP TABLE CUSTOMER
B.DROP CUSTOMER
C.DELETE TABLE CUSTOMER
D.DELETE CUSTOMER
第5题:
A.UPDATE VIEW
B.ALTER VIEW
C.DROP VIEW
D.MODIFY VIEW
第6题:
你正在使用一个SQLServer2005数据库,它包含一个名为Customers的表。其中Customers表包含如下的列定义:你使用以下Transact-SQL语句创建一个名为v_Customer的视图。CREATEVIEWv_CustomerASSELECTCustomerID,CompanyName,FirstName,LastName,PictureFROMCustomers你想要在v_Customer视图中创建一索引。在创建索引前,还需要修改此Transact-SQL语句。应采取以下哪两项举措?()
A.将Picture列改为image数据类型
B.表名包含模式名。
C.包含WITHSCHEMABINDING语句
D.在Select语句中用*符号选择所有的列
第7题:
A.ALTER USER test ACCOUNT
B.ALTER USER test NOLOCK
C.ALTER USER test ACCOUNT NOLOCK
D.ALTER test ACCOUNT NOLOCK
第8题:
A.ALTERTABLECUSTOMERADDCOLUMN"LOGOUTTIME"TIMESTAMP(6)
B.UPDATETABLECUSTOMERADDCOLUMN"LOGOUTTIME"TIMESTAMP(6)
C.UPDATETABLECUSTOMERADD("LOGOUTTIME"TIMESTAMP(6))
D.ALTERTABLECUSTOMERADD("LOGOUTTIME"TIMESTAMP(6))
第9题:
A.SELECT*FROM CUSTOMER
B.SELECT*CUSTOMER
C.MODIFY*FROM CUSTOMER
D.UPDATE*FROM CUSTOMER
第10题:
A.ALTER TABLE CUSTOMER DROP column LOGOUTTIME
B.UPDATE TABLE DROP column LOGOUTTIME
C.ALTER TABLE CUSTOMER DROP LOGOUTTIME
D.UPDATE TABLE DROP LOGOUTTIME