Examine the structures of the PRODUCTS and SALES tables in the Exhibits below. 

Which of the following SQL statements would produce identical output? (Select two.)

Which of the following statements are true in regards of subqueries? (Select three.)

Analyze the SQL statement that follows: 

> SELECT cust_id, cust_last_name FROM customers WHERE cust_credit_limit IN (select cust_credit_limit FROM customers WHERE cust_city = ‘Singapore’); 

Which of the following statements is true about the above query if the subquery generates at least one null value?

Which of the following statements are true regarding data types in a database Oracle 10g/11g? (Select three.)

Evaluate the structure of the EMPLOYEES table in the Exhibit: 

Which of the following UPDATE statements is valid?

Which of the following statements are true about the uses of the MERGE command? (Select three.)

Which of the following statements are true in regards of the USING and ON clauses in table joins? (Select two.)