|
#98==============================================================
Jadvallar ayirmasini hosil qilishda qaysi operatordan foydalanishimiz mumkin?
|
| bet | 16/27 | | Sana | 12.01.2024 | | Hajmi | 82,83 Kb. | | #135867 |
Bog'liq Diskda saqlanadigan fayllar katologi-fayllar.org#98==============================================================
Jadvallar ayirmasini hosil qilishda qaysi operatordan foydalanishimiz mumkin?
a) UNION
b) EXCEPT
c) INTERSECT
d) UNION ALL
#99============================================================
LEFT [OUTER]
a) Chap tashqi tutashtirish turi
b) Ichki tutashtiish turi
c) O’ng tashqi tutashtirish turi
d) To’liq tashqi tutashtirish turi
#100==========================================================
JOIN … ON operatoriga tariff bering
a) Ichki tutashtirish turi
b) Ustunlar nomi bo’yicha tutashadi
c) Predikat orqali tutashtirishda,chap va o’ng jadvalar ko’rsatilgan predikat yordamida
ulanadi
d) Tabiiy tushuntirishda, chap va ong ustunlarnibir xil ustun ismlari bo’yicha
ulanadi,natijaviy jadvalga bir xil ismlar bir marta kiritiladi
Malumotlar bazasi
#101============================================================
SELECT COUNT (baho) FROM talaba INNER JOIN imtihon ON talaba.id_s=imtihon.id_s WHERE
baho = 5;
a) Nechta talaba 5 baho olganini ko’rsatadi
b) 5 baho olgan talabalar haqida ma’lumot ko’rsatadi
c) Umuman 5 baho olmagan talabalar sonini ko’rsatadi
d) Umuman 5 baho olmagan talabalarni korsatadi
#102============================================================
SELECT * FROM Talaba ORDER BY yoshi;
a) Talabaning o’rtacha yoshini talaba jadvalidagi barcha malumotlarni talabaning ismi
bo’yicha o’sish tartibida
b) Barcha talabalarning yoshini
c) Talaba jadvalidagi barcha malumotlarni yoshini o’sish tartibida
#103===============================================================
Relyatsion malumotlar bazasi yozuvida quyidagilar bo’lishi mumkin
a) Har xil turdagi malumotlar
b) Faqat matni axborot
c) Faqat bir turli malumot
d) Mutloq sonli malumot
|
|
Bosh sahifa
Aloqalar
Bosh sahifa
#98==============================================================
Jadvallar ayirmasini hosil qilishda qaysi operatordan foydalanishimiz mumkin?
|
