1z0-141 | The Secret of Oracle 1z0-141 vce
Q41. An Order Entry form that you are developing contains several blocks. The first is a control block where you create buttons to perform certain actions.
One button, which is mouse and keyboard navigable, contains code to navigate to and perform queries in multiple blocks in the form:
GO_BLOCK('Customers');
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
You do not want trigger processing to continue if there is any type of error in navigating to the Customers block. How should you modify the code?
A. GO_BLOCK('Customers');
if not FORM_FAILURE then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
B. GO_BLOCK('Customers');
if FORM_SUCCESS then
EXECUTE_QUERY;
end if;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
C. GO_BLOCK('Customers');
if not FORM_SUCCESS then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
GO_BLOCK ('Items');
EXECUTE_QUERY
D. GO_BLOCK('Customers');
if FORM_FATAL then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK ('Items');
EXECUTE_QUERY
Answer: C
Q42. You are running a multiple-form application. The Customers form invokes the Orders form. When the Orders form launches, it displays orders for only the active customer from the Customers form.
Forms exchange data with the :GLOBAL.CUSTOMER_ID variable.
The Orders form should be restricted to orders for the current customer only the first time a query is issued after invoking the Orders form. Which built-in helps you do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?
A. SET_APPLICATION_PROPERTY
B. SET_BLOCK_PROPERTY
C. SET_RECORD_PROPERTY
D. SET_FORM_PROPERTY
Answer: B
Q43. View the Exhibit.
The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, 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 poor 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 poor 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 Poor
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 you make in the properties of the Credit_Rating item to enable values of Good, Poor, and Null to be entered?
A. Change the Check Box Mapping of Other Values property to Not Allowed.
B. 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.
C. Change the Initial Value property 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 Checked.
E. Change the Initial Value property to Good.
F. Change the Initial Value property to Good and the Check Box Mapping of Other Values property to Null.
Answer: B
Q44. Order entry clerks use the Orders form to enter the shipping date of an order. Once the shipping date has been entered into the database, the clerks are not allowed to modify it. What property can you set in the Property Palette for the Shipping_Date item to ensure that this data entry restriction is enforced?
A. Update Only If NULL
B. Enabled
C. Database Item
D. Update Allowed
E. Insert Allowed
Answer: A
Q45. The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the Order_Date in descending order, because order entry clerks usually must access only the most recent orders.
Which one of the following combinations of property settings for the Orders block will provide the fastest response time before a record appears in the block upon executing a query?
A. Query Array Size: 0
Number of Records Buffered: 1000
Query All Records: No
B. Query Array Size: 0
Number of Records Buffered: 0
Query All Records: Yes
C. Query Array Size: 1000
Number of Records Buffered: 0
Query All Records: Yes
D. Query Array Size: 1000
Number of Records Buffered: 0
Query All Records: No
E. Query Array Size: 0
Number of Records Buffered: 1000
Query All Records: Yes
Answer: A
Q46. 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?
A. IF GET_APPLICATION_PROPERTY(calling_form) IS NOT NULL THEN
EXIT_FORM(ASK_COMMIT, NO_ROLLBACK);
ELSE
EXIT_FORM;
END IF;
B. IF :SYSTEM.FORM_STATUS = 'CHANGED' THEN
COMMIT_FORM:
END IF;
GO_FORM('customers');
C. ENTER;
IF :SYSTEM.CURSOR_BLOCK = 'CHANGED' THEN
COMMIT_FORM;
ELSE
EXIT_FORM(NO_VALIDATE, NO_ROLLBACK);
END IF;
D. VALIDATE(FORM_SCOPE);
IF :SYSTEM.FORM_STATUS <> 'QUERY' THEN
GO_FORM('customers');
ELSE
EXIT_FORM;
END IF;
Answer: A
Q47. View the Exhibit and examine the Property Palettes of the BONNY canvas and the CLYDE window. The requirements of the application specify that the CLYDE window should not be resizable.
The form contains two items, both 50 points wide by 15 points high, which are associated with the canvas.
The first item is a text item; the X Position property is 30, and the Y Position property is 40.
The second item is a display item; the X Position property is 150, and the Y Position property is 250.
What are two ways to allow the user to view the display item at run time? (Choose two.)
A. At run time, with the cursor in the text item, press the Tab key.
B. Define CLYDE as a modal window and display it with a horizontal scroll bar.
C. Define CLYDE as a modeless window and display it with a vertical scroll bar.
D. Define CLYDE as a document window and display it with a vertical scroll bar.
E. Define CLYDE as a modeless window and display it with a horizontal scroll bar.
F. Define CLYDE as a dialog window and display it with a horizontal scroll bar.
Answer: CD
Q48. Which statement is true about built-ins that invoke one form from another?
A. OPEN_FORM is the only way to invoke the second form in "query only" mode.
B. NEW_FORM improves performance but consumes more memory because the first form is retained in memory and returning to it is more efficient than reloading it.
C. CALL_FORM does not issue a savepoint.
D. OPEN_FORM invokes the second form in a modeless state and optionally within a different transaction scope.
E. NEW_FORM invokes the second form in a modal state so the user can navigate freely between the two running forms.
F. CALL_FORM cannot be issued while in Enter-Query mode.
Answer: D
Q49. The Orders form has two base table blocks and a control block. There is an Execute Query button in the control block with the following When-Button-Pressed trigger:
DO_KEY('execute_query');
A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: "This function cannot be performed here."
What can you do to fix this error?
A. Define a Key-Exeqry trigger at the form level.
B. Set the Mouse Navigate property to No for the Execute Query button.
C. Set the Query Allowed property to Yes for at least one item in the Order Items block.
D. Set the Query All Records property to Yes for the Order Items block.
Answer: B
Q50. You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be decided by the user at run time. How should you define the appropriate data source?
A. Define a data block based on a From Clause query and define Transactional triggers for controlling DML statements.
B. Define a data block based on a Ref Cursor.
C. Define a data block based on a Table of Records.
D. Define a data block based on a combination of a Ref Cursor and a Table of Records.
E. Define a data block based on a From Clause query.
Answer: B