1.(判断题)clob用于存储TEXT类型的文本大对象数据。
正确
2.(单选题)查找岗位是工程师且薪水在6000以上的记录,逻辑表达式为?
岗位 =‘工程师’ OR 薪水 > 6000
岗位 =工程师 AND 薪水 > 6000
岗位 =工程师 OR 薪水 > 6000
岗位 =‘工程师’ AND 薪水 > 6000
3.(单选题)下面四组SQL命令,全部属于数据操作语言的命令是?
CREATE,DROP,UPDATE
INSERT,UPDATE,DELETE
INSERT,DROP,ALTER
UPDATE,DELETE,ALTER
4.(多选题)从student表中查询学生姓名、年龄和成绩,结果按照年龄降序排序,年龄相同的按照成绩升序排序,下面SQL语句正确的是?
SELECT name, age, score FROM student order by age desc , score;
SELECT name, age, score FROM student order by age , score asc;
SELECT name, age, score FROM student order by 2 desc , 3 asc;
SELECT name, age, score FROM student order by 1 desc , 2 ;
5.(多选题)以下哪些是逻辑操作符?
and
or
not
not or