Decide Fast & Get 50% Flat Discount on This 2024Friday | Limited Time Offer - Ends In COUPON CODE: 2024Friday

Home
Dumps
Oracle
1Z0-148

Practice Oracle 1Z0-148 Exam Questions

1. Page: 1/22
  Total 107 Questions
Question No 1

The STUDENTS table exists in your schema. Examine the DECLARE section of a PL/SQL block: Which two blocks are valid?

Choose the Choices:

BEGINOPEN cursor3 FOR SELECT * FROM students;cursor1 :=cursor3;END;

BEGINOPEN stcur;cursor1 :=stcur;END;

BEGINOPEN cursor1 FOR SELECT * FROM students;stcur :=cursor1;END;

BEGINOPEN stcur;cursor3 :=stcur;END;

BEGINOPEN cursor1 FOR SELECT * FROM students;cursor2 :=cursor1;END;

A,E
Question No 2

Examine the code: Which two subprograms will be created successfully?

Choose the Choices:

CREATE FUNCTION p4 (y pkg.tab_typ) RETURN pkg.tab_typ ISBEGINEXECUTE 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) ISBEGINEXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO y USING pkg.x;END p1;

CREATE PROCEDURE p2 (v IN OUT VARCHAR2) ISBEGINEXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO v USING pkg.x;END p2;

CREATE FUNCTION p3 RETURN pkg. tab_typ ISBEGINEXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’ INTO pkg.x;END p3;

CREATE PROCEDURE p5 (y pkg. rec_typ) ISBEGINEXECUTE IMMEDIATE ‘SELECT pdt_name FROM TABLE (:b)’ BULK COLLECT INTO y USING pkg.x;END p5;

A,C
Question No 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 the Choices:

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.

C,E
Question No 4

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

Choose the Choices:

DBMS_PARALLEL_EXECUTE is a SYS - owned package and can be accessed only by a user with DBA privileges.

To execute chunks in parallel, users must have CREATE JOB system privilege.

No specific system privileges are required to create or run parallel execution tasks.

Only DBAs can create or run parallel execution tasks.

Users with CREATE TASK privilege can create or run parallel execution tasks.

B
Question No 5

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

Choose the Choices:

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.

E,F
1. Page: 1/22
  Total 107 Questions
  
  Buy Now Latest Questions
Full Access
1Z0-148 Exam Features

In Just $79 Access Your All Questions

All Official Question Types

Interactive Web-Based Practice Test Software

No Installation or 3rd Party Software Required

Practice your Exam Questions (Free Demo)

24/7 Customer Support

Buy Now
Full Access
1Z0-148 PDF Dumps

In Just $ Access All PDF Questions

All Official Question Types

PDF Practice Questions & Answers

Printable & Portable Format

Download PDF Questions (Free Demo)

24/7 Customer Support

Buy Now