160. , , ,
1) Between
2) In
3) Like
4) And
161. , Char Varchar,
1) Like
2) In
3) Between
4) And
162.
1) SQL
2) Java
3) Pascal
4) Fortran
163. SELECT fname FROM STUDENT WHERE STIP=150 :
1) , , 150
2) STUDENT
3) STUDENT
4) fname
164. SELECT FAM FROM STUDENT WHERE BALL BETWEEN 82 AND 91 , :
1) 82 90
2) 82 90
3) 90
4) 82 90
165. SELECT FAM FROM STUDENT WHERE FAM LIKE % , :
1)
2)
3)
4) ,
166. SELECT NAZV_F FROM FAKULTET WHERE ROUND(AVG(BALL)) :
1)
2)
3)
4)
167. SELECT NAZV_F, NAZV_S, FAM FROM FAKULTET, SPEC, STUDENT WHERE STUDENT.KOD_S=SPEC.KOD_S AND SPEC.KOD_F=FAKULTET.KOD_F ORDER BY NAZV_F, NAZV_S, FAM :
1) , ,
2)
3)
4)
168. SELECT FAM FROM STUDENT WHERE STUDENT.KOD_S=(SELECT KOD_S FROM STUDENT WHERE FAM=) :
1) , ,
2)
3)
4)
169. SELECT DISTINCT NAZV_S FROM SPEC, STUDENT WHERE STUDENT.KOD_S=SPEC.KOD_S :
1) , STUDENT
2)
3)
4)
170. :
1)
2)
3)
4)
171. :
1) , -
2)
3) , -
4) ,
172. :
1)
2)
3)
4)
173. / :
1)
2)
3)
4)
- SELECT
1)
|
|
|
2)
3)
4)
SELECT*
FROM Customers
WHERE NOT rating>100
OR city=Rome;
1) Customers, rating>100, , Rome
2) , Rome Customers
3) , rating>100
4) Rome
- , :
1) SELECT DISTINCT snum FROM orders
2) SELECT DISTINCT Orders FROM snum
3) SELECT onum FROM Orders
4) SELECT * FROM Orders
- SELECT onum, amt, odate FROM Orders
1) , Orders
2) , Order
3) , Order
4) Order
SELECT*FROM Customers
WHERE snum=1001
1) Customers, 1001
2) Customers, 1001
3)
4)
- Salesperson
