Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
Q151: How many times will the inner loop execute in the provided nested loop example?
- A: 4 times
- B: 2 times
- C: 10 times
- D: 1 time
View Answer
A
Q152: What will be the output of the following code segment? 'DBMS_OUTPUT.PUT_LINE('Inner Loop counter is ' || v_innerloopcounter);'
- A: Inner Loop counter is 1 to 4
- B: Inner Loop counter is 1 to 10
- C: Inner Loop counter is 1 to 2
- D: No output
View Answer
A
Q153: The 'CONTINUE WHEN' statement is used to:
- A: Skip the rest of the current iteration and continue with the next iteration
- B: Exit the loop immediately
- C: Wait for a condition to be met
- D: Restart the loop
View Answer
B
Q154: In a nested loop, which loop executes first?
- A: The inner loop
- B: The outer loop
- C: Neither loop
- D: Both loops simultaneously
View Answer
A
Q155: How does a 'WHILE' loop differ from a 'FOR' loop in terms of execution?
- A: A 'WHILE' loop runs until a condition is false; a 'FOR' loop runs a set number of times
- B: A 'WHILE' loop always executes first; a 'FOR' loop executes after initialization
- C: A 'FOR' loop runs indefinitely; a 'WHILE' loop runs a set number of times
- D: A 'WHILE' loop is faster; a 'FOR' loop is slower
View Answer
A
Q156: Fill in the blank: The 'CONTINUE' statement causes the loop to ________ and continue with the next iteration.
- A: skip remaining code in the current iteration
- B: exit immediately
- C: wait for a condition to be met
- D: restart the loop
View Answer
A
Q157: Fill in the blank: In a nested loop, if the outer loop has 2 iterations and the inner loop has 4 iterations, the inner loop will execute a total of ________ times.
- A: 8 times
- B: 2 times
- C: 4 times
- D: 6 times
View Answer
A
Q158: What is the role of 'EXIT WHEN' in the provided loop example?
- A: To terminate the loop when a specified condition is met
- B: To continue to the next iteration
- C: To restart the loop from the beginning
- D: To skip the current iteration
View Answer
A
Q159: What does a cursor in Oracle do?
- A: Handles single rows
- B: Manages multiple rows
- C: Executes SQL statements
- D: Defines table structures
View Answer
B
Q160: Which type of cursor is created automatically by Oracle?
- A: Explicit
- B: Implicit
- C: Dynamic
- D: Static
View Answer
B