ExamTopics Logo
Mail Us[email protected]
Menu
 

1z0-148 Actual Exam Questions

Last updated on Dec. 13, 2024.
Vendor:Oracle
Exam Code:1z0-148
Exam Name:Oracle Database 12c Advanced PLSQL
Exam Questions:75
97% Passed the exam with this material
 

Topic 1 - Single Topic

Question #1 Topic 1

The STUDENTS table exists in your schema.
Examine the DECLARE section of a PL/SQL block:

Which two blocks are valid?

  • A. BEGIN OPEN cursor3 FOR SELECT * FROM students; cursor1 :=cursor3; END;
  • B. BEGIN OPEN stcur; cursor1 :=stcur; END;
  • C. BEGIN OPEN cursor1 FOR SELECT * FROM students; stcur :=cursor1; END;
  • D. BEGIN OPEN stcur; cursor3 :=stcur; END;
  • E. BEGIN OPEN cursor1 FOR SELECT * FROM students; cursor2 :=cursor1;
Reveal Solution Hide Solution   Discussion   8

Correct Answer: DE 🗳️

Question #2 Topic 1

Examine the code:

Which two subprograms will be created successfully?

  • A. 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;
  • B. 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;
  • C. CREATE PROCEDURE p2 (v IN OUT VARCHAR2) IS BEGIN EXECUTE IMMEDIATE SELECT f (:b) FROM DUAL INTO v USING pkg.x; END p2;
  • D. CREATE FUNCTION p3 RETURN pkg. tab_typ IS BEGIN EXECUTE IMMEDIATE SELECT f (:b) FROM DUAL INTO pkg.x; END p3;
  • E. CREATE PROCEDURE p5 (y pkg. rec_typ) IS BEGIN EXECUTE IMMEDIATE SELECT pdt_name FROM TABLE (:b) BULK COLLECT INTO y USING pkg.x;
Reveal Solution Hide Solution   Discussion   5

Correct Answer: AC 🗳️

Question #3 Topic 1

Examine the section of code taken from a PL/SQL program:

PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3.
Which two statements are true?

  • A. Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
  • B. Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
  • C. Calls to TESTPROC are not inlined in the line commented as Call 1.
  • D. Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
  • E. Calls to TESTPROC might be inlined in the line commented as Call 2.
Reveal Solution Hide Solution   Discussion   6

Correct Answer: AE 🗳️
Reference:
https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/tuning.htm

Question #4 Topic 1

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

  • A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
  • B. To execute chunks in parallel, users must have CREATE JOB system privilege.
  • C. No specific system privileges are required to create or run parallel execution tasks.
  • D. Only DBAs can create or run parallel execution tasks.
  • E. Users with CREATE TASK privilege can create or run parallel execution tasks.
Reveal Solution Hide Solution   Discussion   1

Correct Answer: B 🗳️
Reference -
https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm#ARPLS67331
(security model)

file Viewing page 1 out of 19 pages.
Viewing questions 1-4 out of 75 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago