COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data Control Language(DCL)
|
|
|
Transcation Control language(TCL)
|
|
|
Data Manipulation language(DML)
|
|
|
Data Definition language(DDL)
|
Detailed explanation-1: -The SELECT statement is a limited form of DML statement in that it can only access data in the database. It cannot manipulate data in the database, although it can operate on the accessed data before returning the results of the query.
Detailed explanation-2: -It’s DML because SELECT is DML.
Detailed explanation-3: -DDL is about “metadata". DML allows to add / modify / delete data itself. SELECT is the main DQL instruction.
Detailed explanation-4: -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-5: -SQL is only a data manipulation language (DML). SQL was developed by IBM in the late 1970s. In addition to being a data sublanguage, SQL is also a programming language, like Java or C#. SQL commands can be embedded in application programs.