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?

Question

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?

Accepted Answer

C. Only the first four commands execute successfully.

Answer

A. All the commands execute successfully.

Answer

B. Only the first two commands execute successfully.

Answer

D. Only the first three commands execute successfully.

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…

Question

Options

How the community answered

Community Discussion