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. 4)

  • 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 #16
Examine this code:

What is the correct statement to get the value of attribute ACCOUNT_MGR after the procedure has been executed?
  1. A
    SELECT USERENV (‘ACCOUNT_MGR’) FROM dual;
  2. B
    SELECT SYS_CONTEXT (‘USERENV’, ‘ACCOUNT_MGR’) FROM dual;
  3. C
    SELECT SYS_CONTEXT (‘ORDER_CTX’, ‘ACCOUNT_MGR’) FROM dual;
  4. D
    SELECT SYS_CONTEXT (‘ACCOUNT_MGR’, ‘ORDER_CTX’) FROM dual;
  5. E
    SELECT USERENV (‘ORDER_CTX’) FROM dual;

Correct Answer:
B

Question #17
Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?
  1. A
    ALL_SOURCE
  2. B
    ALL_DEPENDENCIES
  3. C
    ALL_OBJECTS
  4. D
    ALL_PROCEDURES
  5. E
    ALL_PLSQL_OBJECT_SETTINGS

Correct Answer:
D

Question #18
Examine this code:

Examine this DML statement executed in the SCOTT schema:
UPDATE emp SET comm = 1000 WHERE deptno= 20;
What is the outcome after executing this statement?
  1. A
    COMM is set to 1000 for all records in the EMP table where DEPTNO = 30.
  2. B
    The statement executes successfully but no rows are updated.
  3. C
    COMM is set to 1000 for all records in the EMP table where DEPTNO=20.
  4. D
    The statement fails with error ORA-28115: policy with check option violation.

Correct Answer:
D

Question #19
Identify the two correct scenarios where a function can be optimized using the function result cache feature.
  1. A
    A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
  2. B
    A function which accesses multiple tables and calculates the commission to be given to a sales representative based on the number of products sold by that representative.
  3. C
    A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.
  4. D
    A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
  5. E
    A function which calculates the factorial of a given number without accessing any table.

Correct Answer:
DE

Question #20
Select the correct statement regarding BEQUEATH CURRENT_USER.
  1. A
    If a view references a PL/SQL function then BEQUEATH CURRENT_USER allows the function to execute with DBA privileges, regardless of the invoking users privileges.
  2. B
    The BEQUEATH CURRENT_USER clause allows invoker’s rights functions referenced in a view to execute with the privileges of the invoking user.
  3. C
    Any view calling a PL/SQL function with BEQUEATH CURRENT_USER in effect will execute with the privileges of the function owner.
  4. D
    With the BEQUEATH CURRENT_USER clause, a definer’s rights function referenced in a view executes with the privileges of the view owner, not the function

Correct Answer:
B
Reference:
https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG558

Previous Questions Next Questions

All Pages