Mantiqiy not amallarini bajarish qoidasi to’g’ri yozilgan qatorni aniqlang


Download 37.5 Kb.
Sana14.11.2020
Hajmi37.5 Kb.

  1. Mantiqiy NOT amallarini bajarish qoidasi to’g’ri yozilgan qatorni aniqlang.

{~%100%NOT(ifoda 1)

~%0%(ifoda1, NOT), ifoda2

~%0%Ifoda1(NOT ifoda2)

~%0%Ifoda1(NOT) ifoda2}



  1. SQL tilida belgili ma’lumotlarning tiplari to’g’ri keltirilgan qatorni aniqlang

{~%0%CHAR, STR,STRING

~%100%CHAR, NCHAR, CHARACTER

~%0%TEXT, STRING, LONGCHAR

~%0%STR, NCHAR,CHARACTER}



  1. Birinchi pullik MBBT tizimini aniqlang?

{~%100%ORACLE

~%0%SQL SERVER

~%0%System/R

~%0%IBM}


  1. SQL tilining xizmatchi so’zlar to’g’ri keltirilgan qatorni aniqlang?

{~%0%CASE, FOR,AS,BREAK

~%100%CASE,THEN,ELSE,WHILE

~%0%CASE, IF,FOR,AS

~%0%CASE, IF,AS,CONTINUE}



  1. INSERT INTO OFFICES(CITY) VALUES(‘SAMARQAND’) so’rovdagi xizmatchi so’zni aniqlan

{~%0%CITY

~%0%SAMARQAND

~%0%OFFICE

~%100%INSERT INTO}



  1. OPEN SERVER da UPPER static funksiyasining vazifasini aniqlang?

{~%0%Katta bo’lsa kichik harfni registrga o’tkazish

~%100%Kichik bo’lsa katta harf registrga o’tkazish

~%0%Kichik harf registrga o’tkazish

~%0%Katta harf registrga o’tkazish}



  1. LIKE operatorida nechta mantiqiy ifoda qatnashadi?

{~%0%3 ta

~%100%0 ta

~%0%4 ta

~%0%2 ta}



  1. Statik funksiyalar ro’yxati to’g’ri keltirilgan qatorni aniqlang

{~%0%SUM, MAX, LIN

~%0%SUM, MAX,FOUND

~%0%SUM, MAX, LENGTH

~%100%SUM,MAX,MID}



  1. SQL tilida munosabat amallarini to’g’ri va to’liq yozilgan qatorni toping

{~%0%[>],[>=],[<=],[==],[<]

~%0%[>],[>=],[<=],[!=],[=],[<]

~%100%[>],[>=],[<=],[<>],[=],[<]

~%0%[>],[>=],[<=],[!=],[==],[<]}



  1. Matematik amallarni bajarish qoidasi to’g’ri yozilgan qatorni aniqlang?

{~%0%Matematik amal(ifoda1, ifoda2)

~%100%Ifoda1(matematika amal) ifoda2

~%0%Ifoda1(matematik amal, ifoda2)

~%0%(ifoda1, matematik amal), ifoda2}



  1. IN operatorining vazifasi nimadan iborat?

{~%0%Ifodani to’plamga bog’lash

~%0%Ikkita ifodani soddalashtirish

~%0%Ifodani to’plam bilan solishtirish

~%100%Ifodani to’plamga tegishliligini tekshirish}



  1. OPEN SERVER da FORMAT static funksiyaning vazifasini aniqlang

{~%100%Bunday funksiya yo’q

%0%Joriy vaqtni qaytaradi

%0%Joriy(oxirgi) SELECT so’rovi

%0%Joriy(oxirgi) so’rov}



  1. SQL tilida SELECT operatori va maydon nomi orasida nimalar yozilishi mumkin?

{~%100%Hech nima yoki DISTINCT yoki ALL

~%0%DISTINCT

~%0%Hech nima

~%0%Hech nima yoki DISTINCT}



  1. BETWEEN operatorida nechta mantiqiy ifoda qatnashadi?

{~%100%1 ta

~%0%4 ta


~%0%2 ta

~%0%3 ta}



  1. LIKE operatorida NOT xizmatchi so’zni ishlatish mumkinmi?

{~%100%Ha

~%0%Yo’q


~%0%Mantiqiy ifodada ishlatish mumkin

~%0%Mantiqiy operatorlar bilan}
Download 37.5 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2020
ma'muriyatiga murojaat qiling