Consider the SQL statement(s) below:

S1:

CREATE table employees( emp_id number(2),
first_name varchar2(20), last_name varchar2(20)) ;

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.

Question

Consider the SQL statement(s) below:

S1:

CREATE table employees( emp_id number(2),
first_name varchar2(20), last_name varchar2(20)) ;

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.

Answer

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

Answer

S1
is a Data Definition (DDL) Query and S2 is a Data Manipulation Query (DML)

Answer

Both
S1 and S2 are Data Manipulation (DML) Queries

Crowdly

Consider the SQL statement(s) below: S1: CREATE table employees( e...

Want instant access to all verified answers on moodle.spit.ac.in?