Diskda saqlanadigan fayllar katologi


Download 51.82 Kb.
bet26/43
Sana05.01.2022
Hajmi51.82 Kb.
#219212
1   ...   22   23   24   25   26   27   28   29   ...   43
Malumotlar bazasi
d) Jadvalning oxiriga qaytish
#96 ==============================================================
Berilgan ismining bosh harfiga nisbatan qidirish qaysi operator orqali amalga oshiriladi
a) CHAR
b) LIKE
c) BETWEEN
d) SELECT
#97==============================================================
INSERT INTO operatorining formulasi keltirilgan qatorni toping
a) CREATE TABLE SET (< qiymatlar royxati >)
b) INSERT INTO < jadval nomi > VALUES (< qiymatlar royxati >)
c) INSERT INTO < jadval nomi > SET (< qiymatlar royxati >)
d) CREATE TABLE VALUES (< qiymatlar royxati >)
#98==============================================================
Jadvallar ayirmasini hosil qilishda qaysi operatordan foydalanishimiz mumkin?
a) UNION
b) EXCEPT
c) INTERSECT
d) UNION ALL
#99============================================================
LEFT [OUTER]
a) Chap tashqi tutashtirish turi
b) Ichki tutashtiish turi
c) O’ng tashqi tutashtirish turi
d) To’liq tashqi tutashtirish turi
#100==========================================================
JOIN … ON operatoriga tariff bering
a) Ichki tutashtirish turi
b) Ustunlar nomi bo’yicha tutashadi
c) Predikat orqali tutashtirishda,chap va o’ng jadvalar ko’rsatilgan predikat yordamida
ulanadi
d) Tabiiy tushuntirishda, chap va ong ustunlarnibir xil ustun ismlari bo’yicha
ulanadi,natijaviy jadvalga bir xil ismlar bir marta kiritiladi

Download 51.82 Kb.

Do'stlaringiz bilan baham:
1   ...   22   23   24   25   26   27   28   29   ...   43




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