Free Oracle 1z0-148 Exam Dumps Questions & Answers

Identify the three options which make a PL/SQL function highly suitable for using the RESULT_CACHE clause in its definition. (Choose three.)

• A.The value returned by the function is deterministic for a given set of input parameters.
• B.The code in the function performs more write operations on the database when compared to the read operations.
• C.The function has complex business logic depending on more than five tables to compute its return values.
• D.The logic in the function accesses tables or uses package variables which are modified very rarely.
• E.The function involves highly computational logic with minimal or no database access.
• F.The tables which are read in the function are very frequently updated.

Which three statements are correct when using collections? (Choose three.)

• A.Associative arrays may be used when you need to process information of unknown volume.
• B.Nested tables should be used when the index values are non-sequential.
• C.Do not use nested tables when you need to delete elements.
• D.Nested tables may be used when there is no predefined upper bound for index values.
• E.Use associative arrays when you need numeric and string indices.
• F.Varrays should be used when you need to pass the collection as a parameter.

Examine this function body:

Which two headers will allow this function to compile successfully and take advantage of both invoker's rights and function result caching?

• A.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2AUTHID
  DEFINERISdate_hired DATE;
• B.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (departments)AUTHID CURRENT_USERISdate_hired DATE;
• C.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (employees)AUTHID CURRENT_USERISdate_hired DATE;
• D.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
  VARCHAR2RESULT_CACHEAUTHID DEFINERISdate_hired DATE;
• E.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
  VARCHAR2RESULT_CACHEAUTHID CURRENT_USERISdate_hired DATE;

Which data dictionary view includes information about the parameters of procedures and functions that you can call?

• A.ALL_PACKAGES
• B.ALL_ARGUMENTS
• C.ALL_PROCEDURES
• D.ALL_OBJECTS

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

• A.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.
• B.DBMS_SQL operations can access the cursor only as the SQL cursor number, not as a REF CURSOR variable.
• C.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.
• D.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.
• E.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.