PL/SQL MCQs Quiz
Authored by DR MURTHY
Computers
12th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
PL/SQL is a procedural extension of which database language?
SQL Server
PostgreSQL
SQL
MySQL
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which section is mandatory in a PL/SQL block?
DECLARE
BEGIN
EXCEPTION
END
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a valid PL/SQL block structure?
DECLARE -> BEGIN -> EXCEPTION -> END
BEGIN -> DECLARE -> EXCEPTION -> END
DECLARE -> EXCEPTION -> BEGIN -> END
BEGIN -> END
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which operator is used for string concatenation in PL/SQL?
+
||
&
#
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which keyword is used to define a variable with the same data type as a table column?
%ROWTYPE
%TYPE
%COLUMN
%DATATYPE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is true about IF...THEN...ELSE in PL/SQL?
IF must always be followed by ELSE
ELSE is mandatory
Multiple ELSIF can be used
It cannot be nested
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will be the output if NULLIF(5, 5) is executed?
5
0
NULL
Error
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
