第1题
A.当前页
B.每页显示的条数
C.起始位置
D.总条数
第2题
A.select * from 学生表 order by 入校总分 asc
B.select * from 学生表 order by 入校总分 desc
C.select top 3 * from 学生表 order by 入校总分 asc
D.select top 3 * from 学生表 order by 入校总分 desc
第3题
A.select count(all) from emp;
B.select count(emp_id) from emp;
C.select count(*) from emp;
D.select count(1) from emp;
第4题
A.DECLARE@MyvarINT
B.SELECT*FROM[AAA]
C.CREATE DATABASE AAA
D.DELETE* FROM AAA
第7题
A、select * from student where sex,age in(’男’,20);
B、select * from student where sex=’男’|| age=20;
C、select * from student where sex=’男’and age=20;
D、select * from student where sex=’男’or age=20;
第8题
A.CREATE PROCEDURE Myproc () BEGIN SELECT * FROM student; END;
B.CREATE PROCEDURE Myproc () { SELECT * FROM student; }
C.CREATE PROCEDURE Myproc [] BEGIN SELECT * FROM student; END;
D.CREATE PROCEDURE Myproc { SELECT * FROM student; };
第9题
A.SELECT * from v_fstu;
B.SELECT * from view v_fstu;
C.SELECT * from view where v_fstu;
D.SELECT * where view=v_fstu;