Oracle 1Z0-071 Quiz 33 Topic 5 Questions 161-165

Question: 1

A non-correlated subquery can be defined as __________. (Choose the best answer.)

AA set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query.

BA set of sequential queries, all of which must return values from the same table.

CA set of sequential queries, all of which must always return a single value.

DA SELECT statement that can be embedded in a clause of another SELECT statement only.

Show Answer

Question: 2

Which three statements are true reading subqueries? (Choose three.)

AA Main query can have many subqueries.

BA subquery can have more than one main query.

CThe subquery and main query must retrieve date from the same table.

DThe subquery and main query can retrieve data from different tables.

EOnly one column or expression can be compared between the subquery and main query.

FMultiple columns or expressions can be compared between the subquery and main query.

Show Answer

Question: 3

See the Exhibit and examine the structure of the PROMOTIONS table:

q3_1Z0-071

Using the PROMOTIONS table,

you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in

category A.

You issue the following SQL statements:

q3_1Z0-071

What would be the outcome?

AIt generates an error because multiple conditions cannot be specified for the WHEN clause.

BIt executes successfully and gives the required result.

CIt generates an error because CASE cannot be used with group functions.

DIt generates an error because NULL cannot be specified as a return value.

Show Answer

Question: 4

Which two statements are true regarding multiple-row subqueries? (Choose two.)

AThey can contain group functions.

BThey always contain a subquery within a subquery.

CThey use the < ALL operator to imply less than the maximum.

DThey can be used to retrieve multiple rows from a single table only.

EThey should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.

Show Answer

Question: 5

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

q5_1Z0-071

The CUSTOMERS table contains the current location of all currently active customers.

The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.

You need to find those customers who have never changed their address.

Which SET operator would you use to get the required output?

AINTERSECT

BUNION ALL

CMINUS

DUNION

Show Answer

Oracle 1Z0-071 Quiz:33 Topic:5 Questions:161-165