SQL Flashcards
1
Q
Name domain types in SQL.
A
char, varchar, int, smallint, numeric, real, double, float
2
Q
Name integrity constraint in Create Table query.
A
not null and Primary Key
3
Q
Give syntax of Alter table.
A
alter table r add A D
alter table r drop A
4
Q
Name aggregate functions of SQL.
A
avg min max sum count
5
Q
Give syntax of view.
A
create view v as
