Which constraint specifies that all values in given column must be unique?
a) NOT NULL
b) UNIQUE
c) PRIMARY KEY
d) FOREIGN KEY
A primary key that consists of two or more columns is called…..
a) foreign key
b) composite key
c) candidate key
d) none of these
Which key is used to create link between data in two tables?
a) foreign key
b) composite key
c) candidate key
d) none of these
How many basic functions of data manipulation language?
a) one
b) two
c) three
d) four
Explanation: INSERT, UPDATE, DELETE
How many types of views?
a) one
b) two
c) three
d) four
Explanation: simple view, complex view
Which of the following view is based on one table?
a) simple view
b) complex view
c) composite view
d) none of these
