Database Management Systems Quiz 1: 15 March 2026 (January 2026 term)

1. A

   Data Definition Language

2. B

   Data Manipulation Language

3. C

   Data Control Language

4. D

   All of these

Select all that apply.

1. A

   CREATE TABLE Course ( id VARCHAR(5) PRIMARY KEY, name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor(id) )

2. B

   CREATE TABLE Course ( id VARCHAR(5) PRIMARY KEY, name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor.id )

3. C

   CREATE TABLE Course ( id VARCHAR(5), name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor, )

4. D

   CREATE TABLE Course ( id VARCHAR(5), name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) PRIMARY KEY (id), FOREIGN KEY (instructor_id) REFERENCES Instructor(id) )

Choose the correct option(s) from the following.

Select all that apply.

1. A

   

2. B

   

3. C

   

4. D

   —