Latesttests
2018 Jan Oracle Official New Released 1z0-141
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-141.html

oracle9i forma developer:build internet applications

Question No: 41 – (Topic 0)

You are developing an Order Entry application. The Customers form calls the Orders form and passes the value of Customer_Id as a parameter by the same name, so that the orders for only that customer are displayed. Which three statements are true? (Choose three).

  1. You must create the parameter at design time in the Customers form.

  2. You must create the parameter at design time in the Orders form.

  3. You must create the parameter programmatically in the Customers form.

  4. You must create the parameter programmatically in the Orders form.

  5. You can programmatically refer to the parameter as :parameter.customer_id in the Customers form.

  6. You can programmatically refer to the parameter as :parameter.customer_id in the Orders form.

Answer: B,C,F

Question No: 42 – (Topic 0)

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 quot;For the Whole Familyquot; rating?

Latesttests 2018 PDF and VCE

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

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

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

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

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

  6. Change the item type. You cannot use a check box for this application because there

are more than two possible values for the item.

Answer: D

Question No: 43 – (Topic 0)

There is a requirement to invoke the Orders form from the Customers form. Your colleagues offer some suggestions about which built-in to use and their reasons for the choice. Which suggestion names a built-in that will meet the requirement and offers a correct reason?

  1. CALL_FORM, because NEW_FORM is no longer valid for Web-deployed forms due to the extra network traffic that it causes

  2. CALL_FORM, because it can be issued in Enter-Query mode and can be constrained to be quot;query onlyquot;

  3. CALL_FORM, because the second form is invoked in a modeless state and it saves on memory resources

  4. NEW_FORM, because the second form is invoked in a modeless state and the user can navigate freely between the two running forms

  5. OPEN_FORM, because the second form is invoked in a modal state and there can be only one quot;Open form stackquot;

  6. OPEN_FORM, because it causes a savepoint to be issued and the current form is validated before invoking the second form.

Answer: B

Question No: 44 – (Topic 0)

View the Exhibit.

master-detail form displays Orders and Order Items. What can you tell about the run-time behavior of the form by looking at the exhibit, assuming that the master-detail triggers and relations have not been modified since they were created?

Latesttests 2018 PDF and VCE

  1. Users will be unable to delete detail records if master records exist.

  2. Users will be unable to delete master records if detail records exist.

  3. If users delete a master record, its detail records will also be deleted.

  4. Users will be able to delete a master record even if detail records exist.

  5. If users delete all detail records, the master record will also be deleted.

Answer: B

Question No: 45 – (Topic 0)

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.)

  1. $$DBDATE$$

  2. :Orders.Order_Date 3

  3. SYSDATE

  4. :GLOBAL.SHIP_DATE

  5. :PARAMETER.SHIP_DATE

  6. ORDER_ITEMS_SEQ

Answer: A,D,E

Question No: 46 – (Topic 0)

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 quot;FRM 40505 ORACLE error unable to perform query.quot; What could be the cause of this error?

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

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

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

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

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

Answer: D

Question No: 47 – (Topic 0)

A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionally required to be open. The user complains that once EMP_WIN is open, it is not possible to make the window invisible. The user can navigate between the open windows. You are asked not to write code to close EMP_WIN explicitly. What changes should you make to the Summit form?

  1. Define EMP_WIN as a modal window and set the Hide on Exit property to No.

  2. Define EMP_WIN as a modal window and set the Hide on Exit property to Yes.

  3. Define EMP_WIN as a modal window and set the Close Allowed property to Yes.

  4. Define EMP_WIN as a modeless window and set the Hide on Exit property to No.

  5. Define EMP_WIN as a modeless window and set the Hide on Exit property to Yes.

  6. Define EMP_WIN as a modeless window and set the Close Allowed property to Yes.

Answer: E

Question No: 48 – (Topic 0)

You write a form in which there are two text items (FIELD1 and FIELD2) and a button (BTN1) arranged in the following navigation sequence:

FIELD1, BTN1, FIELD2

With the focus in FIELD1, the user presses the [Next Item] key and encounters a navigation trap, in which the cursor is unable to advance to the next item and cannot return to FIELD1. Which three conditions can combine to produce such a navigation trap? (Choose three.)

  1. FIELD1 has a Post-Text-Item trigger that fails.

  2. FIELD1 has a Pre-Text-Item trigger that fails.

  3. FIELD1 has a When-New-Item-Instance trigger that fails.

  4. FIELD2 has a Post-Text-Item trigger that fails.

  5. FIELD2 has a Pre-Text-Item trigger that fails.

  6. FIELD2 has a When-New-Item-Instance trigger that fails.

  7. The Keyboard Navigable property of BTN1 is set to No.

  8. The Keyboard Navigable property of BTN1 is set to Yes.

Answer: B,E,G

Question No: 49 – (Topic 0)

You need to restrict access to a form. Access must be limited to particular times of the day and to certain authorized users.

You write a procedure (get_authorization) in the form that checks the username of the person logging on and validates the time of day. If the person is not authorized to use the form at that time, the following code is executed:

… MESSAGE

(#39;You are not authorized to access the form at this time#39;); RAISE FORM_TRIGGER_FAILURE;

What is the best trigger from which to call this procedure?

  1. Pre-Form at form level

  2. When-Validate-Item at form level

  3. When-New-Form-Instance at form level

  4. Pre-Block on the first enterable block

  5. When-Validate-Item on the first enterable item

  6. Pre-Text-Item on the first navigable text item in the first navigable block

Answer: A

Question No: 50 – (Topic 0)

The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table.

You are developing a Human Resources application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database.

When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record.

The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. Then they want to be able to return to the Employees form and decide whether or not to save the new employee record.

How should you code the When-Button-Pressed trigger to achieve this?

  1. CALL_FORM(#39;Departments#39;);

  2. CALL_FORM(#39;Departments#39;,NO_HIDE);

  3. OPEN_FORM(#39;Departments#39;);

  4. OPEN_FORM(#39;Departments#39;,ACTIVATE,SESSION);

  5. OPEN_FORM(#39;Departments#39;,NO_ACTIVATE,NO_SESSION);

  6. NEW_FORM(#39;Departments#39;);

  7. POST; NEW_FORM(#39;Departments#39;,FULL_ROLLBACK);

Answer: D

100% Free Download!
Download Free Demo:1z0-141 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-141 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE