AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 2745

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 =
 

Option A

Option B

Option C

Option D

Correct Answer C
Explanation


Question ID 2746

Option A

 
A.    It is created successfully, but displays the correct output message only for existent employee IDs.
 

Option B

B.    It is created successfully and displays the correct output message for both existent and nonexistent employee IDs.
 

Option C

C.    It generates an error because the %NOTFOUND attribute cannot be used in combination with a SELECT INTO statement.
 

Option D

D.    It generates an error because a user-defined exception has to be included whenever the %NOTFOUND attribute is used in combination with a SELECT INTO statement.
 

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!