|
#33======================================================
Sorovlar nimaga mo’ljallangan?
|
| bet | 7/27 | | Sana | 12.01.2024 | | Hajmi | 82,83 Kb. | | #135867 |
Bog'liq Diskda saqlanadigan fayllar katologi-fayllar.org#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========================================================
|
| |
