
PL/SQL MCQs Quiz
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Medium
DR MURTHY
Used 4+ times
FREE Resource
Enhance your content in a minute
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
25 questions
TIK01
Quiz
•
12th Grade
29 questions
Computer Parts
Quiz
•
9th - 12th Grade
25 questions
Python
Quiz
•
9th - 12th Grade
26 questions
Macromedia Flash
Quiz
•
8th Grade - Professio...
25 questions
Understanding Strings and Functions Quiz
Quiz
•
8th Grade - University
25 questions
Code.org Quiz1
Quiz
•
7th Grade - University
25 questions
KIEM TRA TX-K11 (BO SUNG)
Quiz
•
11th Grade - University
25 questions
Robotics Mid-term Assessment Grade VII
Quiz
•
6th Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
