Ma’lumotlar bazasi mbbtda dml tilini vazifasi nima?

Qaysi predikat saralash uchun ishlatiladi?

1. 
   ORDER BY
   
2. 
   WHERE
   
3. 
   HAVING
   
4. 
   GROUP BY
   

ANSWER: A
Qaysi predikat guruhlash uchun ishlatiladi?

1. 
   GROUP BY
   
2. 
   WHERE
   
3. 
   HAVING
   
4. 
   ORDER BY
   

ANSWER: A
SELECT * FROM STUDENT WHERE SURNAME LIKE 'P%';

1. 
   P harfi bilan boshlanadigan familiyalar chiqadi.
   
2. 
   P bilan tugovchi familiyalar chiqadi.
   
3. 
   Natija chiqmaydi
   
4. 
   P harfiga teng bo‘lmagan familiyalar chiqadi
   

ANSWER: A
SELECT operatorida FROM so‘zidan keyingi yozuv nimani bildiradi?

1. 
   jadvalning nomini
   
2. 
   ustunning nomini
   
3. 
   shartni
   
4. 
   kalit maydonni
   

ANSWER: A


Qaysi predikat berilgan shartni qanoatlantiruvchi qidiruvni amalga oshiradi?

1. 
   WHERE
   
2. 
   GROUP BY
   
3. 
   HAVING
   
4. 
   ORDER BY
   

ANSWER: A
To‘gri yozilgan SELECT operatorini ko‘rsating.

1. 
   SELECT * FROM
   
2. 
   SELECT *
   
3. 
   SELECT Table FROM
   
4. 
   SELECT FROM * Table_name
   

ANSWER: A


INSERT, UPDATE, DELETE quyidagi SQL tillarining qaysi biriga tegishli?

1. 
   DML
   
2. 
   DDL
   
3. 
   DQL
   
4. 
   DSL
   

ANSWER: A


Qaysi operatorda WHERE ishlatib bo‘lmaydi?

1. 
   INSERT
   
2. 
   UPDATE
   
3. 
   SELECT
   
4. 
   DELETE
   

ANSWER: A
DROP va DELETE operatorlarining farqi nimada

1. 
   DROP obyektni, DELETE qatorni o`chiradi
   
2. 
   Farqi yo`q
   
3. 
   SQLda DROP ishlatilmaydi
   
4. 
   SQLda DELETE ishlatilmaydi
   

ANSWER: A
SELECT operatoridan keyin '*' belgisi nimani bildiradi?

1. 
   hamma ustunlarni belgilashni
   
2. 
   hamma satrlarni belgilashni
   
3. 
   satr qatorlari yulduzcha bilan shifrlanganini
   
4. 
   bu belgidan foydalanib bo‘lmaydi
   

ANSWER: A
Qaysi operator yordamida jadvallarni «qo`shish» amali bajariladi

1. 
   SELECT + JOIN
   
2. 
   SELECT + WHERE
   
3. 
   SELECT + GROUP BY
   
4. 
   SELECT + ORDER BY
   

ANSWER: A
Qaysi operator yordamida «kesishuv» amali bajariladi

1. 
   INNER JOIN
   
2. 
   UNION
   
3. 
   DEVIDE
   
4. 
   MINUS
   

ANSWER: A
Qaysi operator yordamida «tanlash» amali bajariladi

1. 
   SELECT + WHERE
   
2. 
   UPDATE + WHERE
   
3. 
   INSERT
   
4. 
   DELETE + WHERE
   

ANSWER: A


Qaysi operator yordamida «birlashtirish» amali bajariladi

1. 
   UNION
   
2. 
   INTERSECT
   
3. 
   MINUS
   
4. 
   DEVIDE
   

ANSWER: A


Ichki bog‘lanish operatori – bu

1. 
   INNER JOIN
   
2. 
   FULL OUTER JOIN
   
3. 
   RIGHT OUTER JOIN
   
4. 
   LEFT OUTER JOIN
   

ANSWER: A
Chap tashqi bog‘lanish operatori – bu

1. 
   LEFT OUTER JOIN
   
2. 
   INNER JOIN
   
3. 
   FULL OUTER JOIN
   
4. 
   RIGHT OUTER JOIN
   

ANSWER: A
SELECT COUNT(id) FROM STUDENT so‘rovi qanday natija qaytaradi

1. 
   STUDENTlarning sonini
   
2. 
   STUDENTning maksimal indentifikatorini
   
3. 
   STUDENTning oxirgi identifikatorini
   
4. 
   STUDENTning birinchi identifikatorini
   

ANSWER: A
Qaysi operator yordamida «ayiruv» amali bajariladi

1. 
   MINUS
   
2. 
   INTERSECT
   
3. 
   UNION
   
4. 
   DEVIDE
   

ANSWER: A
To‘liq tashqi bog‘lanish operatori – bu

1. 
   FULL OUTER JOIN
   
2. 
   RIGHT OUTER JOIN
   
3. 
   LEFT OUTER JOIN
   
4. 
   INNER JOIN
   

ANSWER: A
Relyatsion turdagi ma'lumotlar bazasi obyektlari necha o’lchovli jadvalni tashkil etadi?

1. 
   ikki
   
2. 
   bir
   
3. 
   uch
   
4. 
   to'rt
   

ANSWER: A
SQL tilini tarkibiy qismlariga kiradi: 1) ma’lumotlarni aniqlash tili; 2) ma’lumotlarni manipulyatsiyalash tillari; 3) ma’lumotlarni boshqarish tili; 4) dasturlash tillari

1. 
   1, 2, 3
   
2. 
   1,2,4
   
3. 
   2.3
   
4. 
   1,3,4
   

ANSWER: A


DML komandalarini ko`rsating

1. 
   INSERT, DELETE, UPDATE, SELECT
   
2. 
   CREATE, ALTER, DROP
   
3. 
   INSERT, DROP, UPDATE, SELECT
   
4. 
   CREATE, ALTER, DELETE
   

ANSWER: A
DDL komandalarini ko`rsating

1. 
   CREATE, ALTER, DROP
   
2. 
   INSERT, DELETE, UPDATE, SELECT
   
3. 
   INSERT, DROP, UPDATE, SELECT
   
4. 
   CREATE, ALTER, DELETE
   

ANSWER: A
UPDATE operatorini qaysi kalit so’zi jadvalni aniq ustunlarini tanlab olish va o’zgartirish imkonini beradi?

1. 
   SET
   
2. 
   AND va OR
   
3. 
   SETUP
   
4. 
   DATE
   

ANSWER: A
Amaliyotda eng ko’p tarqalgan ma’lumotlar bazalari bu-

1. 
   Relyatsion ma’lumotlar bazalari
   
2. 
   Ierarxik ma’lumotlar bazalari
   
3. 
   Tarmoqli ma’lumotlar bazalari
   
4. 
   Ierarxik va relyasion ma’lumotlar bazalari
   

ANSWER: A
SELECT operatoridan FROM so‘zidan keyingi yozuv nimani bildiradi?

1. 
   jadvalning nomini
   
2. 
   ustunning nomini
   
3. 
   shartni
   
4. 
   birlamchi kalitni
   

ANSWER: A
Select lpad(o'yinchi, 10, '*') from fun. So`rov natijasini tanlang

1. 
   ****Suarez
   
2. 
   **********Suarez
   
3. 
   Suarez***
   
4. 
   Suarez****
   

ANSWER: A
Select rpad(uyinchi, 10, '*') from func; So`rov natijasini tanlang

1. 
   Suarez****
   
2. 
   ****Suarez
   
3. 
   Suarez***
   
4. 
   **********Suarez
   

ANSWER: A
SELECT Name, Surname FROM talaba; So’rovida Name, Surname nimani anglatadi

1. 
   Ustunlar
   
2. 
   Qatorlar
   
3. 
   Jadvallar
   
4. 
   Ob’yektlar
   

ANSWER: A
SELECT LEFT(`ism`, 5) FROM `xodimlar`; so`rov natijasini toping

1. 
   Xodimlar ismining birinchi 5 ta harflarini chiqaradi
   
2. 
   Xodimlar ismining chap tomonidan chiqaradi
   
3. 
   Xodimlar ismining 5 ta harfini chiqaradi
   
4. 
   So`rovda xatolik beradi
   

ANSWER: A