SELECT * FROM Movie中*表示返回Movie表中的第一列。()
SELECT * FROM Movie中*表示返回Movie表中的第一列。()
SELECT * FROM Movie中*表示返回Movie表中的第一列。()
第1题
Which of the following is not true according to the text?
A.Network entertainment is a huge and growing industry.
B.It may not be possible for you to select any movie or television program ever made.
C.The killer application is video on demand,
D.You may play a role in new films in the future.
第2题
A.select count(*) from emp
B.select avg(*) from emp
C.select min(*) from emp
D.select max(*) from emp
第4题
A.SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual
B.SELECT TO_DATE(SYSDATE,'yyyy') FROM dual
C.SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual
D.SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual
第5题
A.select * from student limit 3 offset 4
B.select * from student limit 2 offset 3
C.select * from student limit 2 offset 2
D.select * from student limit 3 offset 2
第6题
A.select ename,nvl(comm.,0)from emp
B.select ename,null(comm.,0)from emp
C.SELECT ename,NULLIF(comm,0)FROM emp
D.SELECT ename,DECODE(comm.,NULL,0)FROM emp
第7题
A.在Oracle中运行" select instr(''abcdef'',''e'') from dual;"的结果是:4
B.在Oracle中运行"select rtrim(''abcdef'',''bc'') from dual; "的结果是:abcdef
C.在Oracle中运行" select replace(''a&a&b'',''&'',''-'') from dual;"的结果是:a-a-b
D.在Oracle中运行"select nvl2(null,2,3) from dual;"的结果是:3"
第8题
A.SELECT命令中必须有FROM语句
B.SELECT命令中必须有WHERE语句
C.SELECT命令中必须有GROUPBy语句
D.SELECT命令中必须有ORDERBy语句
第9题
A.SELECT姓名FROM学生情况WHERE计算机AND助学金<40
B.SELECT姓名FROM学生情况WHERE专业=“计算机”OR助学金>40
C.SELECT姓名FROM学生情况WHERE专业=“计算机”AND助学金>40
D.SELECT姓名FROM学生情况WHERE专业=“计算机”AND助学金<40
第11题
A.DECLARE@MyvarINT
B.SELECT*FROM[AAA]
C.CREATE DATABASE AAA
D.DELETE* FROM AAA