Qo‘qon davlat pedagogika instituti Sirtqi (maxsus sirtqi) bo‘limi 60110600-Matematika va informatika ta’lim yo‘nalishi talabalari uchun 3-kurs 5-semestrda Tanlov fan (Ma’lumotlar bazasi) fanidan oraliq nazorat test variantlari. Varianti №3

D) TASHKENT


Savol #15
AUTO_INCREMENT ga ta’rif bering.
A) ID larni qo'shib tartiblaydi
B) ID larni ko'paytirib tartiblaydi
C) ID larni kamayish tartibda tartiblaydi
D) ID larni ketma-ketlikda tartiblaydi


Savol #16
Between operatori to'g'ri ifodalangan qatorni aniqlang.
A) (Operand1 && operand2)
B) Operand1 and operand2
C) Operand1 && operand2
D) (Operand1 and operand2)


Savol #17
«SELECT CITY, OFFICENUMBER FROM OFFICES» SQL so‘rovdagi xizmatchi so‘zlarni aniqlang?
A) SELECT, FROM
B) SELECT, CITY
C) CITY, FROM
D) SELECT, OFFICENUMBER


Savol #18
COMMIT & ROLLBACK qaysi funksiyada ishlatiladi?
A) TRANSACTION
B) PROCEDURE
C) OPTION
D) CURSOR


Savol #19
«SELECT CITY, OFFICENUMBER FROM OFFICES» SQL so‘rovdagi xizmatchi so‘zlarni aniqlang?
A) SELECT, CITY
B) SELECT, FROM
C) SELECT, OFFICENUMBER
D) CITY, FROM


Savol #20
SQL tilida matematik amallarning to‘g‘ri va to‘liq yozilgan qatorni toping ?
A) [+], [-], [^], [*]
B) [+], [-], [/], [^]
C) [+], [-], [/], [*]
D) [+], [-], [/], [x]


Savol #21
Statik funksiyalar ro‘yxati to‘g‘ri keltirilgan qatorni aniqlang?
A) MOD, MIN, SUM
B) MID, MAX, SUM
C) SUM, MAX, MID
D) SUM, MIN, AVG, COUNT


Savol #22
Ma’lumotlar bazasidagi barcha ma’lumotlarni ekranga chiqaruvchi so’rov operatorini to’g’ri belgilang.
A) CREATE DATABASES