Online 1Z0-071 Practice Test

Question 1

Which two are SQL features?

Options :

A : providing graphical capabilities

B : providing variable definition capabilities.

C : providing database transaction control

D : processing sets of data

E : providing update capabilities for data in external files

Answer: C,D

Question 2

Examine this statement:

SELECT cust_id, cust^last_ndma "Last Name"

FROM customers

WHERE country_id — 10 UNION

SELECT cust_ID_CUST_NO, cust_last_name

PROM customers

WHERE country__id = 30

Identify three order by clauses, any one of which will complete the query successfully

Options :

A : ORDER BY 2. cust _id

B : ORDER BY 2,

C : ORDER BY "CUST^NO

D : ORDER BY 'Last Name

E : ORDER BY CUST_NO

Answer: A,B,D

Question 3

Which two statements execute successfully?

Options :

A :

SELECT TO_ DATE('2019-DEC-25 15:30' 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE

=AMERICAN' ) FROM DUAL;

B :

SELECT TO_CHAR('2019-DEC-25 15:30' YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE =

AMERICAN')

FROM DUAL;

C :

SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI'))

FROM DUAL;

D :

SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI'))

FROM DUAL

E :

SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI')

FROM DUAL

Answer: A,D

Question 4

Evaluate the following two queries:

Which statement is true regarding the above two queries?

Options :

A : Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.

B : There would be no change in performance.

C : Performance would degrade in query 2.

D : Performance would improve in query 2.

Answer: B

Question 5

Which three statements are true regarding the data types? (Choose three.)

Options :

A : The minimum column width that can be specified for a varchar2 data type column is one

B : Only one LONG column can be used per table.

C : A TIMESTAMP data type column stores only time values with fractional seconds.

D : The BLOB data type column is used to store binary data in an operating system file.

E : The value for a CHAR data type column is blank-padded to the maximum defined column width.

Answer: A,B,E

EXPERTY DESIGNED 1Z0-071 PRACTICE TEST