Question 116
In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?
Evaluate the following query:

What would be the outcome?
Question 117
Examine the data in the CUSTOMERS table:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

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

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.)
Question 118
Which statement is true regarding external tables?
Question 119
Examine this statement which returns the name of each employee and their manager:

You want to extend the query to include employees with no manager. What must you add before JOINto do this?

You want to extend the query to include employees with no manager. What must you add before JOINto do this?
Question 120
Which two statements are true regarding the USING and ON clauses in table joins?
