Quiz Complete, well Done!
Language
Foreign Key
The DROP TABLE statement is used to
a table.
Data Manipulation Language
Database
ALTER TABLE is used to
the structure of an existing table.
What is the purpose of the DROP statement in database definition language?
The ALTER TABLE statement is used to
a table structure.
The primary key is defined using the
constraint in a DDL query.
The UNIQUE constraint ensures that all values in a column are
.
The
constraint is used to uniquely identify records in a table.
Which statement is used to add or modify constraints on a table?
Schema
Which statement is used to define a view in a database?
DDL stands for
.
DDL
The DEFAULT constraint is used to provide a default value for a
when no value is specified.
Which statement is used to grant privileges to a user in a database?
Constraint
The NOT NULL constraint ensures that a column cannot contain
values.
