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

Vendor:	Oracle
Exam Code:	1z0-148
Exam Name:	Oracle Database 12c: Advanced PL/SQL
Date:	Apr 06, 2020
File Size:	3 MB
Downloads:	1

Download Exam

Demo Questions

The STUDENTS table exists in your schema.

Examine the DECLARE section of a PL/SQL block:

Which two blocks are valid? (Choose two.)

Correct answer: AE

Examine the code:

Which two subprograms will be created successfully? (Choose two.)

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;
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;
CREATE PROCEDURE p2 (v IN OUT VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO v USING pkg.x;
END p2;
CREATE FUNCTION p3 RETURN pkg. tab_typ IS
BEGIN
EXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO pkg.x;
END p3;
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

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.)

Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
Calls to TESTPROC are not inlined in the line commented as Call 1.
Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
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

CONNECT US

EXAM SIMULATOR

How to Open TQB Files?

Use Taurus Exam Simulator to open TQB files