Oracle9i forma Developer:build internet applications (1Z0-141) Free Practice Test

Question 1

View the Exhibit.
In the Human Resources form shown in the exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id fields in the
Departments data block.
What must you select prior to invoking the Layout Wizard in reentrant mode to modify these item properties?

A. Canvas4

B. the Departments block

C. Frame8

D. the DEPARTMENT_ID, MANAGER_ID, and LOCATION_ID items

E. Frame5

Correct Answer: E

Question 2

You are developing a form that uses alerts to display database messages rather than associated FRM messages when the SQL statements issued by the form cause database errors to occur. You use a generic alert called DB_Alert to display the messages.
You begin to code an On-Error trigger to trap the FRM-40505 error that occurs when the
SQL statement references an invalid column name. The associated database message is
"ORA-00904: Invalid column name", and this is what you want to be displayed in the alert.
You create a form-level On-Error trigger with the following code:
DECLARE
n NUMBER;
BEGIN
IF ERROR_CODE = 40505 THEN
SET_ALERT_PROPERTY('DB_Alert',ALERT_MESSAGE_TEXT,
DBMS_ERROR_CODE);
n := SHOW_ALERT('DB_Alert');
END IF;
END;
You run the form to test it. What will the run-time behavior be when the FRM-40505 error is encountered?

A. The alert does not appear, and the message "FRM-41039: Invalid Alert ID 0" appears on the message line.

B. The alert called DB_Alert appears with the message "ORA-00904: Invalid column name".

C. The alert does not appear, and the message "ORA-00904: Invalid column name" appears on the message line.

D. The alert called DB_Alert appears, but not with the correct message.

E. The alert does not appear, and the FRM-40505 message appears on the message line.

Correct Answer: D

Question 3

You have an image item in the Employees form to display an employee photograph. The image item has default values for its properties. You are trying to decide where to place some code to manipulate the image item. If you place the code in a When-Image-Activated trigger, when will the code be executed?

A. when the user clicks the image item

B. when the image item is populated with an image, either programmatically or by a query

C. when the image item is first displayed on the canvas

D. when the user double-clicks the image item

Correct Answer: D

Question 4

The Orders form is a master-detail form in which ORDERS is a single-record master block and ORDER_ITEMS is a multirecord detail block.
During testing of the Orders form, users have complained about the behavior of Enter-
Query mode.
In the form they are testing, they are unable to navigate out of the current block while they are in Enter-Query mode. However, they would like to be able to carry out the following procedure:
1 . Press [Enter Query] while in the master block.
2 . Enter some search criteria.
3 . Navigate to the detail block.
4 . Enter more search criteria (while the form is still in Enter-Query mode).
5 . Press [Execute Query] to have the criteria applied to both blocks at once.
How can you provide the requested functionality?

A. Use a Key-Entqry trigger on the master block to redirect the focus to the detail block after the search criteria have been entered in the master block.

B. The requested functionality is the default behavior. You simply need to remove or rewrite the triggers you wrote that "broke" the form.

C. Use a Key-Exeqry trigger on both the master and detail blocks to call a centralized procedure and have the procedure handle the navigation.

D. Use a Key-Nxtblk trigger on the ORDERS block to cause navigation to the
ORDER_ITEMS block. This will work because Key triggers can fire in Enter-Query mode and can call restricted built-ins such as GO_BLOCK().

E. Use a combination of Key-Entqry and Key-Exeqry triggers at form level to call generically written procedures to test where the current focus is and set global variables that a form-level Key-Nxtblk trigger can use to redirect the focus.

F. You cannot perform the requested operation with a master-detail form. The restriction on navigating out of the current block during Enter-Query mode cannot be circumvented.

Correct Answer: F

Question 5

View the Exhibit.
You have created a menu for the Summit Office Supply application that you attach to its main form.
The menu, whose Menu Editor is shown in the exhibit, contains several submenus:
Applications, displaying a choice of forms to invoke
Customers, displaying menu items for the Customers form
Orders, displaying menu items for the Orders form
HR, displaying menu items for the HR form
The Main Menu property for the menu is set to Applications.
When the user chooses from the Applications submenu to invoke another form, which built- in can you use to display the appropriate menu items for that form?

A. FIND_MENU

B. FIND_MENU_ITEM

C. SET_MENU_ITEM_PROPERTY

D. SET_FORM_PROPERTY

E. REPLACE_MENU

Correct Answer: E

Question 6

View the Exhibit.
You are developing a form for a family-oriented video store. The form will run in query-only mode in a customer kiosk to show information about movies that are available to rent. The
Rating item in the Movies block of 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 rated G to indicate that it is suitable for the whole family.
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.
You change the item type of the Rating item to Checkbox and set its Label, Value When
Checked (G), and Prompt properties. However, when you run the form to test it and execute an unrestricted query, only those movies with a rating of G are displayed.
What do you need to change so that all movies are returned by the query and the check box properly shows the "For the Whole Family" rating?

A. Set the Checkbox Mapping of Other Values property of the Rating item to Unchecked.

B. Set the Update Allowed, Insert Allowed, and Delete Allowed Properties of the Movies block to No.

C. Set the Value When Unchecked property of the Rating item to null.

D. Set the Initial Value property of the Rating item to G.

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

F. Set the Checkbox Mapping of Other Values property of the Rating item to Checked.

Correct Answer: A

Question 7

In an Order Entry form, the Order_Items block has a text item called Shipping_Date, which is of the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item. Assuming that all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three.)

A. :GLOBAL.SHIP_DATE

B. $$DBDATE$$

C. :PARAMETER.SHIP_DATE

D. SYSDATE

E. ORDER_ITEMS_SEQ

F. :Orders.Order_Date + 3

Correct Answer: A,B,C

Question 8

You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. You are also maintaining an audit table with the following table description:
SQL> desc audit_changes
Name Null? Type
--------------------------------------- --------------- -----------------------------
TABLE_NAME VARCHAR2 (30)
ID NUMBER
TIMESTAMP DATE
CHANGE_BY VARCHAR2 (30)
CHANGE_TYPE VARCHAR2 (6)
Valid values for the CHANGE_TYPE column are INSERT, UPDATE, and DELETE.
Which trigger(s) must you create or modify in the Human Resources form to track all the information in the audit table?

A. Post-Database-Commit

B. Post-Commit

C. You cannot accomplish this using Forms triggers; you must use a database trigger.

D. Post-Insert, Post-Update and Post-Delete

E. When-Validate-Record

Correct Answer: D

Question 9

You start an OC4J instance on your development PC and then run a form from the Forms
Builder. Which statement describes the behavior of OC4J?

A. It appears in a separate window, which you should not close or the OC4J instance will abort.

B. It appears in the Forms Builder window, which you can close after OC4J starts.

C. It appears in the Forms Builder window, which you can minimize after OC4J starts.

D. It appears in a separate window, which you can close after OC4J starts.

E. It appears in a separate window, which you should not minimize or the OC4J instance will abort.

Correct Answer: A

Welcome to TestSimulate

Oracle9i forma Developer:build internet applications (1Z0-141) Free Practice Test