Quiz Complete, well Done!
DDL commands are executed using the
language.
The
is used to define the structure, schema, and constraints of a database.
DDL
Constraint
CREATE TABLE
Foreign Key
ALTER TABLE
SQL
The
constraint is used to uniquely identify records in a table.
TRUNCATE TABLE
Which statement is used to create a new table in a database?
Data Manipulation Language
Language
Database Definition Language
What is the purpose of the INDEX statement in database definition language?
ADD COLUMN
The
statement is used to delete a table from a database.
In DDL, the CREATE
statement is used to create a new table in a database.
The primary key is defined using the
constraint in a DDL query.
What is the purpose of database definition language (DDL)?
