Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)
You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed the following command to check the status for the result cache:,SQL> select dbms_result_cache.status() from dual; You receive the following output: DBMS_RESULT_CACHE.STATUS()DISABLED Identify the reason for the output.
You have an external C procedure stored in a dynamic-link library (DLL). The C procedure takes an integer as argument and returns an integer. You want to invoke the C procedure through a PL/SQL program. View the Exhibit. Which statement is true about the C_OUTPUT PL/SQL program?
A procedure is created in the SYS schema to allow users to change the password as follows: CREATEOR REPLACE PROCEDURE change_password(p_username VARCHAR2 DEFAULT NULL, p_new_password VARCHAR2 DEFAULT NULL) IS v_sql_stmt VARCHAR2(500); BEGIN v_sql_stmt :='ALTER USER '||p_username ||' IDENTIFIED BY '|| p_new_password; EXECUTE IMMEDIATE v_sql_stmt; END change_password; The SYS user has granted EXECUTE privilege on the procedure to the OE user. But OE is able to change the password forSYS by using this procedure. How would you protect this?
In which two situations is the body of a result-cached function executed? (Choose two.)
Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
