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
Related Online Tests:
Comments
 | raj kumar on 2010-12-06 18:55:34 wrote, Good one. But something is missing in question no. 20 |
| Kevin Yang on 2010-12-21 15:07:40 wrote, Very good questions except question 20 is missing. |
| Kevin Yang on 2010-12-22 22: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 05:31:57 wrote, Good one. However question 20 is missing. |
| vinayakaprasad chepuri on 2011-01-12 01:29:55 wrote, where is 20th question and answer |
| Sachin Varshney on 2011-01-29 11:46:28 wrote, Very Good Questions..... I Like IT... |
| vishwas pande on 2011-02-11 08:46:40 wrote, Two questions are not proper here( last one and 11th.) |
| roopa ranjanagi on 2011-03-15 06:07:50 wrote, good one:) |
| geetesh mgbvmn on 2011-04-04 23: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 06: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 11: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 07:27:17 wrote, good one.except qn 20 what's missing in it |
| hrishikesh puranik on 2011-06-21 04:08:43 wrote, exams need Luck...Proved.. |
| neha utpat on 2011-06-21 04:10:09 wrote, best 1..but Q-20 is missing |
| raju ranjan on 2011-06-23 05:29:31 wrote, huh..m lucky 2 escape yesterday..it saved ass gettin axe'd.. |
| himanshu singh on 2011-07-22 01:18:01 wrote, good |
| supriya b on 2011-09-30 01:51:13 wrote, very good..........u ve given explanation for every query:):):) |
| gaurav batra on 2011-12-25 15:11:34 wrote, my second test after sql(75%) bt scored low this time 65% OOPs...! |
| sushil kumar on 2012-03-15 02:06:18 wrote, what is the meaning of question no 20 ? |
| Reddi Prasad on 2012-04-09 04:00:24 wrote, i am not understanding the Q20? |