5-

The constraint primary key means that the values must be:

a. not null

b. unique

c. not null and unique

d. null

6-

Based on the data inserted to university database, one of the following statements is a valid insert statement into exam_results table:

a. Insert into exam_results values(2018101,8446,first exam);

b. Insert into exam_results values(2018101,8446,null,null,null);

c. Insert into exam_results values(2017101,9442,first exam,20,20);

d. Insert into exam_results values(2017199,9442,second exam,20,20);

7-

What truncate table command means:

a. Delete table

b. Delete all data from a table.

c. Delete redundant data in a table.

d. Both A and B.

8-

Delete from Semester where Semester_id=55; will succeed.

a. True

b. False