Ma’lumotlar bazasi mbbtda dml tilini vazifasi nima?

Xodim jadvalidan ixtiyoriy atributni o'chirish amali qaysi javobda to‘g‘ri ko‘rsatilgan

1. 
   ALTER TABLE `Xodim` DROP COLUMN `Tel_raqam` text(15)
   
2. 
   ALTER TABLE `Xodim` DELETE `Jinsi` varchar(10) not null
   
3. 
   ALTER TABLE `Xodim` DROP RENAME `Yoshi` int(3) not null
   
4. 
   ALTER TABLE `Xodim` CHANGE DROP `Tel_raqam` text(15) not null
   

ANSWER: A
Xodim jadvalidan ixtiyoriy atributning ma'lumot tipini o'zgartirish amali qaysi javobda to‘g‘ri ko‘rsatilgan

1. 
   ALTER TABLE `Xodim` MODIFY `Jinsi` varchar(5)
   
2. 
   ALTER TABLE `Xodim` MODIFY ALTER `Jinsi` varchar(10) not null
   
3. 
   ALTER TABLE `Xodim` MODIFY CHANGE `Yoshi int(3) not null
   
4. 
   ALTER TABLE `Xodim` CHANGE COLUMN `Tel_raqam` text(15) not null
   

ANSWER: A


Mahsulot jadvalidan ixtiyoriy atributning ma'lumot tipini o'zgartirish amali qaysi javobda to‘g‘ri ko‘rsatilgan

1. 
   ALTER TABLE `Mahsulot` MODIFY `narxi` varchar(15) null
   
2. 
   ALTER TABLE `Mahsulot` MODIFY ALTER `nomi` varchar(10) null
   
3. 
   ALTER TABLE `Mahsulot` MODIFY CHANGE `nomi` text(3) null
   
4. 
   ALTER TABLE `Mahsulot` CHANGE COLUMN `narxi` text(15) null
   

ANSWER: A
SELECT TIMESTAMPDIFF(YEAR, '2015-04-29 22:14:55', '2018-04-29 22:24:18'); So`rov natijasini aniqlang

1. 
   Yillar orasidagi farq
   
2. 
   joriy vaqtni ko`rsatadi
   
3. 
   ko`rsatilgan vaqt
   
4. 
   xatolik yuz beradi
   

ANSWER: A
SELECT * FROM talaba ORDER BY baho DESC; So`rovdagi "desc" nima vazifa bajaradi?

1. 
   Baho ustunini teskarisiga saralaydi
   
2. 
   Baho ustunini saralaydi
   
3. 
   Baho ustunini guruhlaydi
   
4. 
   Talaba jadvalidan Baho ustunini ajratib ko`rsatadi
   

ANSWER: A