1Z0-151 Exam Questions

You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save What is the behavior of the record being inserted violates a database...

You have been assigned to maintain a Forms application that was designed by a developer who has left the company. The CV_Tools canvas contains several buttons. There is limited spa...

You have written a Forms application that your users log in to with their database login. Which Forms component is utilized first when a user runs the application?

View the Exhibit. You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names. You cannot change the names of the default object...

Which symbol when used in an object's Property Palette, indicates an inherited property that has been changed?

View the Exhibit. You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor. As shown in the Object Navigator in the Exhibit, whic...

Which three statements are true about the PL/SQL Packages panel in the Forms debugger?

The Orders form, whose properties have not been changed from the default, has two non-base table text items to display the sales representative's first and last names. You want to...

Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with t...

When users enter address information, you want them to be able to select the state from a static list of values. You have not used a list of states before, and there is no database...

View the Exhibit. What four facts can you determine by examining the Object Navigator?

The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can b...

An LOV must be displayed several times in your form; therefore, good performance when displaying LOV is essential. In a When-New-Form-instance trigger, you want to save the ID of t...

You must be careful when coding a When-Button-Pressed trigger, because it does not accept restricted built-ins.

Which three are valid ways to populate a display item?

The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit ra...

When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly naviga...

You have a text item in your form named Object1. You want to create Object2 as an exact duplicate of Object1. You want to be able to change the properties of Object2. However if yo...

The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas; the inventories block items are on the CV_inventories content canvas; and Cont...

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

The Order Entry application contains several forms. The inventories form uses an LOV that is based on a record group that queries the Warehouses table to return a warehouse ID. Sev...

View the Exhibit. In the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in t...

You are implementing a JavaBean in a form, the bean has no visible component on the form when invoked, the bean displays an input text where users enter a zip code, the bean has a...

The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form: SELECT orders_seq.NEXTVAL INTO :orders.order_i...

In Forms Builder, the iconic buttons on the form are blank, but when you click Run Form the form appears in the browser with Images in the iconic buttons. What are two things that...

You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the...

The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is run from the Customers form, any queries should be restricted to the customer t...

You are planning the alerts that are needed for your Human Resources application. You wish to display the following in alerts: * A message to inform the user about being at the jus...

You have installed WebLogic and Forms with a default configuration, which has been tested and determined to be correct. After creating a basic form in the Forms Builder, you click...

Which statement is always true about using OPEN_FORM to open multiple forms in an application?

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

View the Exhibit. You have placed the following code in a Post insert trigger on the Orders block: SELECT orders_seq.NEXTVAL INTO :orders.order_id FORM SYS.dual; You have also set...

You are coding a When-Checkbox-Changed trigger. Which statements are available for use in your code?

On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for t...

Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the value...