RelationalDBDesign

SiteMap

Database Analysis

Database Design

Extended DB Features

Oracle SQL Extensions

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 ...`

Select Statement