Select Statement  «Prev  Next»

Oracle Extensions - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following comparisons evaluates as true when the TAX_AMOUNT column is equal to 100 and ITEM_AMOUNT = 250?
Please select the best answer.
  A. NOT( TAX_AMOUNT > ITEM_AMOUNT )
  B. ITEM_AMOUNT - TAX_AMOUNT * 5 > 400
  C. TAX_AMOUNT + ITEM_AMOUNT > 300 AND ITEM_AMOUNT / TAX_AMOUNT < 2
  D. ITEM_AMOUNT * 0 - TAX_AMOUNT * 0 IS NULL

2. Which of the following SQL clauses is an Oracle extension to standard SQL?
Please select the best answer.
  A. CONNECT BY
  B. HAVING
  C. DISTINCT
  D. LIKE

3. 3. Which of the following SQL snippets will require a GROUP BY clause in the completed SQL query?
Please select all the correct answers.
  A. SELECT DISTINCT LASTNAME, TO_CHAR(SALE_DATE,'Month') FROM CUSTOMER C, CUSTOMER_SALE CS WHERE ...
  B. SELECT LASTNAME, MIN(TOTAL_SALE_AMOUNT) FROM CUSTOMER C, CUSTOMER_SALE CS WHERE ...
  C. SELECT AVG(SALE_PRICE), PET_FLAG, MIN(SALE_AMOUNT) FROM PRODUCT P, SALE_ITEM SI WHERE ...
  D. SELECT USER, MAX(LAST_UPDATE_DATE) FROM PRODUCT WHERE ...