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

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