Study tips 1Z0-872

Which of the following delete statements the country "Spain" along with all of it’s cities?

How many rows will be returned by the following query?

Which of the following delete statements all of the cities in the country "Spain" from the city table?

Which one produces a different result or produces an error?

Given one inner join query and one outer join query that both produce the same results, which of the following statements is true?

Which query employees’ names along with the name of their bosses?

Which of the following queries is most efficient for listing the names and capitals of each country?

Which of the following statements are true?

Which query will produce a list of all countries with no capital?

How many rows will the following query produce?