PrepAway - Latest Free Exam Questions & Answers

Which of the following is NOT a valid DDL command?

Which of the following is NOT a valid DDL command?

PrepAway - Latest Free Exam Questions & Answers

A.
UPDATE

B.
ALTER

C.
DROP

D.
CREATE

Explanation:
UPDATE is a DML command. Data-definition language (DDL) is used to specify a database schema by
a set of definitions. It is a computer
language for defining data structures. The term was first introduced in relation to the Codasyl
database model, where the schema of the
database was written in a Data Definition Language describing the records, fields, and “sets” making
up the user Data Model. The term DDL is
used in a generic sense to refer to any formal language for describing data or information structures,
like XML schemas. CREATE, DROP, and
ALTER are the major DDL commands.
Answer C, B, and D are incorrect. DROP, ALTER, and CREATE are valid DDL commands.


Leave a Reply