MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
select all DML commands are:-
A
INSERT
B
UPDATE
C
DELETE
D
GRANT
Explanation: 

Detailed explanation-1: -Delete is a DML or Data Manipulation Command that is used to delete particular records from a table. It deletes the complete row from the table and produces the number of deleted rows as output. You can use the WHERE clause with the DELETE command to delete specific records from the table.

Detailed explanation-2: -DML commands include SELECT, INSERT, UPDATE, and DELETE.

Detailed explanation-3: -SELECT. SELECT command or statement in SQL is used to fetch data records from the database table and present it in the form of a result set. It is usually considered as a DQL command but it can also be considered as DML.

There is 1 question to complete.