Which statement is true about the execution of these commands?

Examine the commands:
CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20)

/
CREATE TYPE typ_course_nst
AS TABLE OF typ_course_tab
/
CREATE TABLE faculty
(faculty_id NUMBER(5),
faculty_name VARCHAR2(30),
courses typ_course_nst)
NESTED TABLE courses STORE AS course_stor_tab
/
INSERT INTO faculty
VALUES (101, ‘Jones’, NULL);
UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses =
typ_course_nst(11,’Oracle’); Which statement is true about the execution of these commands?

Examine the commands:
CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20)

/
CREATE TYPE typ_course_nst
AS TABLE OF typ_course_tab
/
CREATE TABLE faculty
(faculty_id NUMBER(5),
faculty_name VARCHAR2(30),
courses typ_course_nst)
NESTED TABLE courses STORE AS course_stor_tab
/
INSERT INTO faculty
VALUES (101, ‘Jones’, NULL);
UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses =
typ_course_nst(11,’Oracle’); Which statement is true about the execution of these commands?

A.
All the commands execute successfully.

B.
Only the first two commands execute successfully.

C.
Only the first four commands execute successfully.

D.
Only the first three commands execute successfully.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Vova M.

Vova M.

C
typ_course_nst(11,’Oracle’) – is not correct
arguments should have had type “typ_course_tab”