Font size
WorksheetsMB-2
Total questions: 17
Worksheet time: 9mins
SQL tili qaysi ma'lumotlar bazasi turiga asosan ishlab chiqiladi?
Realyatsion
Tarmoq
Ierarxiv
Teskari
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
Nechta SQL turi mavjud?
1
2
3
4
DATABASE bog'lanish buyrug'i ko'rsating?
/l
/c
/d
/i
table xususiyatini aniqlash buyrug'i ko'rsating?
/l
/c
/d
/i
SQL tilida DATABASE yaratish buyrigi?
CREATE DATABASE
DROP DATABASE
CREATE TABLE
DROP TABLE
SQL tilida DATABASE o'chirish buyrigi?
CREATE DATABASE
DROP DATABASE
CREATE TABLE
DROP TABLE
SQL tilida jadval yaratish buyrigi?
CREATE DATABASE
DROP DATABASE
CREATE TABLE
DROP TABLE
SQL tilida jadvalni o'chirish buyrigi?
DELETE TABLE
DROP DATABASE
CREATE TABLE
DROP TABLE
SQL tilida butun tip qanday?
INT
VARCHAR
BIGSERIAL
DATE
SQL tilida belgilar to'plami tipi qanday?
INT
VARCHAR
BIGSERIAL
DATE
Structured Query Language
Structured Question Language
Standart Query Language
8+0=3
9+6=2
1+7=0
0+0=?
(a)
Ushbu SQL so'rovda qaysi ustun bo'sh qiymat qabul qilishi mumkin?
CREATE TABLE talaba(
id BIGSERIAL NOT NULL PRIMARY KEY,
name VARCHAR(15) NOT NULL,
email VARCHAR(20) )
id
name
Ushbu SQL so'rovda qaysi ustun(lar) bo'sh qiymat qabul qilmaydi?
CREATE TABLE talaba(
id BIGSERIAL NOT NULL PRIMARY KEY,
name VARCHAR(15) NOT NULL,
email VARCHAR(20) )
id, name
name
id, email
name, email
Ushbu jadvalda qaysi ustunlarga qiymat kiritilishi shart?
CREATE TABLE car (
id BIGSERIAL NOT NULL PRIMARY KEY,
make VARCHAR(50) NOT NULL,
model VARCHAR(50) NOT NULL,
year INT ,
price INT
);
id
make
price
year
