Diskda saqlanadigan fayllar katologi

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
#104===============================================================
SQL da jadvalga yangi malumot kiritish operatori yozilgan qatorni ko’rsating
a) UPDATE
b) SELECT
c) DELETE
d) INSERT INTO
#105============================================================
QAYSI operator amal bajarish natijasida birlashtirilgan jadval hosil bo’ladi va undan bir xil
satrlar olib tashlanadi?
a) MINUS
b) INTERSECT