Quiz 2 ADS

It is a specific request for data manipulation issued by the end-user or the application to the DBMS.

• Constrint

• Query

SQL can perform various types of data manipulation only.

• True

• False

What is the proper syntax for creating a table?

• CREATE TABLE table_name (column1 datatype, …);

• CREATE TABLE table_name (datatype column1 datatype, …);

• CREATE table_name (datatype column1 datatype, …);

• CREATE table_name (datatype column1);

If you want to delete table's data, what is the proper syntax?

• TRUNCATE table_name;

• TRUNCATE table table_name;

What is the proper syntax to add column to an existing table?

• ALTER TABLE table_name ADD COLUMN column_name datatype;

• ALTER TABLE ADD COLUMN column_name datatype;

What is the proper syntax to drop column to an existing table?

• ALTER TABLE Students DROP COLUMN Section;

• ALTER TABLE Students DROP Section;

What is the proper syntax for adding a UNIQUE constraint on an existing table?

• ALTER TABLE table_name ADD UNIQUE (column);

• ALTER TABLE ADD UNIQUE (column);

What uniquely identifies each row in a table?

• UNIQUE KEY

• PRIMARY KEY

What uniquely identifies a row in another table?

• FOREIGN KEY

• UNIQUE KEY

Which section has the default value on the following query:

CREATE TABLE Students (StudentID varchar(5) NOT NULL, LastName varchar(99) NOT NULL, FirstName varchar(99) NOT NULL, Course varchar(5) DEFAULT 'Not yet enrolled');

• FirstName

• LastName

• Course

• Section