Oracle 1Z0-146 Online Practice Questions and Exam Preparation

Oracle 1Z0-146 Online Questions & Answers

• Question 31:

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

  A. Only associative arrays can hold an arbitrary number of elements.
  B. Only nested tables can be used as column types in database tables.
  C. Both associative arrays and nested tables can hold an arbitrary number of elements.
  D. Both associative arrays and nested tables can be used as column types in database tables.
  B. Only nested tables can be used as column types in database tables.
  C. Both associative arrays and nested tables can hold an arbitrary number of elements.

• Question 32:

  Which two statements are true about the tuning of PL/SQL code? (Choose two.)

  A. Redundant SQL statements in PL/SQL code should be avoided.
  B. Implicit data type conversion in PL/SQL code can improve performance.
  C. Usage of the NOT NULL constraint in PL/SQL code can degrade performance.
  D. If you have one PL/SQL program unit instead of multiple smaller executable sections, performance can be improved.
  A. Redundant SQL statements in PL/SQL code should be avoided.
  C. Usage of the NOT NULL constraint in PL/SQL code can degrade performance.

• Question 33:

  Which two statements are true about the working of fine-grained access? (Choose two.)

  A. Security policies can be associated only with tables, but not with views.
  B. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.
  C. User statements are dynamically modified by the Oracle server through a security policy function.
  D. Fine-grained access control policies always remain in effect until they are dropped from a table or view.
  B. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.
  C. User statements are dynamically modified by the Oracle server through a security policy function.

• Question 34:

  In which two situations is the body of a result-cached function executed? (Choose two.)

  A. if the memory allocated for the result cache is increased
  B. if a session on this database instance invokes the function with the same parameter values
  C. if the first time a session on this database instance invokes the function with a parameter value
  D. if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function
  C. if the first time a session on this database instance invokes the function with a parameter value
  D. if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function

• Question 35:

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

  A. Only associative arrays can hold an arbitrary number of elements.
  B. Only associative arrays can use numbers and strings for subscripts.
  C. Both associative arrays and nested tables can hold an arbitrary number of elements.
  D. Both associative arrays and nested tables can use numbers and strings for subscripts.
  B. Only associative arrays can use numbers and strings for subscripts.
  C. Both associative arrays and nested tables can hold an arbitrary number of elements.

• Question 36:

  Which two statements are true about BFILES? (Choose two.)

  A. BFILES support only sequential reads.
  B. BFILES can be used as attributes in an object type.
  C. When LOB is deleted, the corresponding physical file is automatically deleted.
  D. The RMAN backup automatically backs up the BFILE locators and the corresponding physical files.
  E. The physical file corresponding to a BFILE locator must reside on the file system that is accessible from the server where the database exists.
  B. BFILES can be used as attributes in an object type.
  E. The physical file corresponding to a BFILE locator must reside on the file system that is accessible from the server where the database exists.

• Question 37:

  Which statement describes the purpose of the plshprof command?

  A. It produces HTML output from raw profiler output.
  B. It produces HTML output from profiler tables in the database.
  C. It populates profiler tables in the database from raw profiler output.
  D. It produces raw profiler output on the most recently run applications.
  A. It produces HTML output from raw profiler output.

• Question 38:

  View Exhibit1 and examine the structure of the EMPLOYEES table.

  View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in department ID 60.

  

  Which statement is true about the outcome?

  A. It generates an error because RECORD type cannot be used with varrays.
  B. It generates an error because BULK COLLECT cannot be used with varrays.
  C. It executes successfully only if department ID 60 has five or less than five employees.
  D. It executes successfully even if department ID 60 has more than five employees by dynamically extending the varray.
  C. It executes successfully only if department ID 60 has five or less than five employees.

• Question 39:

  Examine the structure of the TEST_DETAILS table: Name Null? Type

  TEST_ID NUMBER

  DESCRIPTION CLOB

  DESCRIPTION data was entered earlier and saved for TEST_ID 12.

  You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION

  column for TEST_ID 12:

  DECLARE

  clob_loc CLOB;

  buf CHAR(12);

  BEGIN

  SELECT description INTO clob_loc FROM test_details WHERE test_id = 12 ;

  buf := '0123456789';

  DBMS_LOB.WRITEAPPEND(clob_loc,DBMS_LOB.GETLENGTH(buf), buf);

  COMMIT;

  END;

  /

  It generates an error on execution.

  What correction should you do to achieve the required result?

  A. WRITEAPPEND must be replaced with APPEND.
  B. The BUF variable data type must be changed to CLOB.
  C. FOR UPDATE must be added to the SELECT statement.
  D. The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND.
  C. FOR UPDATE must be added to the SELECT statement.

• Question 40:

  Identify three guidelines for the DBMS_ASSERT package. (Choose three.)

  A. Prefix all calls to DBMS_ASSERT with the SYS schema name.
  B. Embed DBMS_ASSERT verification routines inside the injectable string.
  C. Escape single quotes when you use the ENQUOTE_LITERAL procedure.
  D. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions.
  E. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package.
  A. Prefix all calls to DBMS_ASSERT with the SYS schema name.
  C. Escape single quotes when you use the ENQUOTE_LITERAL procedure.
  D. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions.