更多"[单选题]已知employee表中具有默认约束df_email, 删除"的相关试题:
[单选题]下列的查询语句哪一项是错误的(选一项)
A.Select * from stumarks where score>=60
B.Select * from (select * from stumarks where score>=60)
C.Select * from (select * from stumarks where score>=60) as temp
D.Select * from (select * from stumarks ) as temp where score>=60
[单选题]下列()语句用于清除自最近的事务语句以来所有的修改(选一项)
A.COMMIT TRANSACTION
B.ROLLBACK TRANSACTION
C.BEGIN TRANSACTION
D.SAVE TRANSACTION
[单选题]在SQL Server2005中,与下列T – SQL语句等效的语句为(选一项)
UPDATE A SET A1 = A1 * 2 WHERE A2 IN (SELECT A2 FROM B WHERE B1 = 2)
A.UPDATE A SET A1 = A1 * 2 INNER JOIN B
ON B . B1 = 2
B.UPDATE A SET A1 = A1 * 2 FROM A INNER JOIN B
ON B . B1 = 2
C.UPDATE A SET A1 = A1 * 2 WHERE A INNER JOIN B
ON A . A2 = B . A2 AND B . B1 = 2
D.UPDATE A SET A1 = A1 * 2 FROM A INNER JOIN B
ON A . A2 = B . A2 AND B . B1 = 2
[单选题]下面关于using语句使用正确的是(选一项)
A.using(SqlConnection conn = new SqlConnection(connString)){}
B.using(){SqlConnection conn = new SqlConnection(connString)}
C.SqlConnection conn = new SqlConnection(connString)using(){}
D.using(){}SqlConnection conn = new SqlConnection(connString)
[单选题]UNIQUE约束和主键约束也是哪种完整性的体现(选一项)
A.域完整性
B.引用完整性
C.实体完整性
D.其他
[单选题]向用户授予操作权限的SQL语句是(选一项)
A.CTEATE
B.REVOKE
C.SELECT
D.GRANT
[单选题]下列包含group by的语句正确的是(选一项)
A.Select stuid , stuname from stuinfo group by stuid
B.Select stuid from stuinfo where stuid<1000 group by stuid
C.Select count(stuid) , stuname from stuinfo group by stuid
D.Select stuid , count(stuname) from stuinfo group by stuname
[单选题] T-SQL批处理语句块的结束标志为(选一项)
A.GO
B.SUBMIT
C.END
D.RETURN
[单选题]从循环体内某一层跳出,继续执行循环外的语句是( )(选一项)
A.break语句
B.return语句
C.continue语句
D.空语句
[单选题]若要删除book表中所有数据,以下语句正确的是(选一项)
A.truncate table book
B.delete * from book
C.drop table book
D.delete table book
[单选题]运行以下语句,输出结果是(选一项)
CREATE PROC proc_lookup
@mystuNo varchar(8)=NULL
AS
IF @mystuNo IS NULL
BEGIN
Print '您忘记了传递学号参数'
RETURN
END
SELECT * FROM stuInfo WHERE stuNO = @mystuNo
GO
Exec Proc_lookup
A.编译错误
B.调用存储过程Proc_lookup出错
C.显示:您忘记了传递学号参数
D.显示空的学员信息记录集
[单选题]以下()语句从表student中提取前5条记录。(选一项)
A.select * from student where rowcount=5
B.select TOP of 5 * from student
C.select TOP 5 * from student
D.select * from student where rowcount<=5
[单选题]关于触发器和约束,以下说法错误的是(选一项)
A.触发器可以支持约束的所有功能。
B.Check约束不能跟据另一个表中的列验证列值。
C.最好在约束所支持的功能无法满足应用程序的需求时,再使用触发器。
D.在维持数据完整性时,要使用标准的系统错误信息,必须使用触发器。
[单选题]关于查询中列的别名, 以下()语句是不正确的(选一项)
A.Select name as '姓名' from table
B.Select name as姓名 from table where id =1
C.Sleect name = 姓名 from table
D.Select names姓名 from table
[单选题]阅读下面T-SQL语句,对变量赋值时存在错误的是(选一项)
A.DECLARE @id INT,@price MONEY
set @id=100
set @price=$2.21
B.DECLARE @id INT,@price MONEY
select @id=100,@price=2.21
C.DECLARE @id INT,@price MONEY
set @id=100, @price=2.21
D.DECLARE @id INT,@price MONEY
select @id=100
select @price=$2.21
[单选题]使用T-SQL定义两个局部变量AA和BB,正确语句是(选一项)
A.DECLARE @AA,@BB
B.PRIVATE @AA,@BB
C.PUBLIC @AA,BB
D.DECLARE @AA,BB
[单选题]查询student表中的所有非空email信息, 以下语句正确的是(选一项)
A.Select email from student where email !=null
B.Select email from student where email not is null
C.Select email from student where email <> null
D.Select email from student where email is not null
[单选题]Web 表单中,按钮的默认事件是(选一项)
A.Click 事件
B.Load 事件
C.Init 事件
D.Command 事件
[单选题]SQL Server数据库中,下列不属于T-SQL事务管理语句的是(选一项)
A.BEGIN TRANSACTION;
B.END TRANSACTION;
C.COMMIT TRANSACTION;
D.ROLLBACK TRANSACTION;