Which of the following language is used to define the integrity constraints

Options
- DCL
- DML
- DDL
- All of the above

CORRECT ANSWER : DDL

Discussion Board
DDL

Data Definition Language (DDL) statements are used to define the database structure or schema.
CREATE: It is used to create objects in the database.
ALTER: It alters the structure of the database.
DROP: It deletes object from the database.
TRUNCATE: It removes all the records from a table, including all spaces allocated for the records are removed.
COMMENT: It adds comment to the data dictionary.
RENAME: It renames an object.

Prajakta Pandit 03-15-2017 02:45 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲