Which two queries' results cannot be cached? (Choose two.)
Which two are major approaches that can be used to reduce the SQL injection by limiting user input? (Choose two.)
Which two statements are true about the extproc process? (Choose two.)
The PLSQL_OPTIMIZE_LEVEL parameter is set to 2 for the session. Examine the section of code given:FUNCTION p2 (p boolean) return PLS_INTEGER IS ...FUNCTION p2 (x PLS_INTEGER) return PLS_INTEGER IS ... ...PRAGMA INLINE(p2, 'YES');x := p2(true) + p2(3); ...Which statement is true about the INLINE pragma procedure calls?
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_hiredDATE;BEGIN SELECT hire_date INTO date_hired FROM HR.EMPLOYEES WHERE EMPLOYEE_ID = emp_id;RETURN TO_CHAR(date_hired);END;Which statement is true in this scenario?
Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.)
