Quiz Complete, well Done!
The
constraint is used to uniquely identify records in a table.
DDL
ALTER TABLE
The UNIQUE constraint ensures that all values in a column are
.
SQL
CREATE TABLE
Which statement is used to add or modify constraints on a table?
Data Manipulation Language
Database
DROP COLUMN
The
is used to define the structure, schema, and constraints of a database.
Which statement is used to define a view in a database?
The FOREIGN KEY constraint is used to establish a
between two tables.
Which statement is used to grant privileges to a user in a database?
Database Definition Language
Which statement is used to modify an existing table in a database?
Which statement is used to create a new table in a database?
What is the purpose of database definition language (DDL)?
Schema
Primary Key