Data Definition Language (DDL)

Which of the following are TRUE about Data Definition Language (DDL)? You may choose MORE THAN ONE answer.

• Allow user to describe and name the entities, attributes, and relationships required for the application

• support the basic data manipulation operations on the data held in the database

• deletion of data

• define/modify schema

Which of the following is False about "Create table"?

• used to specify a new relation by giving it a name

• declare each attribute by given a name and data type

• used to insert data in a new relation

• declare attribute constraints

Fill in the blanks in the coding below:

CREATE TABLE PRODUCT

(Product_ID VARCHAR(10) NOT NULL UNIQUE,

Product_Name VARCHAR(200),

Unit_Price Numeric(8,2),

PRIMARY KEY________________

What are the functions of "Alter table"? You may choose MORE THAN ONE answer.

• adds a column

• changes column characteristics

• modify data

• deletes a column

Which of the following is FALSE about "Alter table"?

• Used to change table structure

• Used to add table constraints

• Used to remove table constraints

• Used to delete table

Fill in the blank in command below If you want to increase the width of a column named "Salary" to store the data up to billion:

ALTER TABLE STAFF

__________(Salary Numeric(11,2));

Fill in the blank in command below :

CREATE TABLE STUDENT

(STUDENT_ID VARCHAR(10) __________________,

STUDENT_NAME VARCHAR(100),

PRIMARY KEY(STUDENT_ID));

Fill in the blank in command below if you want to delete the column named "Test" in the STAFF table:

ALTER TABLE STAFF

__________ Test;

Fill in the blank in command below if you want to add a column named "Email" in EMPLOYEE table:

___________ TABLE STAFF

ADD Email VARCHAR(100);

The "Department_ID" column in the "EMPLOYEE" table is a FOREIGN KEY references to the "Depart_ID" column in the "DEPARTMENT" table.

Fill in the blanks in the coding below:

CREATE TABLE EMPLOYEE

(Employee_ID VARCHAR(10) NOT NULL UNIQUE,

EmployeeName VARCHAR(100),

ContactNum VARCHAR(12),

Department_ID VARCHAR(10),

PRIMARY KEY(Employee_ID),

FOREIGN KEY ______________________________________________);