Quiz Complete, well Done!
ALTER TABLE
Data Manipulation Language
ALTER TABLE is used to
the structure of an existing table.
The
statement is used to delete a table from a database.
Database
What is the purpose of the INDEX statement in database definition language?
The
constraint is used to uniquely identify records in a table.
Which statement is used to add or modify constraints on a table?
DROP TABLE
What is the purpose of database definition language (DDL)?
Database Definition Language
Which statement is used to create a new table in a database?
In DDL, the CREATE
statement is used to create a new table in a database.
Constraint
Schema
The
is used to define the structure, schema, and constraints of a database.
DROP COLUMN
Which statement is used to modify an existing table in a database?
SQL
CREATE TABLE
