Free Oracle 1z0-148 Exam Dumps Questions & Answers

Examine this code:
CREATE TYPE list_typ IS TABLE OF NUMBER;
/
DECLARE
l_list list_typ := list_typ ();
Which two executable sections will display the message TRUE?

• A.  BEGINl_list.EXTEND;IF l_list.PRIOR (1_list.FIRST) IS NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• B.  BEGINIF l_list.FIRST IS NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• C.  BEGINIF l_list.LIMIT IS NOT NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• D.  BEGINIF l_list.FIRST =1 THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• E.  BEGINl_list.EXTEND;IF l_list IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;

Which two blocks of code execute successfully?

• A.  DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab. EXTEND (2);my_tab (1) := 55;END;
• B.  DECLARETYPE tab_type IS TABLE OF NUMBERmy_tab tab_type := tab_type (2, NULL,
  50);BEGINmy_tab.EXTEND (3, 2);END;
• C.  DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type := tab_type(2);BEGINmy_tab(1)
  :=55;END;
• D.  DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab := tab_type ();my_tab (1) := 55;END;
• E.  DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab (1) :=1;END;

Which two statements are true about conversion from DBMS_SQL to native dynamic SQL? (Choose two.)

• A.  The DBMS_SQL.TO_REFCURSOR function should be used when the number of bind variables is known at compile time, but not the number of items to be selected.
• B.  The DBMS_SQL.IS_OPEN function is used to verify that a SQL cursor number is open after it has been converted to a REF CURSOR.
• C.  The DBMS_SQL.TO_REFCURSOR function converts a SQL cursor number to a weakly typed cursor variable only after it has been opened, parsed, and executed via DBMS_SQL.
• D.  The DBMS_SQL.TO_REFCURSOR function allows a query result to be returned implicitly from a non PL/SQL environment to a stored PL/SQL program.
• E.  DBMS_SQL operations can access the cursor only as the SQL cursor number, not as a REF CURSOR variable.

Examine these two columns:

Which set of paired items is valid with respect to the DBMS_PARALLEL_EXECUTE package?

• A.  1-c, 2-a, 3-b, 4-e, 5-d
• B.  1-c, 2-b, 3-e, 4-a, 5-d
• C.  1-c, 2-d, 3-b, 4-e, 5-a
• D.  1-b, 2-d, 3-c, 4-e, 5-a
• E.  1-e, 2-a, 3-c, 4-b, 5-d

Examine the code:

Which two subprograms will be created successfully?

• A.  CREATE PROCEDURE p2 (v IN OUT VARCHAR2) ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO v USING pkg.x;END p2;
• B.  CREATE PROCEDURE p1 (y IN OUT pkg.tab_typ) ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO y USING pkg.x;END p1;
• C.  CREATE FUNCTION p3 RETURN pkg. tab_typ ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO pkg.x;END p3;
• D.  CREATE FUNCTION p4 (y pkg.tab_typ) RETURN pkg.tab_typ ISBEGINEXECUTE IMMEDIATE
  'SELECT pdt_id, pdt_name FROM TABLE (:b)'BULT COLLECT INTO pkg.x USING y;RETURN pkg.x;END p4;
• E.  CREATE PROCEDURE p5 (y pkg. rec_typ) ISBEGINEXECUTE IMMEDIATE 'SELECT pdt_name FROM TABLE (:b)' BULK COLLECT INTO y USING pkg.x;END p5;