1Z0-144 試験問題を無料オンラインアクセス

The STRING_TAB table has the following structure:

View the Exhibit and examine the code.

What is the outcome on execution?

• A.It does not display any of the MEMS_PUTPUT messages and gives an error because a
  transaction control statement cannot be used in the exception section of a procedure.
• B.It displays only
  Output buffer not long enough, and exits the anonymous block.
• C.It displays only
  This is my test string. - Because EXCEPTION should have been defined in the anonymous
  block to get the error message.
• D.It displays
  Output buffer not long enough.
  This is my test string.-.

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)

• A.It can be a before or an after trigger.
• B.It should be a statement-level trigger.
• C.It should be a before trigger.
• D.It should be a row-level trigger.
• E.It should be an after trigger.

Which two statements are true about the exit statement encountered in loop? (Choose two)

• A.The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
• B.The loop completes immediately and control passes to the statement after end loop
• C.The PL/SQL block execution terminates immediately after the exit statement.
• D.The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the code.

EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

• A.call in line 9
• B.call in line 7
• C.call in line 6
• D.call in line 8

View the Exhibit and examine the structure of the EMP table.

Which stages are performed when the above block is executed? (Choose all that apply)

• A.Bind
• B.Execute
• C.Fetch
• D.Parse