|
Diskda saqlanadigan fayllar katologi Ma`lumotlar bazasi-bu
|
| bet | 15/27 | | Sana | 12.01.2024 | | Hajmi | 82,83 Kb. | | #135867 |
Bog'liq Diskda saqlanadigan fayllar katologi-fayllar.orgb) Malumot
c) Yozuv
d) Maydon
#93============================================================
SUM agregat funksiyasing vazifasi?
a) Ko’rsatilgan ustundagi qiymatlar yigindisini hisoblash
b) Ustunning o’rtacha qiymatini hisoblash
c) Ustundagi minimal qiymatni hisoblash
d) Ko’rsatilgan ustundagi qiymatlar sonini hisoblash
#94===============================================================
To’g’ri yozilgan SQL so’rovni ko’rsating
a) CREATE TABLE Talaba (id int(3) primary key,name varchar(20),id_f int(4),FOREIGN KEY
REFERENCES fanlar(id_f));
b) CREATE TABLE Talaba (id int(3) primary key,name varchar(20),id_f int(4),FOREIGN KEY
(id) REFERENCES (id_f));
c) CREATE TABLE Talaba (id int(3) primary key,name varchar(20),id_f int(4),FOREIGN KEY
(id_f) REFERENCES fanlar(id_f));
d) CREATE TABLE Talaba (id int(3) primary key,name varchar(20),id_f int(4),FOREIGN KEY
(id_f) REFERENCES fanlar);
#95 ==============================================================
COMMIT operatorining vazifasi.
a) Tranzaktsiya muaffaqiyatli tugashi
b) Jadvalning boshiga qaytish
c) Tranzaktsiya muaffaqiyatsiz tugashi
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 >)
|
| |
