Quiz Complete, well Done!
In DDL, the CREATE
statement is used to create a new table in a database.
The FOREIGN KEY constraint is used to establish a
between two tables.
Which statement is used to create a new table in a database?
Data Manipulation Language
Schema
Which statement is used to define a view in a database?
DROP TABLE
The ALTER TABLE statement is used to
a table structure.
What is the purpose of the INDEX statement in database definition language?
Which statement is used to add or modify constraints on a table?
Language
Primary Key
RENAME TABLE
ADD COLUMN
Column
The
constraint is used to uniquely identify records in a table.
Database
What is the purpose of the DROP statement in database definition language?
The
statement is used to delete a table from a database.
Constraint
