Test savollari

197. Talabalar nechta shahardan kelganligini aniqlovchi so’rov to’g‘ri keltirilgan qatorni toping

1. 
   Select count(*) from Talaba;
   
2. 
   Select count(distinct tug_shahar) from Talaba;
   
3. 
   Select SUM(distinct tug_shahar) from Talaba;
   
4. 
   Select SUM(*) FROM Talaba;
   

198. TALABA1 va TALABA2 jadvallari qanday kortejlar bilan kesishganini topish uchun qanday so’ruv yoziladi

1. 
   Select *from talaba1 MINUS Select *from talaba2
   
2. 
   SELECT ism FROM TALABA1 INTERSECT SELECT ism FROM TALABA2
   
3. 
   Select *from talaba1 Union Select *from talaba2
   
4. 
   Select *from talaba1 intersect select *from talaba2;
   

199. T1 jadval ID, ism,familiya, tugilgan sanasi, yoshi atributlariga ega. Savol: familiya bo’yicha guruxlash amalga oshirilib bir xil familiya ostida bo’lgan talabalarning yoshi yig‘indisi 25 dan katta bo’lganlarining familiyasi kamayish tartibida yozilsin

1. 
   Select familiya, SUM(yoshi) from T1 group by familiya having SUM(yoshi)>25 order by familiya desc;
   
2. 
   Select familiya, COUNT(yoshi) from T1 group by familiya having COUNT(yoshi)>25 order by familiya desc;
   
3. 
   Select familiya, MAX(yoshi) from T1 group by familiya having SUM(yoshi)>25 order by familiya DESC;
   
4. 
   Select familiya, SUM(yoshi) from T1 group by familiya having SUM(yoshi)>25 order by familiya ;
   

200. SQL operatorlari necha guruxga bo’linadi?

1. 
   3
   
2. 
   2
   
3. 
   4
   
4. 
   5
   

“Ma’lumotlar bazasini boshqarish tizimlari” fanidan TEST SAVOLLARI
№