Consider following SQL statement. What type of statement is this?

SELECT * FROM employee

1. DML
2. DDL
3. DCL
4. Integrity constraint

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;

1. All
2. From
3. Distinct
4. Name

The …………… clause of SELECT query allows us to select only those rows in the result that satisfy a specified condition.

1. Where
2. from
3. having
4. like

…………… clause of the following query must be added with keyword …………… to display the fields given in the select list as per a given condition.

SELECT ID, name, dept name, salary * 1.1
WHERE instructor = 1005 ;

1. where, having
2. select, from
3. where, from
4. where, select