- 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 true about data types in PL/SQL?
Answer : D
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 - Which of the following is not true about PL/SQL decision making structures?
B - The IF statement also adds the keyword ELSE followed by an alternative sequence of statement.
C - The IF-THEN-ELSIF statement allows you to choose between several alternatives.
Answer : D
Q 4 - Which of the following is not true about the PL/SQL data structure VARRAY?
A - In oracle environment, the starting index for VARRAYs is always 1.
Answer : D
Q 5 - What would be the output of the following code?
DECLARE a number; b number; c number; FUNCTION fx(x IN number, y IN number) RETURN number IS z number; BEGIN IF x > 2*y THEN z:= x; ELSE z:= 2*y; END IF; RETURN z; END; BEGIN a:= 23; b:= 47; c := fx(a, b); dbms_output.put_line(c); END;
Answer : C
Q 6 - The pre-defined exception CASE_NOT_FOUND is raised when
B - PL/SQL has an internal problem.
C - A cursor fetches value in a variable having incompatible data type.
Answer : A
Q 7 - The pre-defined exception TOO_MANY_ROWS is raised when
A - PL/SQL ran out of memory or memory was corrupted.
B - A cursor fetches value in a variable having incompatible data type.
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 - A transaction starts when
A - The first SQL statement is performed after connecting to the database.
B - At each new SQL statement issued after a transaction is completed.
Answer : D
Q 10 - Which of the following is true about the inheritance for PL/SQL Objects?
A - PL/SQL allows creating object from existing base objects.
B - To implement inheritance, the base objects should be declared as NOT FINAL.
C - The NOT INSTANTIABLE clause allows you to declare an abstract object.
To Continue Learning Please Login
Login with Google