Question:
Which of the following is NOT a valid PL/SQL control statement?
Which of the following is NOT a valid PL/SQL control statement?
Show Hint
While many programming languages use aswitch` statement for multi-way branching, remember that PL/SQL (and standard SQL) uses theCASE` statement for this purpose.
Updated On: Jul 2, 2026
- IF-THEN-ELSE
- CASE
- LOOP
- SWITCH
Show Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
PL/SQL (Procedural Language/SQL) is Oracle's procedural extension for SQL. It includes standard procedural language constructs for control flow.
Valid PL/SQL control statements include:
Conditional Control: (A)IF-THEN-ELSE`,IF-THEN-ELSIF` statements. (B)CASE` statements andCASE` expressions. Iterative Control (Loops): (C) BasicLOOP`,FOR LOOP`, andWHILE LOOP`. Sequential Control: GOTO` statement.
TheSWITCH` statement is a common control structure in languages like C, C++, Java, and C#. However, it is not a valid control statement in PL/SQL. The equivalent functionality in PL/SQL is provided by theCASE` statement.
Therefore, SWITCH is not a valid PL/SQL control statement.
Valid PL/SQL control statements include:
Conditional Control: (A)IF-THEN-ELSE`,IF-THEN-ELSIF` statements. (B)CASE` statements andCASE` expressions. Iterative Control (Loops): (C) BasicLOOP`,FOR LOOP`, andWHILE LOOP`. Sequential Control: GOTO` statement.
TheSWITCH` statement is a common control structure in languages like C, C++, Java, and C#. However, it is not a valid control statement in PL/SQL. The equivalent functionality in PL/SQL is provided by theCASE` statement.
Therefore, SWITCH is not a valid PL/SQL control statement.
Was this answer helpful?
0
0
Top AP ECET CSE Computer Science and IT Engineering Questions
- Which of the following is a universal gate?
- Which of the following is NOT a combinational circuit?
- A demultiplexer is a device that
- Convert the binary number 110011 into its decimal equivalent.
- The number of select lines required for an 8-to-1 multiplexer is?
View More Questions
Top AP ECET CSE Database Management Systems Questions
- Which of the following ensures referential integrity in a relational database?
- Which normal form removes transitive dependencies?
- What type of database model uses tables with rows and columns?
- What is the purpose of the HAVING clause in SQL?
- Which of the following SQL statements contains an error?
View More Questions
Top AP ECET CSE Questions
- If the matrix A = \(\begin{bmatrix} 1 & 2 & 3 \\ 4 & 5 & 6 \\ 7 & 8 & 9 \end{bmatrix}\), then which of the following is true?
- If A = \(\begin{bmatrix} a & b \\ c & d \end{bmatrix}\) and the determinant of A is 5, then determinant of the matrix 2A is
- If the matrix A is of order 3x3 and the system of equations AX = B has a unique solution, what can be concluded about the determinant of A?
- If A = \(\begin{bmatrix} x & 3 \\ 2 & 4 \end{bmatrix}\) and A\(^{-1}\) = \(\begin{bmatrix} -2 & 1.5 \\ 1 & -0.5 \end{bmatrix}\), then the value of x is
- If A = \(\begin{bmatrix} 1 & 2 \\ 3 & 4 \end{bmatrix}\) and B = \(\begin{bmatrix} 1 & 0 \\ 1 & 0 \end{bmatrix}\), then \((AB)^T =\)
View More Questions