|
c) Ko’rsatilgan ustundagi qiymatlar sonini hisoblash
|
| bet | 22/27 | | Sana | 12.01.2024 | | Hajmi | 82,83 Kb. | | #135867 |
Bog'liq Diskda saqlanadigan fayllar katologi-fayllar.orgc) Ko’rsatilgan ustundagi qiymatlar sonini hisoblash
d) Ustundagi minimal qiymatni hisoblash
#140==============================================================
Interval predikati keltirilgan qatorni toping
a) GROUP BY
b) BETWEEN
c) WHERE
d) SELECT
Malumotlar bazasi
#141==============================================================
Ob’ektlari yozuvlar ko’rinishida ifodalangan modelni ko’rsating
a) Tarmoqli (to’rtli) model
b) Relyatsion model
c) Daraxtsimon model
d) Sematik model
#142===============================================================
Quyidagi SQL so’rovi nechta jadvalga murojatni amalga oshiryapti:
Select Name, yosh,tel FROM talaba;
a) 1
b) 2
c) 3
d) 4
#143============================================================
SELECT name FROM Talaba WHERE name=’Nodir’ GROUP BY name;
a) Faqat bitta Nodir ismini;
b) Nodir ismli talabaning barcha ma’lumotlarini;
c) Talaba jadvalida nrcha Nodir ismi bo’lsa shu ismlarni
d) Jadvaldan Nodir ismli talabalarni o’chiradi
#144============================================================
SELECT * FROM talaba WHERE yoshi=18 UNION SELECT * FROM talaba WHERE yoshi=20
a) SQl so’rovida xatolik bor
b) Yoshi 18 dan kichik yoki 20 dan kata talabalar
c) Yoshi 18 yoki 20 da bo’lgan talabalar
d) Yoshi 18-20 oralig’idagi talabalar
#145============================================================
Quyida keltirilgan ma’lumotlar bazasi modellarning qaysi birida elementlararo gorizantal va
verktikal aloqa bor?
a) Relyatsion
b) Ob’ektga yo’naltirilgan
c) Tarmoqli
d) Ierarxik
Malumotlar bazasi
#146==============================================================
SELECT * FROM talaba where Yoshi > 20 OR Name=’ISLOM’;
a) Yoshi 20 dan katta talabalarni va ularga qo’shib Islom ismlilarini
b) Yoshi 20 dan katta barcha talabalarni
c) Yoshi 20 dan katta ismi Islom bo’lmagan talabalarni
d) Yoshi 20 dan katta Islom ismli talabalarni;
|
| |
