Study tips 1Z0-047

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

A non-correlated subquery can be defined as ____.

Which two statements are true regarding the EXISTS operator used in the correlated subqueries?

Which statement is true regarding external tables?

Which statement correctly grants a system privilege?

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 regarding the effect of the above SQL statement?

What would be the outcome after executing the statements?

Which two statements is true regarding the execution of the correlated subqueries?