Examine the settings for a user session given below: RESULT_CACHE_MODE= FORCE What would be the implications of this setting on query execution? (Choose all that apply.) A. All query results are stored in the result cache if possible. B. Query…

The result cache is enabled for the database instance. Examine the following code for a PL/SQL function: CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR RESULT_CACHE RELIES_ON (HR.EMPLOYEES) IS date_hired DATE; BEGIN SELECT hire_date INTO date_hired FROM HR.EMPLOYEES WHERE…

Which two statements are true about associative arrays and nested tables? (Choose two.) A. Only associative arrays can hold an arbitrary number of elements. B. Only associative arrays can use numbers and strings for subscripts. C. Both associative arrays and…

View Exhibit1 and examine the structure of the EMPLOYEES and DEPARTMENTS tables existing in your schema. View Exhibit2 and examine the PL/SQL block that you execute to display the department-wise incremented salary for all the departments in your company. The…

Which two statements are true about SecureFile LOB options? (Choose two.) A. The DECRYPT option can be used to remove the encryption only if the LOB column is empty. B. The KEEP_DUPLICATES option removes the deduplication effect only on new…

Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.) A. a PL/SQL program which needs to be recompiled frequently B. a PL/SQL program that spends most of the time executing SQL C.…

See the Exhibit: Explicitly validate the identifier length limit Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.) A. Explicitly validate the identifier length limit B. Add AUTHID DEFINER to the definition…

You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached reuslt bypassed? (Choose all that apply) A. When the size for the memory allocated for the result cache is increased B. When the…

The database instance was started up with the following initializationparameter values: MEMORY_TARGET = 500M RESULT_CACHE_MODE = FORCE RESULT_CACHE_MAX_SIZE = 0 After the database startup, to enable the result cache, you issued the following command: SQL> ALTER SYSTEM SET result_cache_max_size =…

Examine the structure of the PRODUCTS table. Name Null? Type PRODUCT_ID NOT NULL NUMBER(6) PRODUCT_NAME VARCHAR2(50) CATEGORY_ID NUMBER(2) SUPPLIER_ID NUMBER(6) LIST_PRICE NUMBER (8,2)View the Exhibit and examine the PL/SQL block. On execution, the PL/SQL block generates the following error: ORA-…