Free Download 1z0-148 Examp Dump: Oracle.1z0-148.SelfTestEngine.2020-02-07.49q.tqb

File Info

Exam	Oracle Database 12c: Advanced PL/SQL
Number	1z0-148
File Name	Oracle.1z0-148.SelfTestEngine.2020-02-07.49q.tqb
Size	2 MB
Posted	Feb 07, 2020
Download	Oracle.1z0-148.SelfTestEngine.2020-02-07.49q.tqb

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

Download
ProfExam Simulator

Coupon: MASTEREXAM
With discount: 20%

Question 1

The STUDENTS table exists in your schema.

Examine the DECLARE section of a PL/SQL block:

Which two blocks are valid?

Correct answer: AE

Question 2

Examine the code:

Which two subprograms will be created successfully?

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

Question 3

Which two statements are true regarding edition-based redefinition (EBR)?

There is no default edition defined in the database.
EBR does not let you upgrade the database components of an application while in use.
You never use EBR to copy the database objects and redefine the copied objects in isolation.
Editions are non-schema objects.
When you change an editioned object, all of its dependents remain valid.
Tables are not editionable objects.