Test Difficulty Level: Easy

Syllabus of Test

PL/SQL Records - Creating Records, Using Records. PL/SQL Collections - Types of Collections, Using Collections.

Sample Question from this online test:

Question: Which line in the following PL/SQL block will raise an exception ? Choose one.

1 declare
2 type company_rec is record
3 (id number not null
4 ,company_name company.comp_name%type
5 ,sic_code varchar2(5)
6 ,begin date
7 ,contact_phone varchar2(14)
8 );
9 comp_rec company_rec;

Option A: Line 2

Option B: Line 4

Option C: Line 6

Option D: Line 9

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

Start this Test