Oracle
1Z0-047 · Question #166
1Z0-047 Question #166: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #166. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alpha:]]') = 1; Which statement is true regarding the output of this SOL statement?
Exhibit
Options
- AIt would display all the street addresses that do not have a substring 'alpha'.
- BIt would display all the street addresses where the first character is a special character.
- CIt would display all the street addresses where the first character is a letter of the alphabet.
- DIt would display all the street addresses where the first character is not a letter of the alphabet.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.