Download Oracle.1z0-148.SelfTestEngine.2020-04-06.54q.tqb

Download Exam

File Info

Exam Oracle Database 12c: Advanced PL/SQL
Number 1z0-148
File Name Oracle.1z0-148.SelfTestEngine.2020-04-06.54q.tqb
Size 3 MB
Posted Apr 06, 2020
Download Oracle.1z0-148.SelfTestEngine.2020-04-06.54q.tqb

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





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? (Choose two.)


  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: AE



Question 2

Examine the code:
  
Which two subprograms will be created successfully? (Choose two.)


  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



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? (Choose two.)


  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

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files