READ Free Dumps For Oracle- 1z0-146

Question ID 2823	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?
Option A	A.    It invokes the external C procedure.
Option B	B.    It only publishes the external C procedure.
Option C	C.    It fails because the external C procedure is not published.
Option D	D.    It fails because the input data type is BINARY_INTEGER and the external C procedure expects an integer.
Correct Answer	C

Explanation

Question ID 2824	A procedure is created in the SYS schema to allow users to change the password as follows: CREATE OR 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 for SYS by using this procedure. How would you protect this?
Option A	A.    by using the procedure as part of a PL/SQL package
Option B	B.    by using a bind argument with dynamic SQL in the procedure
Option C	C.    by using AUTHID DEFINER in the procedure to implement the definer's right
Option D	D.    by using AUTHID CURRENT_USER in the procedure to implement the invoker's right
Correct Answer	D

Explanation

Previous-Page 1 2. . . 43 44 45 46 47 48 49. . . 93 94 Next-Page

Send email to admin@getfreedumps for new dumps request!!!