F/I/O_________________________________________________________________
Guruh________________________________________________________________
MA’LUMOTLAR BAZASINI BOSHQARISH FANIDAN 1-ORALIQ NAZORAT UCHUN TOPSHIRIQLAR
МББ узб-11
1.Domen bu ....?
a) ustun c) katakcha
b) jadval d) qator
2. CREATE TABLE jadval yaratish operatorida NULL nimani anglatadi?
a) Jadval satrilarida bo‘sh probellar bo‘lmasligini
b) Ustinda qiymat bermaslikka ruxsat berishni
c) Ustunga tegishli bo‘lgan satr qiymatlari bo‘sh bo‘lmasligini
d) Jadval bo‘m bo‘shligini
3.Ob’ektlar orasidagi munosabat turini aniqlang: talaba va reyting daftarchasi
a) n:m c) Aloqa yo‘q
b) 1:1 d) m:1
4. Jadvaldagi ustunga qo‘yilgan qanday cheklanish ustun qiymatlarini bog‘langan jadvaldagi birlamchi kalit qiymatlaridan oladi?
a) NOT NULL c) CHECK
b) CHECK d) FORGN KEY
5. ‘Paris’ - bu
a) Bulli konstanta c) Sonli konstanta
b) O‘zgaruvchi d) Satrli konstanta
6.To‘liq tashqi bog‘lanish operatori - bu
a) FULL OUTER JOIN c) LEFT OUTER JOIN
b) RIGHT OUTER JOIN d) INNER JOIN
7.Bitta rolda nechta foydalanuvchi bo‘lishi mumkin?
a) Uchtadan ko‘p emas c) Ikkita
b) Bir nechta d) Bitta
8.Tranzaksiya dispecheriga ta’rif bering
a) MB ishini boshqaruvchi tizimli komponent
b) Ma’lumotlarni qabul qilinishi va uzatilishining jadval bo’yicha hujjatlashtirilishi
d) Tranzaksiyalarning atomarligini ta’minlovchi tizimli komponenta
9.Bir nechta shartlardan foydalanishda WHERE operatorida shartlar orasi qanday ajratiladi?
a) Kalit so‘zlar, AND yoki OR operatorlari c) Vergul
b) FROM kalit so‘zi d) Nuqtali vergul
10.Nechta normal forma mavjud?
a) 6 c) 4
b) 3 d) 5
11.Axborot tizimlari tushunchasi?
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Do'stlaringiz bilan baham: |
