Databse

1.Assuming a Student table is created with the following CREATE TABLE command.

CREATE TABLE Student

(StudentNo number,

Name varchar2(10),

Kulliyyah char(5),

Specialization char(5));

To delete the Specialization column in the table above, which command is CORRECT?

Select one:

A.ALTER TABLE Student DROP COLUMN Specialization;

B.UPDATE Student SET Specialization = NULL;

C.TRUNCATE TABLE Student (COLUMN Specialization);

D.DELETE FROM Student (Specialization);

2. Based on Student table in Question 4, modify the table to add a primary key to the StudentNo column. The table is currently empty. Which statement accomplishes this task?

Select one:

A.ALTER TABLE Student ADD StudentNo AS PRIMARY KEY;

B.ALTER Student ADD CONSTRAINT studentno_pk PRIMARY KEY StudentNo;

C.ALTER TABLE Student ADD CONSTRAINT studentno_pk PRIMARY KEY (StudentNo);

D.ALTER TABLE Student MODIFY CONSTRAINT studentno_pk PRIMARY KEY (StudentNo);