Data Definition Language Quiz D2

What is DDL?

What is SQL Constraints?

What is Data Types?

What is the syntax for CREATE DATABASE?

• CREATE DATABASE DatabaseName;

• CREATE DATABASE dbSIS;

• CREATE DATABASE table_name;

• CREATE DATABASE table;

What is the syntax for CREATE TABLE?

• CREATE TABLE table_name( Column_name1 datatype(Size) constraints, Column_name2 datatype(Size) constraints, ..... Column_nameN datatype(Size) constraints);

• CREATE TABLE table_name;

• CREATE TABLE table_name( Column_name1, Column_name2 );

• CREATE TABLE table_name( Column_name1 datatype, Column_name2 datatype );

What is the function of ALTER command?

• It adds, deletes, or modifies columns in an existing table.

• It creates a new table.

• It drops a table.

• It truncates a table.

What is the syntax for ALTER TABLE - ADD Column?

• ALTER TABLE table_name ADD column_name datatype;

• ALTER TABLE table_name ADD column_name;

• ALTER TABLE table_name ADD column_name datatype constraints;

• ALTER TABLE table_name ADD column_name;

What is the syntax for ALTER TABLE - MODIFY Column?

• ALTER TABLE table_name MODIFY column_name datatype;

• ALTER TABLE table_name MODIFY column_name;

• ALTER TABLE table_name CHANGE column_name datatype;

• ALTER TABLE table_name ALTER column_name datatype;

What is the syntax for ALTER TABLE - DROP COLUMN?

• ALTER TABLE table_name DROP COLUMN column_name;

• ALTER TABLE table_name DROP column_name;

• ALTER TABLE table_name REMOVE COLUMN column_name;

• ALTER TABLE table_name DELETE COLUMN column_name;

What is the syntax for DROP TABLE?

• DROP TABLE table_name;

• DELETE TABLE table_name;

• REMOVE TABLE table_name;

• DROP table_name;