Online Access Free 1Z0-146 Practice Test

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 because PRAGMA INLINE forces a specific call to
  be inlined.
• 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 irrespective of the value set for the PLSQL_OPTIMIZE_LEVEL parameter.

Match the following external C procedure components with their descriptions:
1.External procedure a. a process that starts the extproc process
2.Shared library b. a session-specific process that executes the external procedure
3.Alias library c. schema object that represents the operating system (OS) shared library
4.The extproc process d. operating system file that stores the external procedure
5.Listener process e. a unit of code written in C

• A.1-c; 2-d; 3-e; 4-b; 5-a
• B.1-e; 2-d; 3-c; 4-b; 5-a
• C.1-e; 2-c; 3-d; 4-b; 5-a
• D.1-a; 2-d; 3-e; 4-c; 5-b

When do you use static SQL as a technique for avoiding SQL injection?

• A.when the WHERE clause values are unknown
• B.when the SET clause values are unknown at the time of code compilation
• C.when the code contains data definition language (DDL) statements
• D.when all Oracle identifiers are known at the time of code compilation

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

Examine the following structure: SQL> DESCRIBE user_identifiers Name Null? Type
NAME VARCHAR2(30)
SIGNATURE VARCHAR2(32)
TYPE VARCHAR2(18)
OBJECT_NAME NOT NULL VARCHAR2(30)
OBJECT_TYPE VARCHAR2(13)
USAGE VARCHAR2(11)
USAGE_ID NUMBER
LINE NUMBER
COL NUMBER
USAGE_CONTEXT_ID NUMBER
Identify two scenarios in which information is stored in the USAGE column. (Choose two.)

• A.an identifier passed to a subprogram in IN OUT mode
• B.declaration of a variable or formal parameter
• C.an assignment made to VARIABLE
• D.execution of the GOTO statement or raise of an exception