Oracle 1Z0-146 Online Practice Questions and Exam Preparation

Oracle 1Z0-146 Online Questions & Answers

• Question 81:

  The following command is executed to start tracing in a user session:

  SQL> EXECUTE

  DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS);

  Which statement is true about the effect of the command?

  A. It allows tracing of exceptions raised by all subprograms executed in the session.
  B. It allows tracing of user-defined exceptions raised by all subprograms executed in the session.
  C. It allows tracing of system-defined exceptions raised by all subprograms executed in the session.
  D. It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.
  D. It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.

• Question 82:

  Identify two strategies against SQL injection. (Choose two.)

  A. Using parameterized queries with bind arguments.
  B. Use subprograms that are run with the definer's right.
  C. Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.
  D. Validate user inputs to functions that use dynamic SQLs built with concatenated values.
  A. Using parameterized queries with bind arguments.
  D. Validate user inputs to functions that use dynamic SQLs built with concatenated values.

• Question 83:

  Which two statements are true about the initialization of internal LOBs? (Choose two.)

  A. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs.
  B. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non-NULL internal LOBs.
  C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs.
  D. The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB () functions, respectively.
  E. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size.
  C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs.
  E. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size.

• Question 84:

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

  A. the trace file component
  B. the analyzer component
  C. the shared library component
  D. the data collection component
  B. the analyzer component

• Question 85:

  The user OE is working on an application that needs to call an external C program multiple times in a single session. However, the extproc.exe file on the server gets accidentally deleted after the OE user connected and made calls to the external C program. Which statement is true about the current session by the OE user?

  A. The session can continue calling the external C program.
  B. The session can call the external C program after republishing it.
  C. The session receives an error for the next call to the external C program.
  D. The session terminates during the subsequent call to the external C program.
  A. The session can continue calling the external C program.

• Question 86:

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

  A. Only varrays must start with the subscript 1.
  B. Only varrays can be used as column types in database tables.
  C. Both associative arrays and varrays must start with the subscript 1.
  D. Both associative arrays and varrays can be used as column types in database tables.
  A. Only varrays must start with the subscript 1.
  B. Only varrays can be used as column types in database tables.

• Question 87:

  Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.)

  A. a PL/SQL program which needs to be recompiled frequently
  B. a PL/SQL program that spends most of the time executing SQL
  C. a PL/SQL program, which performs computation-intensive procedural operations and is recompiled rarely
  D. a PL/SQL program, which is called frequently with the same parameter values by multiple sessions and is recompiled rarely
  A. a PL/SQL program which needs to be recompiled frequently
  B. a PL/SQL program that spends most of the time executing SQL

• Question 88:

  You executed the following command to alter the session parameter:

  SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL';

  Which two statements are true in this scenario? (Choose two.)

  A. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.
  B. All the identifiers declared in compiled program units before altering the parameter settings appear in the *_IDENTIFIER static data dictionary views.
  C. All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.
  D. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects data for the compiled object and stores it in the SYSTEM tablespace.
  A. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.
  C. All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.

• Question 89:

  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 departments.department_name%TYPE INDEX BY

  departments.department_id%TYPE;

  TYPE tb2 IS TABLE OF va1 INDEX BY PLS_INTEGER;

  TYPE tb3 IS TABLE OF scale INDEX BY VARCHAR2(10);

  TYPE tb4 IS TABLE OF DATE INDEX BY DATE;

  TYPE tb5 IS TABLE OF NUMBER INDEX BY CHAR(2);

  ....

  Which of the above are valid definitions for associative arrays? (Choose all that apply.)

  A. tb1
  B. tb2
  C. tb3
  D. tb4
  E. tb5
  B. tb2
  C. tb3

• Question 90:

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

  A. Only varrays must use sequential numbers as subscripts.
  B. Only varrays can be used as column types in database tables.
  C. Both associative arrays and varrays must use sequential numbers as subscripts.
  D. Both associative arrays and varrays can be used as column types in database tables.
  A. Only varrays must use sequential numbers as subscripts.
  B. Only varrays can be used as column types in database tables.