PrepAway - Latest Free Exam Questions & Answers

What will the TRIM parameter of this function do?

Consider the following function:
HASH_LOOKUP(FIRST_NAME, TRIM=( ,\u),NAME_LOOKUP(SEQ,FIRST))

What will the TRIM parameter of this function do?

PrepAway - Latest Free Exam Questions & Answers

A.
Trims spaces from the destination value after it is hashed from the source value.

B.
Trims spaces and commas from the destination value as well as convert the destination value to upper case before it is hashed.

C.
Generates a syntax error as single quote marks are missing from the TRIM parameter.

D.
Trims spaces and commas from the source value as well as convert the source value to upper case before it is hashed.


Leave a Reply