Oracle.1Z0-051.175q(5)

OCP 11g 051题库

D. The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause.

Answer: CD

QUESTION 8

View the Exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

A. listing of customers who do not have a credit limit and were born before 1980

B. finding the number of customers, in each city, whose marital status is 'married'

C. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

D. listing of those customers whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'

E. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

Answer: DE

QUESTION 9 Which statement is true regarding the INTERSECT operator?

A. It ignores NULL values.

B. Reversing the order of the intersected tables alters the result.

C. The names of columns in all SELECT statements must be identical.

D. The number of columns and data types must be identical for all SELECT statements in the query.

Answer: D

QUESTION 10

View the Exhibit; e xamine the structure of the PROMOTIONS table.

Each promotion has a duration of at least seven days .

Your manager has asked you to generate a report, which provides the weekly cost for each promotion

done to l date.

Which query would achieve the required result?