Question 1

Which statement is true regarding the default behavior of the ORDER BY clause?

Options :

A : In a character sort, the values are case-sensitive.

B : NULLs are not included in the sort operation.

C : Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

D : Numeric values are displayed in descending order if they have decimal positions.

Answer: A

Question 2

Examine the description of the CUSTOMERS table:

Which two SELECT statements will return these results:

CUSTOMER_ NAME

--------------------

Mandy

Mary

Options :

A : SELECT customer_ name FROM customers WHERE customer_ name LIKE ' % a % ’ ;

B : SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma%' ;

C : SELECT customer_ name FROM customers WHERE customer_ name='*Ma*';

D : SELECT customer_ name FROM customers WHERE UPPER (customer_ name ) LIKE 'MA*. ;

E : SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma*';

F : SELECT customer_ name FROM customers WHERE UPPER (customer name) LIKE 'MA&';

G : SELECT customer_ name FROM customers WHERE customer_ name KIKE .*Ma*';

Answer: B,D

Question 3

Examine the structure of the MEMBERS table:

Examine the SQL statement: SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution? (Choose the best answer.)

Options :

A : It displays all cities in descending order, within which the last names are further sorted in descending order.

B : It fails because a column alias cannot be used in the ORDER BY clause.

C : It fails because a column number and a column alias cannot be used together in the ORDER BY clause.

D : It displays all cities in ascending order, within which the last names are further sorted in descending order.

Answer: D

Question 4

Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which two queries return all the rows from COLORS?

Options :

A : SELECT.

FROM bricks b

RIGHT JOIN colors c

ON b. color _rgb_ hex_ value = c. rgb hex_ value;

B : SELECT

EROM colors C

LEFT JOIN bricks #

USING (rgb _ hex_ value) ;

C : SELECT

FROM bricks b

FULL JOIN colors C

ON b. color rgb _ hex_ value = c. rgb _hex_ value;

D : SELECT *

EROM bricks | b

JOIN colors C

ON b. color_ rgb_ hex_ value =c. rgb _hex value;

E : SELECT

EROM colors C

LEET JOIN bricks b

ON b. color_ rgb_ hex value = c. rgb. hex.

value

WHERE b. brick_ id > 0;

Answer: A,B

Question 5

Examine the description of the PRODUCT_DETAILS table:

Which two statements are true?

Options :

A :

PRODUCT_ID can be assigned the PEIMARY KEY constraint.

B :

EXPIRY_DATE cannot be used in arithmetic expressions.

C :

EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it

D :

PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it

E : PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

F :

PRODUCT_NAME cannot contain duplicate values.

Answer: A,D

Higher Test Marks with Free Online 1Z0-071 Exam Practice

Buying Options: