Which statement is true regarding COALESCE function?

Which statement is true regarding the effect of the above SQL statement?

The following are the steps for a correlated subquery, listed in random order:

Which CREATE TABLE statement is valid?

Which statement is true regarding the ROLLUP operator specified in the GROUP BY clause of a SQL statement?

Which mandatory clause has to be added to the following statement to successfully create an external table called EMPDET?

Which data type would you use for such a column in the table?

Which statement is true regarding external tables?

In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

Which command would work in relation to the EMPDET table?

Which statement is true about the DELETE statement?