COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SELECT
|
|
|
INSERT
|
|
|
UPDATE
|
|
|
CREATE
|
Detailed explanation-1: -The correct answer is option D (Create). CREATE command is a data definition language command but not a data manipulation command.
Detailed explanation-2: -A popular data manipulation language is Structured Query Language or SQL, used to retrieve and manipulate data in a relational database. With SQL, you can perform operations on the database and also use it to create a database. SQL uses specific commands like Create, Drop, Insert, etc., to carry out the required tasks.
Detailed explanation-3: -A DML (data manipulation language) refers to a computer programming language that allows you to add (insert), delete (delete), and alter (update) data in a database. A DML is typically a sublanguage of a larger database language like SQL, with the DML containing some of the language’s operators.
Detailed explanation-4: -2. In SQL, which of the following is not a data Manipulation Language Commands? Explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.
Detailed explanation-5: -Answer: Delete is not a DML command.