Data Manipulation   «Prev  Next»

Oracle Character functions - Quiz

Each question is worth one point. Select the best answer for each question.
 
1. Which function can best help you find a word hidden inside a 2000 character text field?
Please select the best answer.
  A. RTRIM
  B. INSTR
  C. SUBSTR
  D. LENGTH

2. What are the results of the following nested set of functions? (Hint: indenting is not important, but is added for readability.) SUBSTR('I am Jack Horner.',1, INSTR('I am Jack Horner.','J')-1) || SUBSTR('He is Joe Sprat.', INSTR('He is Joe Sprat.','S'))
Please select the best answer.
  A. 'I am Jack Sprat.'
  B. 'I am Joe Sprat.'
  C. 'I am Sprat.'
  D. 'I am JSprat.'

3. Which line of the following query has a syntax error? 
1 SELECT RPAD(UPPER(FIRSTNAME||' '||LASTNAME),25,'-+'), 
2 LOWER(CITY,INSTR(STATE,'H')), 3 LPAD(INITCAP(STATE),LENGTH(CITY)) 
4 FROM CUSTOMER 5 WHERE SOUNDEX(LASTNAME) = SOUNDEX('Jonston')

Please select the best answer.
  A. 1
  B. 2
  C. 3
  D. 5

Correct answers:

Your Score: 0

SEMrush Software