Question 1

Which statement is true about aggregate functions?

Options :

A : Aggregate functions can be nested to any number of levels

B : The AVG function implicitly converts NULLS to zero

C : Aggregate functions can be used in any clause of a SELECT statement

D : The MAX and MIN functions can be used on columns with character data types

Answer: D

Question 2

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Other-Image-3de95013a-a7fc-4279-9a4b-7740f766c151

Which three statements are true?

Options :

A : The statement will fall if a row already exists in the sales table for product 23.

B : The sales table has five foreign keys.

C : A product can have a different unit price at different times.

D : A customer can exist in many countries.

E : The statement will execute successfully and a new row will be inserted into the sales table.

F : The statement will fail because a subquery may not be contained in a values clause.

Answer: A,B,C

Question 3

Examine this SQL statement:

SELECT cust_id, cust_last_name ''Last Name''

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

Options :

A : ORDER BY ''Last Name''

B : ORDER BY 2, 1

C : ORDER BY 2, cust_id

D : ORDER BY CUST_NO

E : ORDER BY ''CUST_NO''

Answer: B,C,D

Question 4

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.

Examine this SQL statement:

Other-Image-40a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 1.

Other-Image-60a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 2.

Other-Image-80a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

What will be the result?

Options :

A : It gives an error because the ALL keyword is not valid

B : It gives an error because the GROUP BY clause is not valid

C : It executes successfully but does not give the required result

D : It executes successfully and gives the required result

Answer: D

Question 5

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

Options :

A : Duplicates are eliminated automatically by the UNION ALL operator

B : The number of columns selected in each SELECT statement must be identical

C : The names of columns selected in each SELECT statement must be identical

D : The output is sorted by the UNION ALL operator

E : NULLS are not ignored during duplicate checking

Answer: A,B

Free 1Z0-082 Mock Exam – Practice Online Confidently

Buying Options: