Ma’lumotlar bazasi mbbtda dml tilini vazifasi nima?

Berilgan misoldagi ‘number’ so’zi ?: SELECT * FROM STUDENT WHERE group_id IN (SELECT id FROM group WHERE number=‘217-18’)

1. 
   ustun
   
2. 
   qator
   
3. 
   birlashuv
   
4. 
   jadval
   

ANSWER: A
Quyidagi berilgan MySQL so’rovini ishga tushirsa sintaksis xato bor deb, bajarilmaydigan so’rovni toping.

1. 
   INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Rustam', 32, 'Andijon', Done );
   
2. 
   INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (2, 'Khurshid', 25, 'Denov', 1500.00 );
   
3. 
   INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (3, 'Kamronbek', 23, 'Karshi', 2000.00 );
   
4. 
   INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (4, 'Charos', 25, 'Chirchiq', 6500.00 );
   

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

1. 
   P harfi bilan boshlanadigan familyalar chiqadi.
   
2. 
   P bilan tugovchi familyalar chiqadi.
   
3. 
   Hech nima chiqmaydi
   
4. 
   P harfiga teng bo‘lmagan familyalar chiqadi
   

ANSWER: A
Qaysi javobda LIKE operatoridan to'g'ri foydalanilgan

1. 
   SELECT * from Talaba WHERE `Familiyasi` LIKE '%ev'
   
2. 
   SELECT * from Talaba WHERE LIKE `Familiyasi` '%ev'
   
3. 
   SELECT * from Talaba `Familiyasi` WHERE LIKE '%ev%'
   
4. 
   SELECT * from Talaba WHERE `Familiyasi` LIKE 'ev'
   

ANSWER: A
Talaba jadvalidan bahosi 4 dan yuqori bo‘lganlarini familiyasi bo‘yicha guruhlab chiqarish so‘rovi qaysi javobda to‘g‘ri ko‘rsatilgan

1. 
   "SELECT `Familiyasi`, MAX(`baho`) as `Natija` from `Talaba` GROUP BY `Familiyasi` HAVING MAX(`baho`)>4"
   
2. 
   "SELECT `Familiyasi`, MAX(`baho`) as `Talaba` GROUP BY `baho` HAVING MAX(`Familiyasi`)>4"
   
3. 
   SELECT `Familiyasi as `Talaba` GROUP BY `Familiyasi` HAVING MAX(`baho`)>4
   
4. 
   "SELECT `Familiyasi`, MAX(`baho`) as `Natija` from `Talaba` GROUP BY `Familiyasi` HAVING MAX(`baho`)= 4"
   

ANSWER: A
Maxsulotlar nomli jadval berilgan. Quyidagi MySQL so’rov bajarilsa natijasi qanday bo’ladi? SELECT * FROM Maxsulotlar WHERE Narx BETWEEN 101 AND 205 AND CategoryID IN (1,2,3,8,12);

1. 
   Maxsulotlar jadvalining Narx nomli ustundagi ma’lumotlar ichidan 101 va 205 lar oralig’idagi yozuvi bor qatorlarni ko’rsatish hamda faqat CategoryID = 1,2,3,8,12 ga teng bo’lganlarini ko’rsatish
   
2. 
   Maxsulotlar jadvalidan Narx nomli ustundagi ma’lumotlar ichidan 101 va 205 orasidagi yozuvlarni tanlash hamda CategoryID = 1,2,3,8,12 ga teng bo’lganlarini ko’rsatmaslik
   
3. 
   Narx jadvalidan Maxsulotlar nomli ustundagi ma’lumotlar ichidan 101 va 205 orasidagi yozuvlarni ko’rsatish hamda CategoryID = 1,2,3,8,12 ga teng bo’lganlarini ko’rsatmaslik
   
4. 
   Narx jadvalining Maxsulotlar nomli ustundagi ma’lumotlar ichidan 101 va 205 orasidagi yozuvlarni tanlash hamda CategoryID = 1,2,3,8,12 ga teng bo’lganlarini ko’rsatish
   

ANSWER: A