Header Ads Widget

Responsive Advertisement

Module 08: Creating LOVs and Editors

Creating LOVs and Editors


01. The DBA has added STATE column to the CUSTOMERS table and has asked you to add a Corresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation. 

Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation director for those customers outside the region. 

Which style of list item will you create for the State item? 

A. A poplist 

B. A Llist 

C. A combo box. 

D. There is no style of list item that allows users to enter values that are not on the list.  

Answer: C

02. Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that data entry clerks can populate the RATING column. 

To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item. With the Customers block selected in the Layout Editor, you use the radio button to create three radio buttons on the canvas. You then set the labels (Poor, Good, and Excellent) and values (1, 2, and 3) for the radio buttons. You set the name of the radio group to RATING, its Data Type to Number, and its Database column to Rating. 

You run the form to test it. When you execute a query, however, no records are returned, although there are many customer records in the database. 

What can you do to make the query return the records? 

A. Set the Mapping of Other Values property for the radio group to Null. 

B. Create a fourth radio button for an undetermined credit rating and leave its value blank. 

C. Create a fourth radio button for an undetermined credit rating and explicitly set its value to Null. 

D. Choose a different type of input, because radio groups do not allow query of Null values. 

Answer: A

03. Exhibit: 

 


You have created three list items, each of which is in a different list style. You have defined the same four list elements for each list item. The exhibit depicts the list items at run time after user input. 

What is the list style of each list item? 

A. List 1: Combo box; List 2: poplist; List 3: Tlist 

B. List 1: poplist ;List 2: Combo box; List 3: Tlist 

C. List 1: poplist; List 2: Tlist; List 3: Combo box 

D. List 1: Tlist; List 2: Combo box; List 3: poplist 

E. List 1: Combo box; List 2: Tlist; List 3: poplist 

F. List 1: Tlist; List 2: poplist; List 3: Combo box 

Answer: B

04. Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that credit ratings can be recorded. 

To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item. 

With the items node of the Customers block selected in the Object Navigator, you click Create. You then open the Property Palette for the new item and set properties as follows: 

Name: RATING 

Item Type: Radio Group 

Data Type: Number 

Column Name: Rating 

Canvas: CUSTOMER_CV 

You open the CUSTOMER_CV canvas in the Layout Editor, but the Rating item does not appear. 

How can you get the Rating item to appear on the canvas? 

A. Create a radio button for the radio group. 

B. Set the Visible property of the Rating item to Yes. 

C. Delete the radio group and create it in the Layout Editor because a radio group that is created in the Object Navigator will not appear on a canvas. 

D. Change the width of the Rating item because the default width of a radio group is 0, so it does not appear on the canvas.

Answer: A

05. Exhibit: 

The Credit_Rating in the Customers block of an Order Entry form must be restricted to three possible values: 

Good, Bad, 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 these three values. 

You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has bad credit. The check box should not be selected if the customer 's credit rating is good or undetermined. 

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

CUST_ID LAST_NAME FIRST_NAME CREDIT_RATING 

1001 Gamer Pam 

1002 Wallace Sheila 

1003 Maslen Glenn Bad 

The first two records show an undetermined credit rating, although your intention was to set the value to Good for those customers. 

What change must be you make in the properties of the Credit_Rating item to enable values of Good, Bad, 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 to Good and the Value When Unchecked property to Null. 

D. Change the Initial Value property to Good and the Check Box Mapping of Other Values property to Null. 

E. Change the Initial 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. 

Answer: F

06. The Orders form has two Record Groups: the SHIP Record Group that was created at design time, and the SOLD Record Group that was created at run time. 

You are required to write a Program Unit that will delete both Record Groups. 

Which two statements describe your situation? (Choose two) 

A. You cannot delete Record Group SOLD at run time. 

B. You cannot delete Record Group SHIP at run time. 

C. You should delete Record Group SOLD with built-in DELETE_GROUP('SOLD'); 

D. You should delete Record Group SHIP with built-in DELETE_GROUP('SHIP');  

E. You should delete Record Group SOLD with built-in DELETE_GROUP_ROW(SOLD',ALL_ROWS); 

F. You should delete Record Group SHIP with built-in DELETE_GROUP_ROW(SHIP',ALL_ROWS);

Answer: B,C

07. Exhibit: 

 

You want to create a menu item to enable users to sort the tabular display of a form either by customer ID, last name, or department ID. You decide to create a radio group as shown in the exhibit. 

Which statement about this radio group is true? 

A. You must create the radio group before creating Radio menu items for it. 

B. You must create a Radio menu item before the radio group is created. 

C. You must name the radio group the same as the submenu name so that it will be associated with that submenu. 

D. You must name the radio group Sort, the same as the submenu label, so that it will be associated with that submenu. 

Answer: B

08. You created a LOV based on the query Record Group PRODUCTS. The LOV is attached to the :PROD.DESC text item. The validate from List property is set to No for the :PROD.DESC Text item. Which built-in can you call to execute the query associated with the Record Group? 

A. SHOW_LOV 

B. ADD_GROUP_ROW 

C. ADD_GROUP_COLUMN 

D. SET_GROUP_SELECTION 

E. CREATE_GROUP_FORM_QUERY 

F. VALIDATE(ITEM_SCOPE) when :PROD.DESC is the current item. 

Answer: A

The show_lov (answerA) will be correct as it would invoke the lov and answer F is wrong as the set validate is set to no so will not validate from list and thus not fire the lov (thus not invoking the record group.) 

09. Which two statements are true of a Query Record Group? (Choose two) 

A. The Record Group is associated with a query. 

B. The Record Group can be created only at run time. 

C. The Record Group can be created and modified only at design time. 

D. The Record Group can be created and modified at design time or at run time. 

E. The query associated with this Record Group can be defined only at design time. 

F. The query associated with this Record Group can be modified only at design time. 

G. The query associated with this Record Group can be modified only at run time. 

Answer: A,D

10. The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. 

You want to update the Order Entry form to display the additional data. You open the Layout Editor for the 

canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. You use the text 

item tool to create a new text item on the canvas, then open its Property Palette and set the Name property to 

ORDER_STATUS and the Column Name property to Order_Status. 

When you run the form to test it, you receive the error "FRM 40505 ORACLE error unable to perform query". 

What could be the cause of this error? 

A. You did not change the default value for the Data Type property of the Order_Status text item. 

B. You did not modify the WHERE clause of the Orders block to include the ORDER_STATUS column. 

C. You did not change the default value for the Database Item property of the Order_Status text item. 

D. You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item. 

E. You did not define the Column Name in uppercase so that the column value can be retrieved from the database. 

Answer: D

11. Which two statements about a Non-Query Record Group are true? (Choose two) 

A. The Record Group is associated with a query at run time or at design time. 

B. The Record Group can be created and modified only at run time. 

C. The Record Group can be created and modified only at design time. 

D. The Record Group can be created and modified at design time or at run time. 

E. You can modify the structure of this Record Group by adding columns and rows. 

F. The Record Group is associated with a query only at design time. 

Answer: B,E

12. Exhibit: 

 


You are developing a form for a family-oriented video store. The form will run in a query-only mode in a customer kiosk that displays information about movies that are available to rent. The Rating item on the form shown in the upper portion of the exhibit displays the rating of the movie: G, PG, R, or X. Your customers are not interested in all these values, but they do want to see if the film is suitable for the whole family (rated G). You decide to change the item to a check box to be displayed as shown in the lower portion of the exhibit. You want users to be able to query any movies, but only those with a G rating will have the check box selected. 

Which properties of the Rating item must you modify to make this change? 

A. Item Type, Label, Value When Checked, Checkbox Mapping of Other Values, Prompt 

B. Item Type, Value When Checked, Value When Unchecked, Prompt 

C. Label, Initial Value, Value When Checked, Value When Unchecked, Prompt 

D. Label, Initial Value, Value When Checked, Checkbox Mapping of Other Values, Prompt 

E. Data Type, Label, Value When Checked, Value When Unchecked, Checkbox Mapping of Other Values, Prompt 

F. You cannot use a check box for this application because there are more than two possible values for the item. 

Answer: E

13. Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that credit ratings can be recorded. To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item. You want to allow for an undetermined (Null) credit rating, and users should be able to update the credit rating from a value to an undetermined rating How can you implement this? 

A. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to Null 

B. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to one of the credit rating values. 

C. Create four radio buttons, and leave blank the value for the undetermined credit rating 

D. Choose a different type of input item, because radio groups do not allow entry and update of null values

Answer: C

Post a Comment

0 Comments