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 space on the canvas, but the first button is not quite wide enough to display its complete label. In the Layout Editor, you widen the button slightly and find that the width of all the buttons increases so that they now overlap each other.
What could have caused this problem?
Answer : D
Explanation: D (not F): With subclassing you can make an exact copy, and then alter the properties of some objects if desired. If you change the parent class, the changes also apply to the properties of thesubclassed object that you have not altered. However, any properties that you override remain overridden. This provides a powerful object inheritance model.
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 the LOV in a global variable so that you can use it in any code to display the LOV.
Which built-in would you use to get the ID of the LOV?
Answer : B
Explanation: Referencing Objects by Internal ID
Finding the object ID:
lov_id := FIND_LOV('my_lov')
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 values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by
Finance. The default value Fair, because that is the range that applies to most customers.
Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.
Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?
Answer : A
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?
Answer : E
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 single method that returns a short weather forecast for that zip code as a character value.
How can you retrieve that value so that you can display it to the user?
Answer : D
Explanation: When a user interacts with a JavaBean at run time, it usually causes an event to occur.
You can use FBEAN.ENABLE_EVENT to register a listener for the event, so that when the event occurs Forms will fire the When-Custom-Item-Event trigger. In this trigger, you can code a response to the event. The :SYSTEM.CUSTOM_ITEM_EVENT and
SYSTEM.CUSTOM_EVENT_PARAMETERS variables contain the name of the event and information the bean is sending to the form.
The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.
Answer : B
Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown.
In the years past, clerks entered credit ratings manually, which resulted in some of them being mistyped. To improve data entry accuracy you modify the Customers form so that the
Credit_Rating item is a static list item that allows only those four values.
Users report to you that some of the customer records can no longer be accessed when they use the modified Customers form. How can you fix this problem?
Answer : B
Explanation: The important property is the "mapping of other values." This property tells
Oracle Forms how to handle values that are not expected.
Which three are valid ways to populate a display item?
Answer : A,C,D
Explanation:
C: You can use the attachable PL/SQL libraries to implement a flexible message function formessages that are displayed programmatically by the built-in routines MESSAGE orCHANGE_ALERT_MESSAGE, or by assigning a message to a display item from a triggeror procedure.
D: Creating Calculated Items -
Change the Item Type to Display Item.
Set the Calculation Mode property to Formula.
Set the Formula property to the required formula.
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 the customer's orders, and you do not want customers to be able to query for another customer's orders.
You code the following triggers:
When-New Form instance on the Orders form:
GO_BLOCK('orders');
EXECUTE_QUERY;
You also have a button in the Control block labeled Query Orders with a When-Button
Pressed trigger that has the same code as the When New-Form instance trigger.
To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.
What is the best way to correct this issue to ensure that the customer can never query another customer's orders?
Answer : B
Explanation:
Note: EXECUTE_QUERY procedure -
Clears the current block, opens a query, and fetches anumber of selected records. If there are changes tocommit, Forms Builder prompts the operator to committhem before continuing EXECUTE-QUERYprocessing
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 be printed with the local printer.
Which WebUtil package would you use to implement this requirement?
Answer : C
Explanation:
Note: Performing OLE Automation on the Client
You can use any OLE2 package on the client by prefixing it with CLIENT_. You can see the list of the OLE2 package procedures and functions in the Forms Builder ObjectNavigator under the Built-in Packages node.
Note 2: With WebUtil, you can do the following on the clientmachine: open a file dialog box, read and write image or text files, execute operating system commands, perform OLE automation, and obtain information about the client machine
View the Exhibit.
Answer : C
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?
Answer : B
View the Exhibit.
Answer : B,C,G,H
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 rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.
Answer : F
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 that item that uses the GO_ITEM built-in to navigate to the next item.
What happens when you run the form from Forms Builder?
Answer : C