#98============================================================== Jadvallar ayirmasini hosil qilishda qaysi operatordan foydalanishimiz mumkin?

Download 82,83 Kb.
bet	16/27
Sana	12.01.2024
Hajmi	82,83 Kb.
	#135867

Bog'liq
Diskda saqlanadigan fayllar katologi-fayllar.org
O\'zbekistonning yangi tarixi. 3-kitob, IBADULLAYEVA SHAHRIBANU XAMRABEK QIZI 77919169593569, B1 words, top-job-shartnoma, Elektron jadval, AI, Санжар, Operasion sistemalar va ularning turlari. Unix operatsion sistem, Tilshunoslikdan umumiy ma’lumot. Tilshunoslik, BOBUR SHAHANOV(ish.mehnat.uz) (1), Mustaqil ta\'lim mavzulari, AMaliy ish 2, 3-amali ish, Г.Матёқубова. Лазги.2024.

Bu sahifa navigatsiya:

• 100========================================================== JOIN … ON operatoriga tariff bering
• Malumotlar bazasi
• 102============================================================ SELECT * FROM Talaba ORDER BY yoshi;

#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 Download 82,83 Kb.

Download 82,83 Kb.