Computer Science
Consider following SQL statement. What type of statement is this?
SELECT * FROM employee
- DML
- DDL
- DCL
- Integrity constraint
SQL Queries
2 Likes
Answer
DML
Reason — Data Manipulation Language (DML) statements are used to retrieve, insert, update, and delete data in a database. The 'SELECT' statement, in particular, is used to retrieve data from one or more tables.
Answered By
3 Likes
Related Questions
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
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
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
Which of the following keywords will you use in the following query to display all the values of the column dept_name ?
SELECT ............... dept_name FROM Company;- All
- From
- Distinct
- Name