Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 51:

  Which three are true about DDL triggers? (Choose three.)

  A. They cannot include the WHEN clause.
  B. They must be created in an enabled state.
  C. They can be fired when a table is truncated.
  D. They fire only when a DDL statement is executed by the owner of the trigger.
  E. They can be fired either before or after a DDL statement executes.
  F. They can be fired when a privilege is granted to a user.
  G. They must be created in a disabled state.
  C. They can be fired when a table is truncated.
  D. They fire only when a DDL statement is executed by the owner of the trigger.
  E. They can be fired either before or after a DDL statement executes.

• Question 52:

  Which statement is true about user-defined records?

  A. They can be returned from a function.
  B. Field types must match column types.
  C. The number of fields must match the number of columns in a table.
  D. Field names must match selected column names.
  C. The number of fields must match the number of columns in a table.

• Question 53:

  Which block of code displays the error message "Incorrect price value"?

  

  

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

  ---

  Explanation/Reference:

• Question 54:

  Examine these statements which execute successfully:

  

  Which anonymous block executes successfully?

  

  

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

  ---

  Explanation/Reference:

• Question 55:

  Which is true about the PLSCOPE_SETTINGS parameter?

  A. It is deprecated in Oracle 12c.
  B. It can be used to obtain information about all identifiers when compiling a procedure.
  C. It can be used to control execution of specific portions of the PL/SQL code conditionally.
  D. It can be used to control a user's privileges on PL/SQL objects at run time.
  B. It can be used to obtain information about all identifiers when compiling a procedure.

• Question 56:

  Which is true about counter variables in a FOR loop?

  A. It must explicitly be declared.
  B. It can be modified in the body of the loop.
  C. It cannot be NULL.
  D. It is accessible outside the body of the loop.
  C. It cannot be NULL.

• Question 57:

  Examine these statements and output:

  

  The procedure is created successfully.

  

  User ora2 has password ora2 in pdb1.

  Which script will execute successfully?

  

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

  ---

  Explanation/Reference:

• Question 58:

  Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

  A. CREATE
  B. DROP
  C. UPDATE
  D. SELECT
  E. DELETE
  F. ALTER
  G. INSERT
  C. UPDATE
  D. SELECT
  G. INSERT

• Question 59:

  Examine the SH.PRODUCTS table:

  

  A row exists in SH.PRODUCTS with PDT_ID = 1. Now, examine this code and output executed by SH:

  

  Now, examine this block of code:

  

  Which error message(s) does it display on execution by user SH?

  A. Error in inner block
  B. Error in inner block Error in outer block
  C. Error in inner block Error in calling block
  D. Error in inner block Error in outer block Error in calling block
  A. Error in inner block

• Question 60:

  Which three are true about user-defined functions? (Choose three.)

  A. They can be used in ORDER BY and GROUP BY clauses.
  B. They can be executed as standalone commands.
  C. They must be defined with at least one parameter.
  D. They need not return any values.
  E. They can appear in the select list of a SELECT statement.
  F. Functions can call only other functions.
  G. They can be used in CONNECT BY and START WITH clauses.
  A. They can be used in ORDER BY and GROUP BY clauses.
  E. They can appear in the select list of a SELECT statement.
  G. They can be used in CONNECT BY and START WITH clauses.