Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 21:

  Sequence S and table PRODUCTS exist in your schema.

  Examine the table description:

  

  Now, examine this block of code:

  

  Which two lines each result in a compilation error? (Choose two.)

  A. line 1
  B. line 6
  C. line 8
  D. line 2
  E. line 3
  F. line 7
  A. line 1
  B. line 6

• Question 22:

  Which three are true about functions and procedures? (Choose three.)

  A. The ACCESSIBLE BY clause can be used only for procedures.
  B. In a function, every execution path must lead to a RETURN statement.
  C. Both can have only constants as actual parameters for IN mode parameters.
  D. Both can be invoked from within SQL statements.
  E. In a procedure the RETURN statement cannot specify an expression.
  F. In a function every RETURN statement must specify an expression.
  B. In a function, every execution path must lead to a RETURN statement.
  E. In a procedure the RETURN statement cannot specify an expression.
  F. In a function every RETURN statement must specify an expression.

• Question 23:

  Which three are true about anonymous blocks and subprograms? (Choose three.)

  A. Named subprograms cannot be called from other packages.
  B. PROCEDURE subprograms can accept parameters.
  C. A FUNCTION subprogram must return one or more values.
  D. Anonymous blocks cannot use packaged variables.
  E. Named subprograms are stored in the database server.
  F. Anonymous blocks must always start with the Declare keyword.
  G. FUNCTION subprograms must be called and passed through one or more parameters.
  B. PROCEDURE subprograms can accept parameters.
  C. A FUNCTION subprogram must return one or more values.
  E. Named subprograms are stored in the database server.

• Question 24:

  Which is true about EXIT and CONTINUE statements?

  A. They can be used in any type of loop.
  B. They must have a WHEN condition.
  C. They have the same effect on the execution of a loop.
  D. They must use labels.
  A. They can be used in any type of loop.

• Question 25:

  The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10). Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  A. Option A
  C. Option C

  ---

  Explanation/Reference:

• Question 26:

  Examine this table in the SH schema:

  

  User SH executes this code:

  

  The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000. With which option must "---placeholder" be replaced?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  A. Option A

  ---

  Explanation/Reference:

• Question 27:

  For which three SYSTEM EVENTS can triggers be created? (Choose three.)

  A. DDL
  B. AFTER AUDIT
  C. BEFORE ANALYZE
  D. SHUTDOWN
  E. SERVERERROR
  F. STARTUP
  G. BEFORE GRANT
  D. SHUTDOWN
  E. SERVERERROR
  F. STARTUP

• Question 28:

  Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

  A. It can be used in the declaration of object types.
  B. It must be specified in the heading of a package specification.
  C. The check is enforced by this clause for direct access and access through dynamic SQL.
  D. It can be used for individual procedures and functions declared in a package specification.
  E. It must be specified in the heading of a package body.
  A. It can be used in the declaration of object types.
  D. It can be used for individual procedures and functions declared in a package specification.

  ---

  Explanation/Reference:

  https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

• Question 29:

  Which three statements are true about passing parameters to subprograms? (Choose three.)

  A. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
  B. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
  C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
  D. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
  E. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
  F. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
  G. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
  B. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
  C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
  D. The actual parameter must be a variable when calling a subprogram with an OUT parameter.

• Question 30:

  Which three statements can process a dynamic multi-row query? (Choose three.)

  A. DECLARE
  B. OPEN
  C. INTO
  D. OPEN-FOR
  E. FETCH
  F. WHEN
  G. CLOSE
  D. OPEN-FOR
  E. FETCH
  G. CLOSE