Online Access Free 1z0-151 Practice Test

Which four types of variables must have their names preceded by a colon when they are referenced in trigger code?

• A.global variables
• B.system variables
• C.PL/SQL variables
• D.parameters
• E.Form items

View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!');
end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

• A.IF ERROR_CODE = 40509 THEN
  MESSSAGE (SQLERRM);
  END IF;
• B.IF ERROR_CODE = 06512 THEN
  MESSSAGE (SQLERRM);
  END IF;
• C.IF ERROR_CODE = 06512 THEN
  MESSSAGE(DBMS_ERROR_TEXT);
  END IF;
• D.IF ERROR-CODE = 20101 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF;
• E.IF ERROR_CODE = 20101 THEN
  MESSSAGE(SQLERRM);
  END IF;
• F.IF ERROR_CODE = 40509 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF

To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?

• A.When-New-Block-instance
• B.Post-Query
• C.Pre-Query
• D.When-New-Form-instance
• E.On-Query

You have designed a form with two content canvases. The window for the first canvas was created implicitly, and you have not changed its default properties.
You want users to be able to navigate between the canvases easily while viewing both simultaneously. Therefore, you create a second window, changing only its name from the default properties.
However, when you test the form, you find that you are unable to close either window.
What must you do to provide this functionality?

• A.Set Hide on Exit to Yes for both windows.
• B.Set Close Allowed to Yes for both windows.
• C.Change the second window to a modal window.
• D.Code a When-Window-Closed trigger for each window.

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; display one in a modeless window and the others in modal windows.
• C.Define multiple content canvases and display them in multiple modeless windows.
• D.Define multiple content canvases and display them in the same modeless window.
• E.This is not possible because items from a single block must be displayed on the same canvas and window.