SQL

Question 1

Name domain types in SQL.

Answer 1

char, varchar, int, smallint, numeric, real, double, float

Question 2

Name integrity constraint in Create Table query.

Answer 2

not null and Primary Key

Question 3

Give syntax of Alter table.

Answer 3

alter table r add A D

alter table r drop A

Question 4

Name aggregate functions of SQL.

Answer 4

avg
min
max
sum
count

Question 5

Give syntax of view.

Answer 5

create view v as