Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-148

Oracle 1z0-148 Exam Practice Questions (P. 1)

  • Full Access (75 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
The STUDENTS table exists in your schema.
Examine the DECLARE section of a PL/SQL block:

Which two blocks are valid?
  1. A
    BEGIN OPEN cursor3 FOR SELECT * FROM students; cursor1 :=cursor3; END;
  2. B
    BEGIN OPEN stcur; cursor1 :=stcur; END;
  3. C
    BEGIN OPEN cursor1 FOR SELECT * FROM students; stcur :=cursor1; END;
  4. D
    BEGIN OPEN stcur; cursor3 :=stcur; END;
  5. E
    BEGIN OPEN cursor1 FOR SELECT * FROM students; cursor2 :=cursor1;

Correct Answer:
DE

Question #2
Examine the code:

Which two subprograms will be created successfully?
  1. 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;
  2. 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;
  3. C
    CREATE PROCEDURE p2 (v IN OUT VARCHAR2) IS BEGIN EXECUTE IMMEDIATE SELECT f (:b) FROM DUAL INTO v USING pkg.x; END p2;
  4. D
    CREATE FUNCTION p3 RETURN pkg. tab_typ IS BEGIN EXECUTE IMMEDIATE SELECT f (:b) FROM DUAL INTO pkg.x; END p3;
  5. 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;

Correct Answer:
AC

Question #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?
  1. A
    Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
  2. B
    Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
  3. C
    Calls to TESTPROC are not inlined in the line commented as Call 1.
  4. D
    Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
  5. E
    Calls to TESTPROC might be inlined in the line commented as Call 2.

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

Question #4
Which statement is true about the DBMS_PARALLEL_EXECUTE package?
  1. A
    DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
  2. B
    To execute chunks in parallel, users must have CREATE JOB system privilege.
  3. C
    No specific system privileges are required to create or run parallel execution tasks.
  4. D
    Only DBAs can create or run parallel execution tasks.
  5. E
    Users with CREATE TASK privilege can create or run parallel execution tasks.

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

Question #5
Which two statements are true regarding edition-based redefinition (EBR)?
  1. A
    There is no default edition defined in the database.
  2. B
    EBR does not let you upgrade the database components of an application while in use.
  3. C
    You never use EBR to copy the database objects and redefine the copied objects in isolation.
  4. D
    Editions are non-schema objects.
  5. E
    When you change an editioned object, all of its dependents remain valid.
  6. F
    Tables are not editionable objects.

Correct Answer:
EF
Reference:
https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm#BABEHGAF

Next Questions

All Pages