1Z0-146 Exam Questions

Which guidelines should be considered when designing and using cursors in a PL/SQL block? ? (Choose all that apply.)

View the Exhibit and examine the settings for the PLSQL_CODE_TYPE parameter. After sometime, the user recompiles the procedure DISPLAY_SAL_INFO by issuing the following command: SQ...

Examine the following parameter values for a session: PLSQL_CODE_TYPE = NATIVE PLSQL_OPTIMIZE_LEVEL = 2 Which two statements are true in this scenario? (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) ret...

Examine the structure of the TEXT_TAB table. Name Null? Type --------- ------- ---------- TEXT_ID NUMBER DOC1 CLOB DOC2 CLOB You issue the following INSERT commands: INSERT INTO te...

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 RES...

Which two statements are true about associative arrays and nested tables? (Choose two.)

Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.)

Which three statements are true about hierarchical profiling? (Choose three.)

Which two statements are true about cursor variables? (Choose two.)

View the Exhibit and examine the code in the PL/SQL block. The PL/SQL block generates an error on execution. What is the reason?

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-speci...

Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)

Click on the EXHIBIT button and examine the table instance chart for the cars table. Which SELECT statement will display style, color, and lot number for all cars based on the mode...

You issue this command: CREATE SYNONYM emp FOR ed.employee; Which task has been accomplished?

Click on the EXHIBIT button and examine the structure of the DEPARTMENT and EMPLOYEE tables. Evaluate this SQL statement: CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which r...

Which should you do after each FETCH statement in a PL/SQL block?

Given this executable section of a PL/SQL block: BEGIN FOR employee_record IN salary_cursor LOOP employee_id_table(employee_id) := employee_record.last_name; END LOOP; CLOSE salary...

You designed a CardValidation.java Java source file. You also have the corresponding Card Validation class file. As part of invoking a Java class method, you executed this command...

Examine the settings for a user session given below: RESULT_CACHE_MODE= FORCE What would be the implications of this setting on query execution? (Choose all that apply.)

Which two statements are true about the query results stored in the query result cache? (Choose two.)

Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables.

Examine the code snippet from the declarative section of a PL/SQL block: DECLARE TYPE va1 IS VARRAY(10) OF VARCHAR2(20); SUBTYPE scale IS NUMBER(1,0); TYPE tb1 IS TABLE OF departme...

Which two statements correctly describe the features of SecureFiles? (Choose two.)

Using SQL*Plus, you created a user with this command: CREATE USER jennifer IDENTIFIED BY jbw122; What should you do to allow the user database access?

A DBA has updated Smith's account by adding the privileges CREATE ANY TABLE and CREATE PROCEDURE. Which tasks can Smith successfully perform?

You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you is...

In SQL*Plus, you issued this command: DELETE FROM dept WHERE dept_id = 901; You received an integrity constraint error because a child record was found. What could you do to make t...

How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?