Online Access Free 1z0-151 Exam Questions

You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.
How should you investigate the source of the problem?

• A.Check the Navigation properties of the Orders block that have non-default values.
• B.Check the Pre-Text-Item and Post-Text-Item triggers, because users may be encountering a navigation trap.
• C.Check the Navigation properties of the items in the Orders block that have non-default values.
• D.Check the Navigation properties of the Order Items block that have non-default values.
• E.Check that the items in the Order Items block are enabled.
• F.Check the Navigation properties of the form that have non-default values.

You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:
IF NOT FORM_SUCCESS THEN
MESSAGE ('Stored Procedure failure');
RAISE FORM_TRIGGER_FAILURE;
END IF;
You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?

• A.FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.
• B.You cannot test for failure of a stored procedure, because database errors are transparent to Forms.
• C.You must test for FORM_FAILURE when testing for failure of a stored procedure.
• D.You must test for FORM_FATAL when testing for failure of a stored procedure.
• E.You must handle database errors in an exception clause of the trigger.

The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?

• A.Define multiple content canvases and display them in multiple modal windows.
• B.Define multiple content canvases and display them in the same modeless window.
• C.Define multiple content canvases; display one in a modeless window and the others in modal windows.
• D.This is not possible because items from a single block must be displayed on the same canvas and window.
• E.Define multiple content canvases and display them in multiple modeless windows.

To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.
You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?

• A.Validation for the Customer_Id item failed.
• B.The form is in Enter-Query mode.
• C.The item is using an LOV for validation.
• D.The validation unit of the form needs to be changed.
• E.The MESSAGE () built-in is not allowed in validation triggers.
• F.There is a syntax error in the call to the MESSAGE() built-in.

You have coded the following When Button Pressed trigger:
EXECUTE_QUERY;
MESSAGE ('Query executed on block');
MESSAGE ('click next to navigate the next record');
When the user clicks the button, how is the message "Query executed on block" displayed?

• A.as a system message on the status line
• B.as a system message in an application alert
• C.as a system message in a system alert
• D.as an application message on the status line
• E.as an application message in a system alert
• F.as an application message in an application alert