A.It executes successfully and updates the records of those employees who have been working in the company for more than 600 days.

B.It gives an error because multiple NVLfunctions are used in an expression.

C.It executes successfully but no rows updated.

D.It gives an error because NVLfunction cannot be used with UPDATE.

A.inv_amt = '0255982' : requires explicit conversion

B.inv_no BETWEEN '101' AND '110' : uses implicit conversion

C.inv_date > '01-02-2008' : uses implicit conversion

D.CONCAT(inv_amt, inv_date) : requires explicit conversion

E.inv_date = '15-february-2008' :uses implicit conversion

A.The WHERE and HAVING clauses cannot be used together in a SQL statement.

B.The HAVING clause is used to exclude one or more aggregated results after grouping data.

C.The WHERE clause is used to exclude rows before grouping data.

D.The HAVING clause conditions can have aggregating functions.

E.The HAVING clause conditions can use aliases for the columns.

A.A subquery can be used in a WHERE clause.

B.A subquery cannot be used in the select list.

C.= ANY can only evaluate the argument against a subquery If it returns two or more values.

D.A subquery cannot be used in a from clause.

E.< any returns true If the argument Is less than the lowest value returned by the subquery.

F.< ANY returns true If the argument is less than the highest value returned by the subquery.

G.A subquery can be used in a having clause.

A.They return a single result row per table.

B.They can be nested to any level.

C.They can accept only one argument.

D.They can be used only in the where clause of a select statement.

E.The argument can be a column name, variable, literal or an expression.

F.The date type returned can be different from the data type of the argument.