Font size
WorksheetsMB-8
Total questions: 15
Worksheet time: 9mins
Ushbu jadvalda qaysi ustun unikal qiymat qabul qiladi?
CREATE TABLE talaba (
id BIGSERIAL NOT NULL PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(50));
(a)
PRIMARY KEY – bu ...
ma’lumotlarni yagonalik identifikatsiyasi
ma'lumotlarni o'chiradi
bir xil ma’lumotlarni kiritish imkonini beradi
ma'lumotlarni nusxalaydi
Ma’lumotlarni yagonalik identifikatsiyasi - ...
(a)
PRIMARY KEY ni bir nechta ustunga qo'llash mumkin.
Ha
Yo'q
Jadvaldagi ustunlarga PRIMARY KEY ni o‘chirish so'rovi to'g'ri ko'rsatilgan javobni belgilang?
ALTER TABLE table_name ADD PRIMARY KEY(field_name);
ALTER TABLE table_name DROP CONSTRAINT field_name_pk;
ALTER TABLE table_name DROP field_name;
ALTER TABLE table_name ADD field_name <type>;
Jadvaldagi ustunlarga PRIMARY KEY ni qo'shish so'rovi to'g'ri ko'rsatilgan javobni belgilang?
ALTER TABLE table_name ADD PRIMARY KEY(field_name);
ALTER TABLE table_name DROP CONSTRAINT field_name_pk;
ALTER TABLE table_name DROP field_name;
ALTER TABLE table_name ADD field_name <type>;
Jadvaldagi yangi ustun qo'shish so'rovi to'g'ri ko'rsatilgan javobni belgilang?
ALTER TABLE table_name ADD PRIMARY KEY(field_name);
ALTER TABLE table_name DROP CONSTRAINT field_name_pk;
ALTER TABLE table_name DROP field_name;
ALTER TABLE table_name ADD field_name <type>;
Jadvaldagi ustunni o'chirish so'rovi to'g'ri ko'rsatilgan javobni belgilang?
ALTER TABLE table_name ADD PRIMARY KEY(field_name);
ALTER TABLE table_name DROP CONSTRAINT field_name_pk;
ALTER TABLE table_name DROP field_name;
ALTER TABLE table_name ADD field_name <type>;
DATABASE ro'yhatini ko'rish buyrug'i qanday?
/l
/c
/d
/dt
SQL tili kim tomonidan ishlab chiqarilgan?
E. F. KODD
B.PASKAL
N.VIRT
E.NOBEL
SQL tilida belgilar to'plami tipi qanday?
INT
VARCHAR
BIGSERIAL
DATE
Diapazonga tegishliligini tekshirish operatori qanday?
(a)
5*1=5
3*7=1
13*77=1
10*8=0
5*5=?
(a)
Ushbu SQL so'rovning natijasi nima chiqadi? SELECT COALESCE(NULL, 7);
NULL
7
7.1
0
Ushbu SQL so'rovning natijasi nima chiqadi? SELECT NULLIF(7, 18);
nullif
null
7
18
