Download Oracle.1z0-148.CertDumps.2018-02-02.41q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-148 |
| Exam Name: | Oracle Database 12c: Advanced PL/SQL |
| Date: | Feb 02, 2018 |
| File Size: | 2 MB |
| Downloads: | 1 |
Demo Questions
Question 1
Select the correct statement regarding BEQUEATH CURRENT_USER.
- If a view references a PL/SQL function then BEQUEATH CURRENT_USER allows the function to execute with DBA privileges, regardless of the invoking user’s privileges.
- The BEQUEATH CURRENT_USER clause allows invoker’s rights functions referenced in a view to execute with the privileges of the invoking user.
- Any view calling a PL/SQL function with BEQUEATH CURRENT_USER in effect will execute with the privileges of the function owner.
- 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 owner.
Correct answer: B
Explanation:
Reference: https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG558 Reference: https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG558
Question 2
Which tablespace is used to store the data collected by PL/Scope?
- UNDOTBS1
- SYSAUX
- SYSTEM
- TEMP
- USERS
Correct answer: B
Explanation:
Reference: https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htm#BABDGJAF Reference: https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htm#BABDGJAF
Question 3
Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?
- The IN parameters must not include BLOB, CLOB, collection or record data types.
- The function must be created with invoker’s rights or in an anonymous block.
- The function must be declared as a pipelined table function.
- The function must have an OUT or an IN OUT parameter.
Correct answer: C
Explanation:
Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/subprograms.htm#insertedID11 Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/subprograms.htm#insertedID11
