1Z0-146 무료 덤프문제 온라인 액세스

Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE
View the Exhibit and examine the PL/SQL code.
You compile the program with the following attributes:
SQL> ALTER PROCEDURE proc1 COMPILE PLSQL_OPTIMIZE_LEVEL = 1;
Which statement is true about the execution of the PROC1 procedure in this scenario?

• A.The FUNC1 function would be called inline irrespective of the value set for the PLSQL_OPTIMIZE_LEVEL parameter.
• B.The FUNC1 function would not be called inline because the value for the PLSQL_OPTIMIZE_LEVEL parameter is set to a lower value.
• C.The FUNC1 function would be inlined because the value set for the PLSQL_CODE_TYPE parameter is set to NATIVE.
• D.The FUNC1 function would be called inline because PRAGMA INLINE forces a specific call to
  be inlined.

View the Exhibit and examine the output.

Which statement is an inference from the output?

• A.Java class methods in the Java class file have been published.
• B.The class file is pinned into the Java pool.
• C.The class file has been loaded into the shared library.
• D.The loadjava command has been executed to load the Java source and class files.

Identify two methods for immunizing PL/SQL code against SQL injection attacks. (Choose two.)

• A.Use subprograms as part of packages instead of stand-alone subprograms.
• B.Validate all input concatenated to dynamic SQL.
• C.Use bind arguments.
• D.Use dynamic SQLs constructed using concatenation of input values.

View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.

Examine the PL/SQL block that you execute to find the average salary for employees in the 'Sales' department: DECLARE TYPE emp_sal IS TABLE OF employees.salary%TYPE INDEX BY VARCHAR2(20); v_emp_sal emp_sal; PROCEDURE get_sal(p_dept_name VARCHAR2, p_arr OUT emp_sal) IS BEGIN SELECT AVG(salary) INTO p_arr(p_dept_name) FROM employees WHERE department_id= (SELECT department_id FROM departments
WHERE department_name=p_dept_name);
END get_sal;
BEGIN
get_sal('Sales',v_emp_sal);
DBMS_OUTPUT.PUT_LINE( v_emp_sal('Sales'));
END;
/
What is the outcome?

• A.It generates an error because an associative array cannot be used with the SELECT INTO statement.
• B.It generates an error because an associative array cannot be passed to a procedure in OUT mode.
• C.It generates an error because the associative array definition is not valid.
• D.It executes successfully and gives the correct output.

Examine the following line of code that is part of a PL/SQL application: stmt:='SELECT session_id FROM sessions WHERE ' || p_where_stmt; Identify a solution for preventing SQL injection in the above code.

• A.Replace P_WHERE_STMT with a bind variable.
• B.Use DBMS_SQL to detect that the expression provided for P_WHERE_STMT is free from SQL injection.
• C.Use the RESTRICT_REFERENCES clause in the PL/SQL subprogram that contains the code.
• D.Do not use APIs that allow arbitrary query parameters to be exposed.