1z1-148 무료 덤프문제 온라인 액세스

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 VARCHAR2RESULT_CACHE RELIES_ON (departments)AUTHID CURRENT_USERISdate_hired DATE;
• B.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
  VARCHAR2RESULT_CACHEAUTHID CURRENT_USERISdate_hired DATE;
• C.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
  VARCHAR2RESULT_CACHEAUTHID DEFINERISdate_hired DATE;
• D.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2AUTHID
  DEFINERISdate_hired DATE;
• E.CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (employees)AUTHID CURRENT_USERISdate_hired DATE;

Examine these two columns:

Which set of paired items is valid with respect to the DBMS_PARALLEL_EXECUTE package?

• A.1-c, 2-b, 3-e, 4-a, 5-d
• B.1-c, 2-a, 3-b, 4-e, 5-d
• C.1-e, 2-a, 3-c, 4-b, 5-d
• D.1-b, 2-d, 3-c, 4-e, 5-a
• E.1-c, 2-d, 3-b, 4-e, 5-a

Which two statements are true regarding edition-based redefinition (EBR)?

• A.There is no default edition defined in the database.
• B.EBR does not let you upgrade the database components of an application while in use.
• C.You never use EBR to copy the database objects and redefine the copied objects in isolation.
• D.Editions are non-schema objects.
• E.When you change an editioned object, all of its dependents remain valid.
• F.Tables are not editionable objects.

Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?

• A.If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.
• B.DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
• C.DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
• D.DBMS_LOB.GETOPTIONS can only be used for BLOB data types.

Identify the two correct scenarios where a function can be optimized using the function result cache feature.

• A.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.
• B.A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
• 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.