Which three statements are true about multiple row subqueries?

• A.They cannot contain a subquery.
• B.Two or more values are always returned from the subquery.
• C.They can contain HAVING clauses.
• D.They can return multiple columns.
• E.They can contain GROUP BY clauses.

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERStable has a CUST_CREDIT_LIMITcolumn of data type NUMBER.
Which two queries execute successfully?

• A.SELECT NVL (cust_credit_limit * .15, 'Not Available') FROM customers;
• B.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not
• C.Available') FROM customers;
  SELECT NVL2 (cust_credit_limit * .15, 'Not Available') FROM customers;
• D.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
• E.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

Comment: *

Name: *

Email: *

Verification: *

Examine this SQL statement:

Which two are true?

• A.The UPDATEstatement executes successfully even if the subquery selects multiple rows
• B.The subquery is not a correlated subquery
• C.All existing rows in the ORDERStable are updated
• D.The subquery is executed for every updated row in the ORDERStable
• E.The subquery is executed before the UPDATEstatement is executed

Comment: *

Name: *

Email: *

Verification: *

You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)

• A.All data along with the table structure is deleted
• B.All viewsand synonyms will remain but they are invalidated
• C.All data in the table are deleted but the table structure will remain
• D.The pending transaction in the session is committed
• E.All indexes on the table will remain but they are invalidated

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query. (Choose three.)

• A.ORDER BY "Last name"
• B.ORDER BY 2, cust_id
• C.ORDER BY CUST_NO
• D.ORDER BY 2,1
• E.ORDER BY "CUST_NO"

Comment: *

Name: *

Email: *

Verification: *