Oracle Sql Review Questions Version 2 Ch 5 Using Single-Row Functions To Customize Output Ch 6 Using Conversion Functions And Conditional Expressions. | From Question To Perfection| Study With Confidence!

ORACLE SQL REVIEW QUESTIONS VERSION 2 CH 5 USING
SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT CH 6
USING CONVERSION FUNCTIONS AND CONDITIONAL
EXPRESSIONS. | FROM QUESTION TO PERFECTION| STUDY
WITH CONFIDENCE!

Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours
Total Marks: 70%


Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.




Turn Over.




APPHIA – Crafted with Care and Precision for Academic Excellence.
1

,scalar functions return what?
2 Answer: one answer for each row processed
5.1 Use Various Types of Functions That Are Available in SQL
where can a function be called?
3 Answer: any place an expression can be
what does the single quote character do?
5 Answer: its an escape character. it activates or enables, a single quote character to be
displayed as a single quote
This does not work: SELECT 'O'Hearn' FROM DUAL. But this does: SELECT 'O''Hearn'
FROM DUAL.
what do these evaluate to?
INITCAP('RED O''BRIEN')
INITCAP('RED O'BRIEN')
INITCAP('McDonald''s')
6 Answer: Red O'Brien
Error
Mcdonald'S
CONCAT
what are the two syntaxes
which/how to do with multiple
7 Answer: CONCAT('Hello, ', 'world!')
'Hello, ', || 'world!'
repeat || cant do with the word Concat
walk me through LPAD/RPAD
8 Answer: takes three parameters
(character string, n, (opt) character string (defaults to single blank space)
results is a string "n" characters in lentgh
LTRIM and RTRIM
talk about it?


APPHIA – Crafted with Care and Precision for Academic Excellence.
2

, syntax:
process:
9 Answer: (character string, character string(opt, ommitted defaults to single blank space))
removes occurrences of the second parameter from the first
TRIM
syntax: Answer: (trim_info trim_char FROM trim_source)
-trim_info is one of these keywords: LEADING, TRAILING, BOTH—if omitted, defaults to
BOTH.
-trim_char is a single character to be trimmed—if omitted, assumed to be a blank.
-trim_source is the source string—if omitted, the TRIM function will return a NULL.
INSTR
syntax:
process:
11 Answer: (source string,
substring,
starting position (opt, defaults to 1) if position is negative it starts at the end and works
backwards)
n (which occurrence to look for? default 1.
returns the "layman's index" of the starting position of the substring in the source string
SUBSTR
syntax:
process:
12 Answer: (character string, position, Len(opt, runs to end if omitted)
extracts a substring starting at position and running Len or till end. if posistion is negative Len
runs backwards
if position is 7, it starts and returns 7 till the end
SOUNDEX
syntax:
process:
13 Answer: SOUNDEX(s)



APPHIA – Crafted with Care and Precision for Academic Excellence.
3