Question

Consider the SQL statement(s) below:

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;

Identify the correct statement related to S1 and S2
Both S1 and S2 are Data Definition (DDL) Queries
S1 is a Data Control Query and S2 is a Data Manipulation (DML) Query
Both S1 and S2 are Data Manipulation (DML) Queries
S1 is a Data Definition (DDL) Query and S2 is a Data Control Query

Answer 1

thank you for asking the question !!!

Both S1 and S2 are Data Manipulation (DML) Queries as "select" and "insert" operations are both DML operations.
S1 is a Data Definition (DDL) Query and S2 is a Data Control Query.

Answer 2

The answer is Option 3.

The correct statement related to S1 and S2 are Both S1 and S2 are Data Manipulation (DML) queries.

A DML statement helps in retrieving, updating (modifying), storing, inserting and deleting data in a database. It includes all the SQL data change statements that only modify the data that have been stored and not the database or schema objects.