http://https://www.lead1pass.com/Oracle/1z0-148-practice-exam-dumps.html (75 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 7
Which statement is true about internal and external LOBs?
A. An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.
B. A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.
C. Internal and external LOBs can be written using DBMS_LOB.
D. After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.
E. When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.
Answer: D,E
Explanation/Reference:
Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_lob.htm

NEW QUESTION NO: 8
Which two statements are correct for collecting data about identifiers in PL/SQL source code?
A. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
B. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’
C. ALTER SYSTEM SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
D. CREATE < function/Procedure> PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’ AS …
E. ALTER <function/Procedure> COMPILE PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’
Answer: B,D

NEW QUESTION NO: 9
Which statement is true about the DBMS_PARALLEL_EXECUTE package?
A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
B. To execute chunks in parallel, users must have CREATE JOB system privilege.
C. No specific system privileges are required to create or run parallel execution tasks.
D. Only DBAs can create or run parallel execution tasks.
E. Users with CREATE TASK privilege can create or run parallel execution tasks.
Answer: B
Explanation/Reference:
Reference https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm#ARPLS67331 (security model)

NEW QUESTION NO: 10
Which two statements are correct in Oracle Database 12c?
A. For native compilation, PLSQL_OPTIMIZE_LEWVEL should be set to 2.
B. Native compilation is the default compilation method
C. Native compilation should be used during development.
D. Natively compiles code is stored in the SYSTEM tablespace.
E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile it.
Answer: D,E
Explanation/Reference:
Reference: https://www.google.com/url?
sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwiW9-
2j66rYAhUBORQKHaKOAnsQFggtMAE&url=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%
2Fdatabase%2Ffeatures%2Fplsql%2Fncomp-faq-087606.html&usg=AOvVaw3H2JhdwNaDzp-Jly5-wtTk

NEW QUESTION NO: 11
This result cache is enabled for the database instance.
Examine this code for a PL/SQL function:

Which two actions would ensure that the same result will be consistently returned for any session when the same input value is passed to the function?
A. Set the RESULT_CACHE_MAX_RESULT parameter to 0.
B. Add a parameter, fmt, and change the RETURN statement to:
RETURN TO_CHAR (date_hired, fmt);
C. Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.
D. Set the RESULT_CACHE_MODE parameter to FORCE.
E. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
Answer: C,D

NEW QUESTION NO: 12
Which PRAGMA statement may enable associated PL/SQL functions to run more efficiently when called from SQL?
A. PRAGMA SERIALLY_REUSABLE;
B. PRAGMA UDF;
C. PRAGMA INLINE (‘<function_name>’, ‘YES’);
D. PRAGMA AUTONOMOUS_TRANSACTION;
Answer: B
Explanation/Reference:
Reference: https://mwidlake.wordpress.com/2015/11/04/pragma-udf-speeding-up-your-plsql-functions- called-from-sql/

NEW QUESTION NO: 13
Examine this block:

Which two will be correct after line 5?
A. va. LAST and va. COUNT will return the same value.
B. va. LAST and va. LIMIT will return the same value.
C. va. NEXT (199) will return NULL.
D. va. LIMIT and va. NEXT (199) will return the same value.
E. va. LIMIT and va. COUNT will return the same value.
F. va. LAST will return 200.
Answer: B,E

NEW QUESTION NO: 14
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 updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
C. A function which calculates the factorial of a given number without accessing any table.
D. 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.
E. A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.
Answer: B,C

NEW QUESTION NO: 15
Examine this code:

Which two corrections must be applied for this anonymous block to execute successfully?
A. Change RETURN p_tab.LAST to RETURN p_tab.COUNT.
B. Change the INDEX BY clause from VARCHAR2 to PLS_INTEGER.
C. Declare the collection type inside the function.
D. Modify the function return type to return a scalar, VARCHAR2.
E. Declare the collection type at the schema level instead of the package.
F. Define the function as stand-alone instead of in a package body.
Answer: B,F

NEW QUESTION NO: 16
Examine these statements:

Which two corrections will allow this anonymous block to execute successfully?
A. Add i PLS_INTEGER; before the 3 line.
rd
B. Add wk#. EXTEND (1); before the 5 line.
th
C. Replace lines 5 and 6 with wk# (i) := tp_rec# (i, i);
D. Change line #2 to wk# tp_test# := tp_test# (tp_rec# ());
E. Add wk# .NEXT; before the 7 line.
th
Answer: B,C

NEW QUESTION NO: 17
Examine this code:

The anonymous block fails with:
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 5
Which two are valid options to prevent this error from occurring?
A. Rewrite the block as:
DECLARE
TYPE databuf_arr IS TABLE OF CLOB INDEX BY BINATY_INTEGER;
pdatabuf databuf_arr;
PROCEDURE mytemplob (x OUT CLOB) IS
BEGIN
DBMS_LOB.CREATETEMPORARY (x, TRUE, DBMS_LOB, SESSION);
END;
BEGIN
mytemplob (pdatabuf (1));
END;
/
B. pdatabuf (1) := NULL; should be added after line 4.
C. Line 5 should be replaced with:
DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);
D. Line 5 should be replaced with:
DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);
E. Line 5 should be replaced with:
DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);
Answer: A,D