Ma’lumotlar bazasi mbbtda dml tilini vazifasi nima?

Talaba jadvalidan familiyasi B harfi bilan boshlanib, V harfi bilan tugovchilarini sonini sanash so‘rovi qaysi javobda to‘g‘ri ko‘rsatilgan

1. 
   SELECT COUNT(*) as `Natija` from `Talaba` WHERE `Familiyasi` LIKE `B%V`
   
2. 
   SELECT COUNT(*) as `Natija` from `Talaba` WHERE LIKE `Familiyasi` `B%V`
   
3. 
   SELECT COUNT(*) as `Natija` from `Talaba` WHERE LIKE `Familiyasi` `B%V%`
   
4. 
   SELECT COUNT(*) as `Natija` from `Talaba` WHERE `Familiyasi` LIKE `%B%V`
   

ANSWER: A
ALTER TABLE `Xodim` MODIFY `Jinsi` varchar(5); Sorovi natijasi

1. 
   Jadvaldagi ‘Jinsi’ nomli ustun ma’lumot tipini varchar(5) ga o’zgartiradi
   
2. 
   Jadvaldagi hamma ma’lumotlar tipini varchar(5) ga o’zgartiradi
   
3. 
   Xodim Ustunidagi Jinsi qatorini 5 ga o’zgartiradi
   
4. 
   Xodim qatoridagi ma’lumot uzunligini 5 taga bo’ladi
   

ANSWER: A
Mahsulot jadvalidan narxi 4000 so'm va undan yuqori bo‘lganlarini nomi bo‘yicha guruhlab chiqarish so‘rovi qaysi javobda to‘g‘ri ko‘rsatilgan

1. 
   SELECT `Nomi`, MAX(`narx`) as `Natija` from `Mahsulot` GROUP BY `Nomi` HAVING MAX(`narx`)>=4000
   
2. 
   SELECT `Nomi`, MAX(`narx`) as `Natija` from GROUP BY `Nomi` HAVING MAX(`narx`)>4000
   
3. 
   SELECT * from `Mahsulot` GROUP BY `Nomi` HAVING MAX(`narx`)>4000
   
4. 
   SELECT `Nomi`, MAX(`narx`) as `Natija` from `Mahsulot` GROUP BY `narx` HAVING MAX(`Nomi`)>=4000
   

ANSWER: A

Fanlar jadvalidan `fan_soati` 80 dan yuqori bo‘lganlarini nomi bo‘yicha guruhlab chiqarish so‘rovi qaysi javobda to‘g‘ri ko‘rsatilgan

1. 
   SELECT `Fan_nomi`, MAX(`fan_soati`) as `Natija` from `Fanlar` GROUP BY `Fan_nomi` HAVING MAX(`fan_soati`)>80
   
2. 
   SELECT `Fan_nomi`, MAX(`fan_soati`) from `Fanlar` GROUP BY `Fan_nomi` HAVING MAX(`fan_soati`)>=80
   
3. 
   SELECT `Fan_nomi`, MAX(`fan_soati`) as `Natija` GROUP BY `Fan_soati` HAVING MAX(`fan_soati`)>80
   
4. 
   SELECT `Fan_nomi`, MAX(`fan_soati`) as `Natija` from `Fanlar` GROUP BY `Fan_nomi` HAVING MAX(`fan_nomi`)>80
   

ANSWER: A