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?
  • 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.)
  • 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?
  • Question 120

    Which two statements are true regarding the USING and ON clauses in table joins?