Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
Q221: What is a collection in programming?
- A: A list of integers
- B: A type of loop
- C: A group of elements of the same type
- D: A method to handle exceptions
View Answer
C
Q222: What does the `BINARY_INTEGER` index type in PL/SQL tables allow?
- A: Indexes to be sequential only
- B: Indexes to be sparse or dense
- C: Indexes to be limited to strings
- D: Indexes to be numeric only
View Answer
B
Q223: In a PL/SQL table, which attribute returns the number of elements in the table?
- A: EXISTS
- B: COUNT
- C: FIRST
- D: LAST
View Answer
B
Q224: Which PL/SQL table attribute returns the index of the element that follows a given index?
- A: PRIOR
- B: NEXT
- C: FIRST
- D: LAST
View Answer
B
Q225: What is the purpose of the `EXISTS` attribute in PL/SQL tables?
- A: It checks if an element at a given index exists
- B: It counts the total number of elements
- C: It returns the first index
- D: It deletes elements at a given index
View Answer
A
Q226: What will the `DELETE(n)` attribute do in a PL/SQL table?
- A: Delete all elements in the table
- B: Delete the nth element only
- C: Delete all elements in the range m..n
- D: Delete no elements if n is null
View Answer
B
Q227: What is the syntax to declare a PL/SQL table of a specific datatype with an index by `BINARY_INTEGER`?
- A: TYPE table_type_name IS TABLE OF datatype [NOT NULL] INDEX BY INTEGER;
- B: TYPE table_type_name IS TABLE OF datatype [NOT NULL] INDEX BY BINARY_INTEGER;
- C: TYPE table_type_name IS TABLE OF datatype INDEX BY INTEGER;
- D: TYPE table_type_name IS TABLE OF datatype INDEX BY BINARY_INTEGER;
View Answer
B
Q228: In the `Implementing PL/SQL Table -I` example, what happens if `counter` exceeds 10?
- A: The loop continues indefinitely
- B: The loop exits and the program terminates
- C: The loop stops executing and no further output is displayed
- D: The program displays the message "Prog" continuously until stopped
View Answer
B
Q229: What does the `NEXT(n)` attribute return in PL/SQL tables?
- A: The index number that succeeds index n
- B: The index number that precedes index n
- C: The smallest index number
- D: The largest index number
View Answer
A
Q230: What will be the output of the `Implementing PL/SQL Table -III` example if `c3.exists(b)` returns TRUE?
- A: The value at index b is displayed
- B: The index b is deleted from the table
- C: The value at index b is inserted into another table
- D: The index b is not found in the table
View Answer
A