1- Which statement will erase all records in Registration table?

a. Drop table Registration

b. Delete from Registration

c. Delete * from Registration

d. B and C.

2- To create table semester with a primary Key :

a. Create table Semester ( Semester_id number(5) , Start_date date, End_date date , Description varchar2(50));

b. Create table Semester ( Semester_id number(5) , Start_date date, End_date date , Description varchar2(50), Semester_id primary key );

c. Create table Semester ( Semester_id number(5) , Start_date date, End_date date , Description varchar2(50),primary key Semester_id);

d. Create table Semester ( Semester_id primary key number(5) , Start_date date, End_date date , Description varchar2(50), constraint Semester_pk primary key (Semester_id));

3- The query used to add values to the table courses is:

a. insert into courses values(8444,database,3,4);

b. insert into courses values(8444,'database',4);

c. insert into courses values(8444,'database',3,4);

d. insert into courses values('database',8444,3,4);

4- Based on the data inserted to university database, which of the following is a valid update statement:

a. Update majors set major_id=128 where major_name like c%;

b. Update majors set faculty=Engineering where major_name like %engineering%;

c. Update majors set major_name=law where major_id=124;

d. Update majors set major_name=law and faculty=law where major_name like c%;