Loading questions...
Updated
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?