Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 31:

  Examine this DECLARE section:

  

  Which line will cause an error upon execution?

  A. line 5
  B. line 3
  C. line 2
  D. line 4
  E. line 6
  E. line 6

• Question 32:

  Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

  A. PACKAGES
  B. VARIABLES
  C. ANONYMOUS BLOCK
  D. TRIGGER BODY
  E. DATABASE LINKS
  A. PACKAGES
  E. DATABASE LINKS

• Question 33:

  Which two are true about packages? (Choose two.)

  A. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
  B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
  C. Package specifications can be compiled without their bodies.
  D. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
  E. A package definition must have a specification and body.
  A. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
  C. Package specifications can be compiled without their bodies.

• Question 34:

  Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

  A. The actual parameters must be specified in the same order as the formal parameters are declared.
  B. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
  C. Only trailing optional parameters can be omitted in the invocation call.
  D. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
  E. Any optional parameters can be omitted in the invocation call.
  A. The actual parameters must be specified in the same order as the formal parameters are declared.
  E. Any optional parameters can be omitted in the invocation call.

• Question 35:

  Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

  A. When using the RETURNING INTO clause, the data returned can be only single column or expression.
  B. The RETURNING INTO clause and bulk binds may not be used together.
  C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
  D. The RETURNING INTO clause returns column values for rows affected by DML statements.
  E. The RETURNING clause can be used for remote or parallel deletes.
  C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
  E. The RETURNING clause can be used for remote or parallel deletes.

• Question 36:

  Which two are true about exception handling? (Choose two.)

  A. Internally defined exceptions can be handled only by the OTHERS exception handler.
  B. All declared exceptions are raised implicitly by the runtime system.
  C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
  D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
  E. Predefined exceptions are globally declared in the standard package.
  C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
  E. Predefined exceptions are globally declared in the standard package.

• Question 37:

  Examine these statements from a block of code: Which two are true? (Choose two.)

  

  A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
  B. Only the PRICE column can be updated in the PRODUCTS table.
  C. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
  D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
  E. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
  A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
  D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

• Question 38:

  Which two are true about INDEX-BY tables? (Choose two.)

  A. The index can be integer or string.
  B. The index can be integer only.
  C. INDEX-BY table types can be created in PL/SQL blocks only.
  D. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
  E. INDEX-BY table types can be created with the CREATE TYPE statement.
  A. The index can be integer or string.
  C. INDEX-BY table types can be created in PL/SQL blocks only.

• Question 39:

  Examine this anonymous block of code:

  

  Which two statements are true about the results of executing it? (Choose two.)

  A. It will set all salaries to 0 if it executes successfully.
  B. It will always return a compile time error because it lacks an EXCEPTION section.
  C. It might return a run time error depending on who invokes it.
  D. It will always automatically initialize v_raise.
  E. It will set all salaries to NULL if it executes successfully.
  F. It will always return a run time error because v_raise is not initialized.
  D. It will always automatically initialize v_raise.
  E. It will set all salaries to NULL if it executes successfully.

• Question 40:

  Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

  A. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
  B. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
  C. A deterministic function's results always depend on the state of session variables.
  D. The NOCOPY hint asks the compiler to pass the actual parameters by value.
  E. A function is deterministic if it always returns the same result for a specific combination of input values.
  F. The PARALLEL_ENABLE clause can be specified for a nested function.
  G. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
  B. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
  E. A function is deterministic if it always returns the same result for a specific combination of input values.
  G. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.