Ma’lumotlar bazasi mbbtda dml tilini vazifasi nima?

Qaysi javobda INSERT INTO SELECT amali bajarilish tartibi to’g’ri keltirilgan?

1. 
   Birinchi jadvaldan ikkinchi jadvalga shartlarda berilgan ma’lumotlarni ko’chirish
   
2. 
   Birinchi jadvaldan ikkinchi jadvalga shartlarda berilgan ma’lumotlarni ko’chirishga ruxsat bermaslik
   
3. 
   Faqatgina birinchi jadvalga ko’chirish ortib qolsa ikkinchi jadvalga ko’chirish
   
4. 
   Birinchi jadvaldagi hamma ma’lumotlarni ikkinchi jadvalga ko’chirib o’tqazish
   

ANSWER: A
O'quvchilar jadvalidan 10 yoshlilarini sonini chiqaruvchi so'rov qaysi javobda to'g'ri ko'rsatilgan

1. 
   SELECT Count(ID) as `Natija` from `O'quvchilar` WHERE `Yoshi`='10'
   
2. 
   SELECT Count(ID) as `Natija` from `O'quvchilar` WHERE `Yoshi`>='10'
   
3. 
   SELECT * as `Natija` `O'quvchilar` from `Yoshi` WHERE `='10'
   
4. 
   SELECT SUM(ID) as `Natija` from `O'quvchilar` WHERE `Yoshi`='10'
   

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

1. 
   SELECT * from Xodim WHERE Ism LIKE '%or%'
   
2. 
   SELECT * from Xodim WHERE LIKE `Ism` '%or'
   
3. 
   SELECT * from Xodim `Ism` WHERE LIKE '%or%'
   
4. 
   SELECT * from Xodim WHERE Ism LIKE ='or'
   

ANSWER: A
LIKE to`g`ri qo'llanilgan so`rovni ko`rsating

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

ANSWER: A
Select LPAD(oyinchi, 11, '*') from fun. So`rov natijasini tanlang

1. 
   ****Ahmedov
   
2. 
   **********Ahmedov
   
3. 
   Ahmedov****
   
4. 
   Ahmedov******
   

ANSWER: A