Download Oracle Database 12c: Advanced PL-SQL.1z0-148.PracticeTest.2018-02-15.75q.tqb

ProfExam Suite - Black Friday
Vendor: Oracle
Exam Code: 1z0-148
Exam Name: Oracle Database 12c: Advanced PL/SQL
Date: Feb 15, 2018
File Size: 4 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
The STUDENTS table exists in your schema. 
Examine the DECLARE section of a PL/SQL block:
 
Which two blocks are valid?
  1. BEGIN 
    OPEN cursor3 FOR SELECT * FROM students; 
    cursor1 :=cursor3;
    END;
  2. BEGIN 
    OPEN stcur; 
    cursor1 :=stcur;
    END;
  3. BEGIN 
    OPEN cursor1 FOR SELECT * FROM students; 
    stcur :=cursor1;
    END;
  4. BEGIN 
    OPEN stcur; 
    cursor3 :=stcur;
    END;
  5. BEGIN 
    OPEN cursor1 FOR SELECT * FROM students; 
    cursor2 :=cursor1;
    END;
Correct answer: DE
Explanation:
Question 2
Examine the code:
 
Which two subprograms will be created successfully?
  1. CREATE FUNCTION p4 (y pkg.tab_typ) RETURN pkg.tab_typ IS 
    BEGIN 
    EXECUTE IMMEDIATE ‘SELECT pdt_id, pdt_name FROM TABLE (:b)’
    BULT COLLECT INTO pkg.x USING y; 
    RETURN pkg.x; 
    END p4;
  2. CREATE PROCEDURE p1 (y IN OUT pkg.tab_typ) IS 
    BEGIN 
    EXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO y USING pkg.x;
    END p1;
  3. CREATE PROCEDURE p2 (v IN OUT VARCHAR2) IS 
    BEGIN 
    EXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO v USING pkg.x;
    END p2;
  4. CREATE FUNCTION p3 RETURN pkg. tab_typ IS 
    BEGIN 
    EXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO pkg.x;
    END p3;
  5. CREATE PROCEDURE p5 (y pkg. rec_typ) IS 
    BEGIN 
    EXECUTE IMMEDIATE ‘SELECT pdt_name FROM TABLE (:b)’ BULK COLLECT INTO y USING pkg.x;
    END p5;
Correct answer: AC
Explanation:
Question 3
Examine the section of code taken from a PL/SQL program:
 
PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3. 
Which two statements are true?
  1. Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
  2. Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
  3. Calls to TESTPROC are not inlined in the line commented as Call 1.
  4. Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
  5. Calls to TESTPROC might be inlined in the line commented as Call 2.
Correct answer: AE
Explanation:
Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/tuning.htm
Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/tuning.htm
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!