|
Diskda saqlanadigan fayllar katologi Ma`lumotlar bazasi-bu
|
| bet | 4/27 | | Sana | 12.01.2024 | | Hajmi | 82,83 Kb. | | #135867 |
Bog'liq Diskda saqlanadigan fayllar katologi-fayllar.orgc) Forma
d) Makros
#14=======================================================
TALABA jadvali berilgan. Uning 3ta atributi bor. Unga SQL kodi orqali manzili deb nomlanga yangi
atribut qoshilsin
a) ALTER TABLE TALABA RENAME MANZILI VARCHAR(20);
b) ADD COLUMN MANZILI VARCHAR(20);
c) ALTER TABLE TALABA ADD MANZILI VARCHAR(20);
d) RENAME ISM TO MANZILI
#15 =======================================================
SELECT operatori SQL ning qaysi guruhiga kiradi
a) DML
b) DQL
c) DDL
d) DCL
#16 =======================================================
FORMALAR nima uchun mo’ljallangan?
a) Ma’lumtlarni tanlash va ishlab chiqish
Malumotlar bazasi
b) Buyruqlarni avtomatik bajarish
c) Ma’lumotlarni kiritish va ko’rish
d) Ma’lumotlarni saqlash
#17==============================================================
Quyidagi SQL so’rovi natijasi nimani ko’rsatadi:
SELECT Name,max (baho) FROM talaba INNER JOIN imtihon ON talaba.id_s=imtihon.id_s
GROUP BY FIO;
a) Talabaning olgan baholarini korsatadi
b) Har bir talaba olgan max balni korsatadi
c) Eng yuqori ball olgan talabaning ismini korsatadi
d) Eng past baho olgan talabaning ismi va bahosini korsatdi
#18===============================================================
SELECT * FROM Talaba Where Yoshi > (SELECT yoshi FROM Talaba Where Name=’Bahodir’)
a) Bahodir ismli talabalarning ichida Yoshi kattasini
b) Yoshi Bahodir ismli talabanung yoshidan katta talabalarni
c) Bahodir ismli talabalardan kichik yoshli talabarni
d) SQL sorovida xatolik korsatadi
#19=============================================================
Malumotlar bazasini yaratishda necha xil muhim shartni hisobga olmoq zarur
a) 5
|
| |
