Oracle 1Z0-151 dumps - 100% Pass Guarantee!

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.

You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:

The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?

A. Change the initial Value property to Good.

B. Change the Check Box Mapping of Other Values property to Not Allowed.

C. Change the initial Value property to Good and the Value When Unchecked property to Null.

D. Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.

E. Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.

F. Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.

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

A. PL/SQL variables

B. Form items

C. global variables

D. system variables

E. parameters

You wish to use a javaBean in a form. This javaBean has no visible component.

You use the Layout Editor to create a bean area item that implements this JavaBean. You want to be able to see the bean area item in the Layout Editor so that you can easily interact with it at design time.

What can you do to ensure that the bean area item does not appear on the form at run time?

A. Set its Visible property to No.

B. Set its Height and Width properties to 1.

C. Set its Implementation class programmatically at run time.

D. You do not have to do anything; if Implementation Class does not display a visible component, the bean area does not show at run time.

E. You cannot avoid displaying the Bean area at run time.

You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:

GO_BLOCK('orders'); EXECUTE_QUERY;

This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?

A. Set the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.

B. Add the following as the first of the key-Exqry trigger to Yes. SYSTEM.mode := 'NORMAL';

C. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK ('orders'); ENTER_QUERY;

D. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block: ENTER_QUERY; GO_BLOCK ('orders');

E. Change the key-Exqry trigger to: IF : SYSTEM.MODE := 'ENTER-QUERY' THEN GO_BLOCK ('orders'); EXECUTE_QUERY; ELSE MESSAGE ('you cannot execute a query for the Order_Items block'): END IF; Define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK ('orders'); ENTER_QUERY

F. Change the Key-Exeqry trigger to: IF :SYSTEM.MODE != 'ENTER-QUERY' THEN GO_BLOCK('orders'); EXECUTE_QUERY; ELSE MESSAGE ('You cannot execute a query in this block'); ENTER_QUERY; GO_BLOCK ('orders');

G. You cannot change this behavior, but you should use the On-Message trigger to display a more meaningful message.

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?

A. Forms Client (applet)

B. Forms Runtime

C. Forms Servlet

D. Forms Listener Servlet