Multiple choice

A group of related data items stored in fields, each with its own name and datatype, is called

  1. varray

  2. nested table

  3. record

  4. index-by tables

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A PL/SQL record is a group of related data items. For example, the data about a student like roll no., name, date of birth are logically related to each other but have different types. A record containing a field for each item lets the user treat the data as a logical unit. Thus, making it easier to organise and represent. The syntax for creating a record is

type type_name is record (fielddeclaration1,fielddeclaration2...);