PL SQL Basics - Online Test

Test Difficulty Level: Easy

Syllabus of Test

Benefits of PL/SQL. The PL/SQL Block Structure - Named and Anonymous Blocks. Variable and Constants, Declaring Variables, Assigning Values to Variables, Constants, Scalar Datatypes, LOB Datatypes, Operators, The Executable Section, Executing a Block. Control Structyres - Syntax and Usage. Labels, Labeled Blocks, Labeled Loops, The GOTO Statement, Nested Blocks.

Sample Question from this online test:

Question: Which section of the PL/SQL block handles errors and abnormal conditions ?

Option A: Declaration section

Option B: Exception section

Option C: Executable section

Option D: Anonymous block

To answer, click the "Start This Test" button below.

Start this Test


raj kumar on 2010-12-07 00:55:34 wrote,

Good one. But something is missing in question no. 20

Kevin Yang on 2010-12-21 21:07:40 wrote,

Very good questions except question 20 is missing.

Kevin Yang on 2010-12-23 04:54:32 wrote,

What is the correct answer of question 11, A or B? It seems the explaination is B, but the answer is A.

Srikanthi Kakaraparthi on 2011-01-11 11:31:57 wrote,

Good one. However question 20 is missing.

vinayakaprasad chepuri on 2011-01-12 07:29:55 wrote,

where is 20th question and answer

Sachin Varshney on 2011-01-29 17:46:28 wrote,

Very Good Questions..... I Like IT...

vishwas pande on 2011-02-11 14:46:40 wrote,

Two questions are not proper here( last one and 11th.)

roopa ranjanagi on 2011-03-15 11:07:50 wrote,

good one:)

geetesh mgbvmn on 2011-04-05 04:59:48 wrote,

In the 3rd question..variable x is not declared and it is initialized in executable section which is also an error

karan yahooja on 2011-04-17 11:26:54 wrote,

what type of question no. 20 is? i never seen this type of amazing question in my life so far. I just want to know the answer from the user who has posted it.

Priya Mankar on 2011-05-28 16:06:40 wrote,

What is the mandatory clause in a SELECT statement when used inside a PL/SQL block?

Can't get this questio....
select * from table_name(this query dows not require INTO Clause)

swopna soundar on 2011-06-11 12:27:17 wrote,

good one.except qn 20 what's missing in it

hrishikesh puranik on 2011-06-21 09:08:43 wrote,

exams need Luck...Proved..
refer Q.20

neha utpat on 2011-06-21 09:10:09 wrote,

best 1..but Q-20 is missing

raju ranjan on 2011-06-23 10:29:31 wrote,

huh..m lucky 2 escape saved ass gettin axe'd..
questions were really gud..
god bless GetGyan....!!!!!!!!!!!!!

himanshu singh on 2011-07-22 06:18:01 wrote,


supriya b on 2011-09-30 06:51:13 wrote,

very good..........u ve given explanation for every query:):):)

gaurav batra on 2011-12-25 21:11:34 wrote,

my second test after sql(75%) bt scored low this time 65% OOPs...!

sushil kumar on 2012-03-15 07:06:18 wrote,

what is the meaning of question no 20 ?

Reddi Prasad on 2012-04-09 09:00:24 wrote,

i am not understanding the Q20?
what is the meaning of the he?

ratnesh shingrupe on 2012-08-07 06:54:14 wrote,

11th ques , ans is wrong here..... explanation is for NOT NULL which is right but correct answer given is CHECK Constrain which is wrong....

divija ks on 2012-08-07 13:30:35 wrote,

very good........

bahvna kotak on 2012-08-10 06:59:05 wrote,

very good but question 20 is missing

vijay murali on 2012-08-27 09:25:16 wrote,

good one :-)

vijay murali on 2012-08-27 12:15:55 wrote,

super :-) Those questions helps me to know where i was in sql...

gauthu neealpu on 2012-09-13 07:02:08 wrote,

Nice attempt but once check the solutions and choices u mentioned

jacqulin franklin on 2012-11-01 09:16:36 wrote,


zil bn on 2012-11-15 10:35:31 wrote,

CLever !! The trainer has made sure no one gets 20 corrects with the 20th qns.

lakshmi pavani tatikonda on 2012-11-23 06:05:36 wrote,

something is missing in question no.20

swetha puvvadi on 2013-02-27 05:58:20 wrote,


velmurugan p on 2013-04-02 14:54:44 wrote,

Good questions. but 20 th one is incomplete.

s n on 2013-04-04 10:20:15 wrote,

very good questions..

vijaya prasad on 2013-04-07 13:26:33 wrote,


Akki Julakanti on 2013-09-18 11:07:02 wrote,

Good one. Thankyou

SATYANARAYANA RAJU GANDRAJU on 2014-08-02 07:37:18 wrote,

Good.Nice practice