Ma’lumotlar bazasi mbbtda dml tilini vazifasi nima?

SELECT MAX(ID) FROM STUDENT so‘rovi nimani qaytaradi

1. 
   STUDENTning maksimal identifikatori
   
2. 
   STUDENTning birinchi identifikatori
   
3. 
   STUDENTning oxirgi identifikatori
   
4. 
   STUDENTlarning ismlarini
   

ANSWER: A
SELECT SUBSTR(`familiya`,1,1) FROM `xodimlar`; so`rov natijasini toping

1. 
   Xodimlar familyalarining bosh harflarini chiqaradi
   
2. 
   Xodimlar familyalarining birinchisini chiqaradi
   
3. 
   Xodimlar familyalarining bitta harfini chiqaradi
   
4. 
   So`rovda xatolik beradi
   

ANSWER: A
Ma’lumotlarni qaysi toifasiga MIN, MAX, AVG, SUM agregat funksiyalarni qo‘llash mumkin emas

1. 
   Qatorlar
   
2. 
   Sonlar
   
3. 
   Sanalar
   
4. 
   Barcha ma’lumotlarga qo‘llash mumkin
   

ANSWER: A
LIKE to`g`ri qollanilgan so`rovni ko`rsating

1. 
   SELECT * FROM Products WHERE PName LIKE ‘%gizmo%’
   
2. 
   SELECT * FROM LIKE WHERE PName Products ‘%gizmo%’
   
3. 
   SELECT LIKE(‘%gizmo%’) FROM Products WHERE PName
   
4. 
   SELECT * FROM Products, PName LIKE ‘%gizmo%’
   

ANSWER: A
Select * from exam Where mark in (4,5); so`rov natijasini toping

1. 
   Imtixondan 4 yoki 5 olganlar hadiqa ma`lumot
   
2. 
   Imtixondan 4 va 5 olmaganlar hadiqa ma`lumot
   
3. 
   Imtixondan 4,5 va undan past baho olganlar hadiqa ma`lumot
   
4. 
   Imtixondan 4 chi va 5 chi bilet haqidagi ma`lumot
   

ANSWER: A
Lower operatorining vazifasi nima?

1. 
   berilgan ustunni kichik harflarga almashtirib beradi
   
2. 
   berilgan qatorni kichik harflarga almashtirib beradi
   
3. 
   berilgan satrni katta harflarga almashtirib beradi
   
4. 
   berilgan qatorni katta harflarga almashtirib beradi
   

ANSWER: A