A. UPDATE
B. ALTER
C. DROP
D. CREATE
Sign Up to our social questions and Answers Engine to ask questions, answer people's questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
“UPDATE” is a DML command that is not valid. A data-definition language (DDL) is a collection of definitions that is used to describe a database structure. It is a programming language used in defining data structures. The word was initially used in reference to the Codasyl database model, in which it defined the database schema in a DDL detailing the entries, fields, and “sets” that comprised the user Data Model. In a broad sense, the word DDL refers to any formal language for expressing data or information structures, such as XML schemas. The primary DDL commands are CREATE, DROP, and ALTER.
Answers C, B, and D are all wrong. DDL commands such as DROP, ALTER, and CREATE are all permitted.
Database structures can only be created, modified, or deleted using DDL commands. By using an application to access the database, DDL commands are used.
DDL COMMANDS:
CREATE, DROP, ALTER, TRUNCATE, COMMENT, AND RENAME.
According to question UPDATE is not a DDL Command it is a DML command.
Hence, option A) UPDATE is the right answer.
I hope you got an answer!…