- PL/SQL Tutorial
- PL/SQL - Home
- PL/SQL - Overview
- PL/SQL - Environment
- PL/SQL - Basic Syntax
- PL/SQL - Data Types
- PL/SQL - Variables
- PL/SQL - Constants and Literals
- PL/SQL - Operators
- PL/SQL - Conditions
- PL/SQL - Loops
- PL/SQL - Strings
- PL/SQL - Arrays
- PL/SQL - Procedures
- PL/SQL - Functions
- PL/SQL - Cursors
- PL/SQL - Records
- PL/SQL - Exceptions
- PL/SQL - Triggers
- PL/SQL - Packages
- PL/SQL - Collections
- PL/SQL - Transactions
- PL/SQL - Date & Time
- PL/SQL - DBMS Output
- PL/SQL - Object Oriented
- PL/SQL Useful Resources
- PL/SQL - Questions and Answers
- PL/SQL - Quick Guide
- PL/SQL - Useful Resources
- PL/SQL - Discussion
PL/SQL Online Quiz
Following quiz provides Multiple Choice Questions (MCQs) related to PL/SQL. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - Which of the following is not true about the execution section of a PL/SQL block?
A - It should have more than one executable line of code.
B - It may have just a NULL command to indicate that nothing should be executed.
Answer : A
Q 2 - Which of the following is not true about large object data types and in PL/SQL?
A - BFILE is used to store large binary objects in operating system files outside the database.
B - BLOB is used to store character data in the database.
C - CLOB is used to store large blocks of character data in the database.
D - NCLOB is used to store large blocks of NCHAR data in the database.
Answer : B
Q 3 - What will be the output of the following code snippet?
DECLARE a number(3) := 100; b number(3) := 200; BEGIN IF( a = 100 ) THEN IF( b <> 200 ) THEN dbms_output.put_line(b); END IF; END IF; dbms_output.put_line(a); END;
Answer : D
Q 4 - Which of the following is true about the PL/SQL data structure VARRAY?
A - It also has a maximum size that cannot be changed.
B - A VARRAY type is created with the CREATE VARRAY statement, at the schema level.
C - Maximum size of a VARRAY can be changed using the ALTER TYPE statement.
D - Maximum size of a VARRAY can be changed using the ALTER VARRAY statement.
Answer : C
Q 5 - Which of the following is a way of passing parameters to PL/SQL subprograms?
Answer : D
Q 6 - Which of the following code will open a cursor named cur_employee?
Answer : A
Q 7 - Which of the following is not a benefit of a database trigger?
A - Enforcing referential integrity
B - Event logging and storing information on table access
Answer : C
Q 8 - Which of the following is not true about PL/SQL collections?
A - A collection is an ordered group of elements having the same data type.
B - A collection is an ordered group of elements having different data type.
C - Each element is identified by a unique subscript that represents its position in the collection.
D - Nested tables and Varrays are types of PL/SQL collections.
Answer : A
Q 9 - The collection method LIMIT
A - Returns the last (largest) index numbers in a collection that uses integer subscripts.
B - Returns the number of elements that a collection currently contains.
Answer : C
Q 10 - Which of the following is not true about the comparison methods?
A - These are used for comparing objects.
C - The Order methods implement some internal logic for comparing two objects.
Answer : B
Explanation
The Map method is a function implemented in such a way that its value depends upon the value of the attributes.
To Continue Learning Please Login
Login with Google