ANSWER : Lateral

Explanation : :Select name, salary, avg salary from instructor I1, lateral (select avg(salary) as avg salary from instructor I2 where I2.dept name= I1.dept name); Without the lateral clause, the subquery cannot access the correlation variable I1 from the outer query.

ANSWER : SELECT city FROM weather WHERE humidity = 95

Explanation : : The SQL WHERE clause is used to filter the results and apply conditions in a SELECT, INSERT, UPDATE, or DELETE statement.

ANSWER : DELETE FROM CUSTOMER WHERE..

Explanation : :The SQL DELETE Query is used to delete the existing records from a table. You can use WHERE clause with DELETE query to delete selected rows.

ANSWER : Feature has two 0′s in it, at any position

Explanation : :The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

ANSWER : COMMIT

Explanation : :Rollback is used for undoing the work done in the current transaction. This command also releases the locks if any hold by the current transaction.