Which two statements correctly describe the features of SecureFiles? (Choose two.)
View the Exhibit to examine the PL/SQL code for the GET_METADATA function. Which statement is true about the metadata gathered by the function?
Which two statements are true about associative arrays and varrays? (Choose two.)
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 structure of the EMPLOYEES table in the SCOTT schema. Name Null? TypeEMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25) SALARY NOT NULL NUMBER(8,2)COMMISSION_PCT NUMBER(2,2) DEPARTMENT_ID NUMBER(4) View the Exhibit and examine the code for the EMP_TOTSAL procedure created by userSCOTT. Which statement is true regarding the EMP_TOTSAL procedure?
Examine the code in the following PL/SQL block: DECLARE TYPE NumList IS TABLE OF INTEGER; List1 NumList := NumList(11,22,33,44); BEGINList1.DELETE(2); DBMS_OUTPUT.PUT_LINE ( 'The last element# in List1 is ' || List1.LAST || ' and total of elements is '||List1.COUNT); List1.EXTEND(4,3); END;/ Which two statements are true about the above code? (Choose two.)
