Study tips 1Z0-051

Which statement is true regarding the above query if one of the values generated by the subquery is NULL?

Which SQL statement gives the required output?

Which three statements are true about multiple-row subqueries?

Which statement is true regarding subqueries?

Which three statements are true regarding subqueries?

Where can subqueries be used?

Which two statements are true regarding subqueries?

Which two JOIN options can be used in the blank in the above query to give the correct output?

Which two methods can you use to get the required result?

Which two statements are true regarding the USING clause in table joins?