Oracle
1Z0-007 · Question #18
1Z0-007 Question #18: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
Question
Which four statements correctly describe functions that are available in SQL? (Choose four)
Options
- AINSTR returns the numeric position of a named character.
- BNVL2 returns the first non-null expression in the expression list.
- CTRUNCATE rounds the column, expression, or value to n decimal places.
- DDECODE translates an expression after comparing it to each search value.
- ETRIM trims the heading of trailing characters (or both) from a character string.
- FNVL compares two expressions and returns null if they are equal, or the first expression of they
- GNULLIF compares twp expressions and returns null if they are equal, or the first expression if they
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.