MIS SQL 新进人员考式题目 A1_TEST.docVIP

姓名:郑文和 成績:_________________ Please Answer and explain the following question. True or False: If false ,please correct it. 1. select col1,col2 from t1 where col3=abc%; False,?把”=”改为like 2.Do the following statements return the same or different output. a. SELECT * FROM T1; b. select * from t1; same 3.The following queries do not work. Why not? a. Select *-- 未指明查询对象 b. Select * from t1 末尾未加分号 c. select col1 col2 col3 from t1;-- 各属性列要以逗号隔开 4.Will these query work? table:t1 column:col1 varchar2(10) a. select count(col