1z1-148 by Oracle Valid Free Exam Practice Test

Question 1

Examine the DBMS_LOB.LOADCLOBFROMFILE procedure:

Which statement is true about DBMS_LOB.LOADCLOBFROMFILE?

A. The amount parameter can be set to NULL to indicate to load to the end of the BFILE. B. If any error occurs when calling the procedure then it is written to the warning parameter and DBMS_LOB.LOADCLOBFROMFILE finishes successfully. C. An exception will always be raised if amount plus src_offset exceeds the length of the BFILE. D. The amount parameter can be set to DBMS_LOB.LOBMAXSIZE to indicate to load to the end of the BFILE.

Correct Answer: D

Question 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. Add the RELIES_ON clause to the function definition. C. Enable the result cache by using DBMS_RESULT_CACHE.BYPASS (FALSE). D. Add the deterministic clause to the function definition. E. Add the RESULT_CACHE clause to the function definition.

Correct Answer: A,D

Question 3

Which two statements will raise an exception? (Choose two.)

A. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employee_Department_information_table') FROM dual; B. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@') FROM dual; C. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('"10_Employees"') FROM dual; D. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME (' Emp_Dept_information_table ') FROM dual; E. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@my_dblink') FROM dual;

Correct Answer: B,C

Question 4

Which two statements about the PL/SQL hierarchical profiler are true?

A. It helps you identify subprograms that are causing bottlenecks in application performance. B. Access it using the DBMS_HPROF package. C. It is only accessible after a grant of the CREATE PROFILE privilege. D. Access it using the DBMS_PROFILER package. E. Profiler data is recorded in tables and published in HTML reports.

Correct Answer: A,B

Question 5

Examine this block:

Which two will be correct after line 5?

A. va. NEXT (199) will return NULL. B. va. LAST and va. LIMIT will return the same value. C. va. LIMIT and va. COUNT will return the same value. D. va. LAST will return 200. E. va. LAST and va. COUNT will return the same value. F. va. LIMIT and va. NEXT (199) will return the same value.

Correct Answer: A,E

Question 6

Which two blocks of code execute successfully?

A. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type := tab_type(2);BEGINmy_tab(1)
:=55;END; B. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab. EXTEND (2);my_tab (1) := 55;END; C. DECLARETYPE tab_type IS TABLE OF NUMBERmy_tab tab_type := tab_type (2, NULL,
50);BEGINmy_tab.EXTEND (3, 2);END; D. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab (1) :=1;END; E. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab := tab_type ();my_tab (1) := 55;END;

Correct Answer: A,E

Question 7

Which two statements are true about conversion from DBMS_SQL to native dynamic SQL? (Choose two.)

A. The DBMS_SQL.IS_OPEN function is used to verify that a SQL cursor number is open after it has been converted to a REF CURSOR. B. DBMS_SQL operations can access the cursor only as the SQL cursor number, not as a REF CURSOR variable. C. The DBMS_SQL.TO_REFCURSOR function converts a SQL cursor number to a weakly typed cursor variable only after it has been opened, parsed, and executed via DBMS_SQL. D. The DBMS_SQL.TO_REFCURSOR function should be used when the number of bind variables is known at compile time, but not the number of items to be selected. E. The DBMS_SQL.TO_REFCURSOR function allows a query result to be returned implicitly from a non PL/SQL environment to a stored PL/SQL program.

Correct Answer: B,D

Oracle Database: Advanced PL/SQL - 1z1-148 Exam Practice Test