New Updated 1z0-148 Exam Questions from myexamcollection 1z0-148 PDF dumps! Welcome to download the newest myexamcollection 1z0-148 VCE dumps: http://www.myexamcollection.com/1z0-148-vce-questions.htm (75 Q&As)
PS. New 1z0-148 dumps PDF –http://www.myexamcollection.com/top/demo/Oracle/1z0-148.pdf 1z0-148 Practice Test Questions Answers – 1z0-148 braindump QUESTION NO: 1 Examine the following SQL statement: ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3; What is the result of executing this statements? A. The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result. B. The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled. C. The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled. D. This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level, Answer: C QUESTION NO: 2 Which two statements describe actions developers can take to make their application less vulnerable to security attacks? A. Include the AUTHID DEFINER clause in stored program units. B. Do not concatenate unchecked user input into dynamically constructed SQL statements. C. Switch from using DBMS_SQL to EXECUTE IMMEDIATE. D. Include the AUTHID CURRENT_USER clause in stored program units. E. Increase the amount of code that is accessible to users by default. Answer: B,D QUESTION NO: 3 Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute? A. ALL_SOURCE B. ALL_DEPENDENCIES C. ALL_OBJECTS D. ALL_PROCEDURES E. ALL_PLSQL_OBJECT_SETTINGS Answer: D QUESTION NO: 4 Identify the two correct scenarios where a function can be optimized using the function result cache feature. A. A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application. 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. C. A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE. D. A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION. E. A function which calculates the factorial of a given number without accessing any table. Answer: D,E QUESTION NO: 5 Select the correct statement regarding BEQUEATH CURRENT_USER. 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 user’s privileges. B. The BEQUEATH CURRENT_USER clause allows invoker’s rights functions referenced in a view to execute with the privileges of the invoking user. C. Any view calling a PL/SQL function with BEQUEATH CURRENT_USER in effect will execute with the privileges of the function owner. 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 owner. Answer: B
0 Comments
Leave a Reply. |