PL/SQL is a procedural language extension to Structured Query Language. You can take this Oracle PL/SQL quiz questions and answers and check your knowledge. The purpose of PL/SQL is to combine database language and procedural programming language. The quiz below has been designed to help you refresh your memory on Oracle PL/SQL. Give it a shot and see your results. Don't forget to share the result with your friends and see who got the better results. All the best!
CHAR
VARCHAR1
VARCHAR2
INTEGER
NUMBER
INITIALIZE, GET, CLOSE
CURSOR, GET, FETCH, CLOSE
OPEN, FETCH, CLOSE
CURSOR, FETCH, CLOSE
GET, SEEK, HIDE
Variables
IN OUT Parameters
Name
Signature
None of the above
Package specification is invalid. Too many procedures named foo.
Package specification is invalid. First procedure should be called foo_1, second procedure should be called foo_2.
Package specification is valid. We can have an unlimited number of procedures name foo.
Package specification is valid. This is an example of overloading.
Package specification is invalid. We can only have one procedure named foo in the package.
%ID
%ROWTYPE
%COLUMNTYPE
%TYPE
None of the above.
%TABLE
%ROWTYPE
%COLUMNTYPE
%TYPE
None of the above
Explicit
Implicit
Select
PL/SQL
None of the above
Explicit
Implicit
Select
PL/SQL
None of the above
ELSE
ELSE IF
ELIF
ELSIF
None of the above
This SQL will list all employees in the Finance department earning more than 20000.
This SQL will list all employees who are in the Finance or Sales department earning more than 20000.
This SQL will list all employees who are Analysts in the Finance or Sales department earning more than 20000.
This SQL will return a cartesian product.
None of the above.
In the PL/SQL working storage section.
In the PL/SQL declaration section.
In the PL/SQL body section.
In the PL/SQL exception section.
None of the above.
The commit is fired 1000 times.
The commit is fired 100 times.
The commit is fired 10 times.
The commit is fired 1 time.
None of the above.
09/09/2009 09:09:09
09/09/2009 09:09:09AM
09/09/2009
09/09/2009 00:00:00
None of the above
Incarnation
Integration
Continuation
Concatenation
None of the above
DECODE
TRUNCATE
TO_CHAR
NVL
Trick question, all of these are Oracle DML functions.
WHILE LOOP ... END LOOP;
FOR rec IN some_cursor LOOP ... END LOOP;
LOOP ... UNTIL ; END LOOP;
LOOP ... EXIT WHEN ; END LOOP;
None of the above. All are valid.
%NOTFOUND
%FOUND
%ROWCOUNT
%ISOPEN
None of the above. All of these are valid.
COUNT
SUM
DISTINCT
MIN
All of the above.
Wait!
Here's an interesting quiz for you.