1z0-071 Practice Test

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

What would be the outcome?

A.

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

B.

It executes successfully and gives the required result.

C.

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

D.

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

View the exhibit and examine the structure and data in the invoice table. (Choose two.)

Which two SQL statements would execute successfully?

A.

SELECT MAX(AVG(SYSDATE -inv_date)) FROM invoice

B.

SELECT AVG(inv_date) FROM invoice

C.

SELECT MAX(inv_date), MIN(cust_id) FROM invoice

D.

SELECT AVG( inv_date -SYSDATE), AVG(inv_amt) FROM invoice

Examine the types and examples of relationship that follows: (Choose the best answer.)
1 One-to-one a) teacher to Student
2 One-to-many b) Employees to Manager
3 Many-to-one c) Person to SSN
4 Many-to-many d) Customers to Products
Which option indicates correctly matched relationships?

 

A.

1-d, 2-b, 3-a, and 4-c

B.

1-c, 2-d, 3-a, and 4-b

C.

1-a, 2-b, 3-c, and 4-d

D.

1-c, 2-a, 3-b, and 4-d

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.)

Which two statements are true regarding data type conversion in query expressions?

A.

inv_date = '15-february-2008' :uses implicit conversion

B.

inv_amt = '0255982' : requires explicit conversion

C.

inv_date > '01-02-2008' : uses implicit conversion

D.

CONCAT(inv_amt, inv_date) : requires explicit conversion

E.

inv_no BETWEEN '101' AND '110' : uses implicit conversion

Evaluate the following query:

Which is the correct output of the above query?

A.

+00-300, +54-02,+00 11:12:10.123457

B.

+00-300,+00-650,+00 11:12:10.123457

C.

+25-00, +54-02, +00 11:12:10.123457

D.

+25-00,+00-650,+00 11:12:10.123457