 |
| Working with Text Items |
01. Which two statements define a Static Record Group? (Choose two)
A. The Record Group can be created only at run time.
B. The Record Group is not associated with a query.
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 at run time.
F. You can modify the structure of this Record Group by associating it with a query at run time.
Answer: B,C
02. In the Human Resourced form, you created an LOV based on a record group. The record group query selects the job title and job ID from the JOBS table, which contains the following records:
JOB_TITLE JOB_ID
- -------------
Accountant FI_ACCOUNT
Accounting Manager AC_MGR
Administration Assistant AD_ASST
President AD_PRES
Programmer IT_PROG
Public Accountant AC_ACCOUNT
Purchasing Clerk PU_CLERK
Purchasing Manager PU_MAN
Sales Manager SA_MAN
Sales Representative SA_REP
The Job_ID value is returned to the Employees.Job_Id item in the form. You attach the LOV to the Job_ID item and set its Validate from List property to yes, You run the form to test it. You enter "Pro" (without the quotes) into the Job_ID item.
What is the behavior when you press the Tab key?
A. The LOV will appear.
If the user clicks Cancel, the cursor will move to the next navigable item in the form.
B. The LOV will appear.
If the user clicks Cancel, the cursor will remain in the Job_ID item and an error message will appear.
C. The LOV will not appear. The Job_ID item will be assigned the value IT_PROG.
The cursor will move to the next navigable item in the form.
D. The LOV will not appear. The Job_ID item will be assigned the value Programmer.
The cursor will move to the next navigable item in the form.
E. The LOV will not appear. The cursor will remain in the Job_ID item and an error message will display.
Answer: C
03. You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets block of the form that has an LOV whose record group uses the following query.
SELECT event_name, event_date
FROM events
ORDER BY event_date
In the Choose_Event block of the form, you want users to be able to select an event name into an Event_Name item. The event name will be selected from a LOV that is sorted by the name of the event.
You do not want to modify either the LOV or the record group at run time.
Which statement is true for the LOV and the record group as specified at design time?
A. You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group.
B. You must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same
record group.
C. You can use the same LOV and record group for the Choose_Event.Event_Name item that you used for the
Tickets.Event_Date item.
D. You can use the same LOV for both items, but you should specify that each item must use a different record
group for the LOV.
Answer: A
04. The user must be able to invoke a list of values for valid sales representative in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Rep Id field.
The text item has these properties set:
- Required: Yes
- List of Values: SALES_REP_LOV
- Validate from List: No
. . .
The button has these properties set:
- Keyboard Navigable: Yes
- Mouse Navigate: Yes
- Iconic: Yes
- Icon Filename: list.ico
. . .
An appropriate LOV has been created (called SALES_REP_LOV) and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults.
You write a When-Button-Pressed trigger at the item level with this code:
LIST_VALUES;
To test the form, you attempt to enter a new record.
What is the run-time behavior of the form?
A. The form doesn't compile and therefore cannot be tested.
B. The icon is not displayed on the button.
When you click the Sales Rep Id field and then click the button, the LOV is invoked.
C. The icon is displayed on the button.
When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
D. The icon is not displayed on the button.
When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
E. The icon is displayed on the button.
When you click in the Sales Rep Id field and then click the button, the LOV is invoked.
Answer: D
05. Exhibit:
The DBA added a STATE column defined as VARCHAR2(2) to the CUSTOMERS table. This column will contain two-letter state abbreviations; because the CUSTOMERS table is quite large, storing complete state names would waste space in the database. The DBA asks you to add a corresponding State item to the Customers block of the Orders form.
You open the Layout Editor of the Orders form and create a list item on the canvas in the Customers block. In the Property Palette for the list item, you change the Name property to State and the Database Item property to Yes. You then open the Elements in List property and add some state abbreviations and names to the list, as shown in the exhibit.
When you run the form to test it, after selecting a value from the list and clicking Commit, you receive an FRM error. Its corresponding database error is the following:
ORA-01401: inserted value to large for column
What should you do to correct this problem?
A. Have the DBA increase the column width in the database.
B. Change the List Style property for the State item to Tlist.
C. Change the List Style property for the State item to Combo Box.
D. Set Initial Value for the State item to one of the elements in the list.
E. Set Mapping of Other Values for the State item to a two-letter state abbreviation.
F. Change the elements in the list of the State item so that the list elements are the state names and the list element values are the state abbreviations.
Answer: F
06. In the Orders form you define five LOVs, and you create one button to be used to display any of the LOVs. The button is enabled only when the user navigates to a field with an attached LOV. If the user supplies only part of the required input data, the LOVs use that input as search criteria to automatically reduce the LOV Contents. If the LOVs hold only one value that can possibly math user-supplied input, then the LOVs auto-complete the
input field and are not displayed.
Which built-in properties should you use to display the LOVs?
A. Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to NO.
B. Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to YES.
C. Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to NO.
D. Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to YES.
E. Use the Show_LOV built-in, and set the Mouse Navigate property value to YES.
Set the Validate from List property of the text item to NO for each item with an attached LOV.
F. Use the Show_LOV built-in, and set the Mouse Navigate property value to YES.
Set the Automatic Select property of each LOV to YES.
Answer: A
07. While using the LOV Wizard to create the LOV called SALES_REP_LOV, which is based on the SALES_REP_RG record group, you assign it to the Sales_Rep_Name item in the form that you are developing.
After the LOV is created, you realize that you should have assigned the LOV to the Sales_Rep_Id item instead What can you do to make this change?
A. Change the Column Mapping properties of the SALES_REP_LOV list of values to return the value to SALES_REP_ID rather than to SALES_REP_NAME.
B. Delete the value in the List of Values property for the Sales_Rep_Name item and set the List of Values property of the Sales_Rep_Id item to SALES_REP_LOV.
C. Change the Record Group Query property of the SALES_REP_RG record group to select into the Sales_Rep_Id item instead of into the Sales_Rep_Name item.
D. Delete the SALES_REP_LOV list of values and create it again, because once the LOV is created, you cannot modify the item to which it is assigned.
Answer: B
0 Comments