Question NO : 2
Examine this function header:
FUNCTION calc_new_sal (emp_id NUMBER) RETURN NUMBER;
You want to ensure that whenever this PL/SQL function is invoked with the same
parameter value across active sessions, the result is not recomputed.
If a DML statement is modifying a table which this function depends upon, the function
result must be recomputed at that point in time for all sessions calling this function.
Which two actions should you perform?
A. Ensure RESULT_CACHE_MAX_SIZE is greater than 0.
B. Enable the result cache by using DBMS_RESULT_CACHE.BYPASS (FALSE).
C. Add the deterministic clause to the function definition.
D. Add the RELIES_ON clause to the function definition.
E. Add the RESULT_CACHE clause to the function definition.
Answer: A,C
Monday, 8 January 2018
Get Latest 1Z0-148 Exam Dumps Questions -1Z0-148 Exam Dumps - Dumps4Download
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 animmediate 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
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 animmediate 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
Valid And Updated 1Z0-148 Exam Certifications Dumps Questions - Dumps4Download
Question No 1
Which three statements are correct with reference to intra unit inlining?
A. Inlining will always decrease the size of a unit.
B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
C. You cannot inline an external subroutine.
D. Programs that make use of smaller helper subroutines are good candidates for inlining.
E. Pragmas apply only to calls in the next statement following the pragma.
F. You cannot inline local subroutines.
Answer: C,D,E
Which three statements are correct with reference to intra unit inlining?
A. Inlining will always decrease the size of a unit.
B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
C. You cannot inline an external subroutine.
D. Programs that make use of smaller helper subroutines are good candidates for inlining.
E. Pragmas apply only to calls in the next statement following the pragma.
F. You cannot inline local subroutines.
Answer: C,D,E
Download Latest 1Z0-148 Exam Dumps In Just 24 Hours - Dumps4Download
Question No 2
You are designing and developing a complex database application and implementing finegrained
access control using security policies.Which statement is true with respect to attaching security policies to database objects?
A.You can use different security policies for SELECT, INSERT, UPDATE, INDEX and DELETE statements.
B. You can use only one security policy per database object.
C. You implement security policies through database procedures.
D. Column-masking policies can be applied to SELECT, INSERT, UPDATE and DELETE statements.
Answer: D
You are designing and developing a complex database application and implementing finegrained
access control using security policies.Which statement is true with respect to attaching security policies to database objects?
A.You can use different security policies for SELECT, INSERT, UPDATE, INDEX and DELETE statements.
B. You can use only one security policy per database object.
C. You implement security policies through database procedures.
D. Column-masking policies can be applied to SELECT, INSERT, UPDATE and DELETE statements.
Answer: D
Complete 1Z0-148 Exam Dumps - Pass In 24 Hours - Dumps4Download
Question No 1
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
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
Subscribe to:
Comments (Atom)