Computer Science
Which of the following sublanguages of SQL is used to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- Query
- Relational Schema
Answer
DML (Data Manipulation Language)
Reason — In SQL, Data Manipulation Language (DML) statements are used to manipulate data in the database. DML statements are used to query information from the database, as well as to insert, delete, and modify tuples (rows) in the database tables.
Related Questions
Which is the subset of SQL commands used to manipulate database structures, including tables ?
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Both (1) and (2)
- None of these
Which of the following sublanguages of SQL is used to define the structure of the relation, deleting relations and relating schemas?
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- Query
- Relational Schema
Consider following SQL statement. What type of statement is this?
SELECT * FROM employee- DML
- DDL
- DCL
- Integrity constraint
Which of the following keywords will you use in the following query to display the unique values of the column dept_name ?
SELECT ............... dept_name FROM Company;- All
- From
- Distinct
- Name