Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
Q111: What is the alternate to IF-Then statements in PL/SQL?
- A: LOOP
- B: CASE
- C: WHILE
- D: GOTO
View Answer
B
Q112: The CASE statement in PL/SQL selects how many sequences of statements to execute?
- A: Multiple
- B: None
- C: Only one
- D: All
View Answer
C
Q113: What is raised when ELSE part is not written and no matching case is found?
- A: Warning
- B: Error
- C: Exception
- D: NULL
View Answer
C
Q114: In a CASE statement, what happens when no case is matched?
- A: The first case is executed
- B: The last case is executed
- C: The ELSE part is executed
- D: Program terminates
View Answer
C
Q115: What message is printed when the grade is 'B' in the given PL/SQL block?
- A: Excellent
- B: Very good
- C: Good
- D: You Fail
View Answer
B
Q116: In the second scenario of the CASE statement, what is the output for the user 'DBA'?
- A: Test User
- B: Owner of Schema
- C: Invalid User
- D: Admin User
View Answer
D
Q117: In a Searched CASE Statement, conditions are mentioned in which clause?
- A: THEN
- B: ELSE
- C: CASE
- D: WHEN
View Answer
D
Q118: What action is taken when the salary is between 4000 and 6999 in the searched CASE statement?
- A: No action
- B: Insert row with the status 'Good'
- C: Insert row with the status 'Very Good'
- D: Insert row with the status 'Excellent'
View Answer
B
Q119: What does the searched CASE statement do if the salary is greater than 7000 and less than 10000?
- A: Status: Good
- B: Status: Excellent
- C: Status: Very Good
- D: No such salary
View Answer
C
Q120: What happens in the ELSE part if no case is matched in the searched CASE statement?
- A: An exception is raised
- B: A row is inserted
- C: The program terminates
- D: The program continues without any action
View Answer
B