Free Oracle 1Z0-149 Exam Dumps Questions & Answers

Which is true about EXIT and CONTINUE statements?

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

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 Error in outer block
• B.  Error in inner block Error in calling block
• C.  Error in inner block
• D.  Error in inner block Error in outer block Error in calling block

Which two are true about implicit data type conversion? (Choose two.)

• A.  RAW data types are always implicitly converted to a CLOB when used in a query.
• B.  ROWIDS are always implicitly converted to a number when used in a query.
• C.  Implicit data type conversion can negatively impact performance.
• D.  Collections can be implicitly converted to records.
• E.  Comparison between character value and a number value always implicitly converts the character value to the number data type.

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

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

Which statement is true about user-defined records?

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