1Z0-061 Free Practice Test

- (Topic 4)
View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.
<>>>>>>>>

1. A. Only the first query executes successfully.
2. B. Only the second query executes successfully.
3. C. Both queries execute successfully but give different results.
4. D. Both queries execute successfully and give the same result.

Correct Answer: B
Note: You cannot use column alias in the WHERE clause.

- (Topic 3)
Which two statements are true about WHERE and HAVING clauses? (Choose two)

1. A. A WHERE clause can be used to restrict both rows and groups.
2. B. A WHERE clause can be used to restrict rows only.
3. C. A HAVING clause can be used to restrict both rows and groups.
4. D. A HAVING clause can be used to restrict groups only.
5. E. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
6. F. A HAVING clause CANNOT be used in sub queries.

Correct Answer: BD
B: WHERE clause cannot be use to restrict groups
WHERE clause cannot be use when there is group functions. D: A HAVING clause can only e used to restrict GROUPS.
Note: HAVING clause to specify which groups are to be displayed and thus further restrict the groups on
the basis of aggregate information. The Oracle server performs the following steps when you use the Having clause
1. rows are grouped
2. the group function is applied to the group
3. the group that match the criteria in the Having clause are displayed.
Incorrect Answers :
A- Where clause cannot be use to restrict groups
C- A HAVING clause can only e used to restrict GROUPS.
E- WHERE clause cannot be use when there is group function, instead HAVING is to be use.
F- There is no constraint to use HAVING clause in a sub queries.
Refer: Introduction to Oracle9i: SQL, Oracle University Student Guide, Aggregating Data using Group Functions, p. 5-20

- (Topic 1)
View the Exhibit and examine the description of SALES and PROMOTIONS tables.
< ><>>>< >

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: BCD

- (Topic 2)
You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit
<>>

1. A. . SELECT promo_name, promo_begin_dateFROM promotionsWHERE promo_begin_date > \'01-JAN-01\'ORDER BY 1 DESC;
2. B. SELECT promo_name, promo_begin_date "START DATE"FROM promotionsWHERE promo_begin_date > \'01-JAN-01\'ORDER BY "START DATE" DESC;
3. C. . SELECT promo_name, promo_begin_dateFROM promotionsWHERE promo_begin_date > \'01-JAN-01\'ORDER BY 2 DESC;
4. D. . SELECT promo_name, promo_begin_dateFROM promotionsWHERE promo_begin_date > \'01-JAN-01\'ORDER BY promo_name DESC;

Correct Answer: BC

- (Topic 3)
For which action can you use the TO_DATE function?

1. A. Convert any date literal to a date
2. B. Convert any numeric literal to a date
3. C. Convert any character literal to a date
4. D. Convert any date to a character literal
5. E. Format ’10-JAN-99’ to ‘January 10 1999’

Correct Answer: C