Worksheets11-mavzu. Pythonda PostgreSQL yordamida ma’lumotlarni yangilash
Total questions: 15
Worksheet time: 10mins
PostgreSQLda ma’lumotlarni yangilash operatorini tanlang.
update
select
insert into
primary key
Nuqtalar o'rniga mos kalit so'zni kiriting?
UPDATE jadval_nomi ... ismi='Akmal'
WHERE id=5;
(a)
Nuqtalar o'rniga mos kalit so'zni kiriting?
... jadval_nomi SET ismi='Akmal'
WHERE id=5;
(a)
yoshi 50 dan kattalarni maoshi 20 foizga oshish so'rivini tanlang?.
update set talaba maoshi = maoshi*1.2 where yoshi>50;
update set talaba maoshi = maoshi*1.2 where yoshi>=50;
update set talaba where yoshi>50;
update set talaba maoshi = maoshi*1.2;
barchaning maoshi 20 foizga oshish so'rivini tanlang?
update set talaba maoshi = maoshi*1.2 where yoshi>50;
update set talaba maoshi = maoshi*1.2 where yoshi>=50;
update set talaba where yoshi>50;
update set talaba maoshi = maoshi*1.2;
UPDATE so‘rovining vazifasi nimadan iborat?
jadvaldan barcha ma’lumotlarni chiqarish
jadval ichidagi qiymаtlаrini o‘zgаrtirish uchun
jadvaldan barcha ma’lumotlarni o‘chirish
jadvaldagi berilgan ustunni tartiblash
UPDATE person SET email=...;
email ustuniga bo'shq qiymat(lar) kiriting;
(a)
UPDATE talaba
... name='Javlon'
WHERE country='Uzbekistan';
Nuqtalar o'rniga mos so'zni kiriting?
(a)
UPDATE talaba
SET country='Uzbekistan';
WHERE email = ...
Nuqtalar o'rniga emaili ' (a) .uz' bo'lgan satrlarni almashtirish amalga oshirilsin?
SQL tilida belgilar to'plami tipi qanday?
INT
VARCHAR
BIGSERIAL
DATE
Pythonda GUI (Graphical User Interface) yaratish uchun qaysi kutubxona(lar)dan foydalaniladi.
Tkinter
PyQT
sqlite3
pillow
SQL tili qaysi ma'lumotlar bazasi turiga asosan ishlab chiqiladi?
Realyatsion
Tarmoq
Ierarxiv
Teskari
select ismi, yoshi from jadval_nomi;
Nechta ustundan qiymat tanlab olinadi?
2
1
3
4
Hozir kim sizga ma'ruza mashg'ulotini olib bormoqda
Jumayev Turdali Rashidovich
Jumayev Turdali Saminjonovich
Jumayev Turdali Tolipovicj
Bo’sh kataklar to’ldiring.
G
7
2
B
D
4
F
1
