1Z0-149 무료 덤프문제 온라인 액세스

Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

• A.15000
• B.5000
• C.10000
• D.2500

Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

• A.There are no compilation warnings or errors.
• B.A severe compilation warning is generated.
• C.An information compilation warning is generated.
• D.A performance compilation warning is generated.
• E.It fails compilation.

Which is true about EXIT and CONTINUE statements?

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

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

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

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.Comparison between character value and a number value always implicitly converts the character value to the number data type.
• D.Implicit data type conversion can negatively impact performance.
• E.Collections can be implicitly converted to records.