#33====================================================== Sorovlar nimaga mo’ljallangan?

Download 82.83 Kb.
bet	7/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

Bu sahifa navigatsiya:

• 34======================================================= SELECT * FROM talaba where yoshi>20 AND Name = ‘ISLOM’
• 39==================================================== Jadvallarni birlashtirish operatorini korsating a) UNION

#33====================================================== Sorovlar nimaga mo’ljallangan? a) Malumotlarni kiritish uchun b) Malumotlar bazasini saqlash uchun c) Malumotlar bazasidan axborotlarni tanlash va qayta ishlash uchun d) Murakkab dasturiy harakatlarni bajarish uchun #34======================================================= SELECT * FROM talaba where yoshi>20 AND Name = ‘ISLOM’ a) Yoshi 20 dan kata Islom ismli talablarni b) Yoshi 20 dan kattta ismi Islom bolmagan talablarni c) Yoshi 20 dan kata barcha talabalarni d) Yoshi 20 dan kata talabalarni va ularga qoshib Islom ismli talabalarni #35===================================================== INSERT INTO Talaba(id,name) values (1,’Akbar’, 2 ‘Jasur’, 3 ’Nodir’) a) Talaba jadvaliga 3ta qator qoshiladi b) Jadvalda Akbar Jasur Nodir ismli talabalarni o’chirib tashlaydi c) Yangi talaba jadvalini yaratadi d) Xatolik xaqida xabar beradi #36===================================================== SQL tilida nechta agregat funksiya mavjud a) 4 b) 3 Malumotlar bazasi c) 5 d) 2 #37====================================================== Relyatsion malumotlar bazasi nechta parametrlar bilan baholanadi a) 5 b) 6 c) 4 d) 7 #38===================================================== SELECT tovar_turi,SUM(soni)FROM Tovar_in GROUP BY tovar_turi a) Olib kelingan tavarlarning o’rtacha soni b) Har bir olib kelingan Tovar sonini tovar_turi kesimida c) Eng kop olib kelingan tovarlarni d) Olib kelingan tovarlarning umumiy sonini #39==================================================== Jadvallarni birlashtirish operatorini korsating a) UNION b) INTERSECT c) EXSEPT d) MINUS #40======================================================== Download 82.83 Kb.

Download 82.83 Kb.