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.
Related Online Tests:
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,
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?
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..
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 yesterday..it saved ass gettin axe'd..
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?
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,
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,