|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#1. 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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#2. Exhibit:
You want to create a new data block. You click the Data Blocks node in the Object Navigator, and then you click Create to invoke the Create Data Block dialog box. As you click through the pages of the wizard, the page shown in the exhibit appears.
After looking at the exhibit, what do you know is true about this form?
Show comments for this question (1)
Add comments
Link to this question
|
|
#4. While updating an existing customer record using the Customers form, the user invoked the Orders form by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had the following code:
CALL_FORM(‘orders’);
There is a requirement to navigate back to the Customers form after the order details have also been updated. This will be achieved through a form-level Key-Exit trigger in the Orders form.
Which code should be used?
Show comments for this question (1)
Add comments
Link to this question
|
|
#5. 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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#6. You are editing the INVENTORY tab canvas. You set the Tab Attachment Edge property to RIGHT .You also change the ordering of INVENTORY tab pages in the Object Navigator. The Direction property has not been customized.
What influence will this have on the display of tab pages at run time?
Show comments for this question (0)
Add comments
Link to this question
|
|
#8. Exhibit:
You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhibit, when the query cannot be performed you want to display to the user a message with the actual database error that is received.
What can you do to implement this?
Show comments for this question (0)
Add comments
Link to this question
|
|
#10. To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from the triggers or menu items .You want the message “Credit limit exceeded” to be displayed when the values in the order_total and credit_limit fields in the Orders form meet certain criteria. Which code do you use?
Show comments for this question (0)
Add comments
Link to this question
|
|
|
|
 gen. 0.095
|
Server date 01:08 10-01-2009
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump