 |
| Run Time Messages and Alerts |
01. How can you programmatically determine which button a user pressed to respond to an alert?
A. Use the GET_ALERT_PROPERTY function.
B. Use the GET_ALERT_BUTTON_PROPERTY function.
C. Check the value returned by the SHOW_ALERT function to see if it is 1, 2, or 3.
D. Check the value returned by the SHOW_ALERT function to see if it is ALERT_BUTTON1, ALERT_BUTTON2, or ALERT_BUTTON3.
Answer: D
02. Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two)
A. You cannot raise FORM_TRIGGER_FAILURE in an exception handler.B. FORM_TRIGGER_FAILURE does not cause an unhandled exception.
C. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
D. If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by another trigger, the calling trigger automatically fails.
Answer: B, C
03. What type of message indicates a Forms message that cannot be suppressed?
A. A Busy message
B. A level 0 message
C. A Working message
D. A level 25 message
E. A level 50 message
F. A message with a level less than 0
G. A message with a level greater than 25
H. A message with a level greater than 50
Answer: G
04. You are running a multiple-form application. The Customers form invoked the Orders form. When the Orders form launches, it displays orders for only the active customer from the Customers form.Forms exchange data with the :GLOBAL.CUSTOMER_ID variable.
The Orders form should be restricted to orders for the current customer only the first time a query is issued after invoking the Orders form. Which built-in helps you to do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?
A. SET_APPLICATION_PROPERTY
B. SET_FORM_PROPERTY
C. SET_BLOCK_PROPERTY
D. SET_RECORD_PROPERTY
Answer: C
05. Which built-in allows you to dynamically change the alert message text?
A. SET_ALERT_MESSAGE
B. SET_ALERT_PROPERTY
C. CHANGE_ALERT_PROPERTY
D. CHANGE_MESSAGE_ALERT
Answer: B
06. You created a master-detail form, but users are distracted by the default message that displays during each detail query to show that processing is taking place. Which line of code would you use to keep that message from displaying?
A. SYSTEM.MESSAGE_LEVEL:=’0’;
B. SYSTEM.MESSAGE_LEVEL:=’25’;
C. SYSTEM.SUPPRESS_WORKING :=’TRUE’;
D. SYSTEM.SUPPRESS_WORKING :=’FALSE’;
Answer: C
07. Which data type does the SHOW_ALERT built-in return?
A. CHAR
B. NUMBER
C. VARCHAR2
D. BOOLEAN
Answer: B
08. Which statement about system messages is true?
A. The message level and severity are unrelated.
B. More critical system messages have higher severity levels.
C. You can suppress messages as long as the level is greater than 25.
D. A message level of 0 (zero) suppresses all except the most critical messages.
Answer: B
9. Which technique retrieves the error number when explicit DML fails?
A. SQLCODE in an On-Error trigger.
B. SQLCODE in an exception handler.
C. DBMS_ERROR_CODE in an On-Error trigger.
D. DBMS_ERROR_CODE in an exception handler.
Answer: B
0 Comments