Download Oracle.1z0-148.SelfTestEngine.2020-02-07.49q.tqb

Vendor:	Oracle
Exam Code:	1z0-148
Exam Name:	Oracle Database 12c: Advanced PL/SQL
Date:	Feb 07, 2020
File Size:	2 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?

Correct answer: AE

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

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.