Question

s1:

INSERT INTO employees(first_name, last_name, fname)

VALUES (`John', `Capita', `xcapit00');

s2:

SELECT instructor.ID, department.dept_name

FROM instructor, department

WHERE instructor.dept_name = department.dept_name

AND department.budget > 95000;


a) Both S1 and S2 are Data Definition (DDL) Queries

b) S1 is a Data Control Query and S2 is a Data Manipulation (DML) Query

c) Both S1 and S2 are Data Manipulation (DML) Queries

d) S1 is a Data Definition (DDL) Query and S2 is a Data Control Query

Answer 1

c) Both S1 and S2 are Data Manipulation (DML) Queries

Because DML is short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in a database.