Given the following example of an object type in Oracle:
CREATE TYPE carType AS OBJECT (
regNo $\quad$VARCHAR2 (8),
make $\quad$VARCHAR2 (20),
model $\quad$VARCHAR2 (20));
CREATE TABLE vehicles OF carType;
State the two ways:
(a) in which the 'vehicles' table can be viewed;
(b) to insert a record in the 'vehicles' table;
(c) to retrieve records of all Ford cars from the 'vehicles' table.

Question

Given the following example of an object type in Oracle:
CREATE TYPE carType AS OBJECT (
 regNo $\quad$VARCHAR2 (8),
 make $\quad$VARCHAR2 (20),
 model $\quad$VARCHAR2 (20));
CREATE TABLE vehicles OF carType;
State the two ways:
(a) in which the 'vehicles' table can be viewed;
(b) to insert a record in the 'vehicles' table;
(c) to retrieve records of all Ford cars from the 'vehicles' table.

Quizplus · Accepted Answer

The Answer of Given the following example of an object type in Oracle:
CREATE TYPE carType AS OBJECT (
 regNo $\quad$VARCHAR2 (8),
 make $\quad$VARCHAR2 (20),
 model $\quad$VARCHAR2 (20));
CREATE TABLE vehicles OF carType;
State the two ways:
(a) in which the 'vehicles' table can be viewed;
(b) to insert a record in the 'vehicles' table;
(c) to retrieve records of all Ford cars from the 'vehicles' table.

Given the Following Example of an Object Type in Oracle \quad

Given the Following Example of an Object Type in Oracle $\quad$