The Secret of Oracle 1z0-141 exam dumps

Q1. The Orders form has two Record Groups: the SHIP Record Group that was created at design time, and the SOLD Record Group that was created at run time. You are required to write a Program Unit that will delete both Record Groups. Which two statements describe your situation? (Select two.)

A. You should delete Record Group SOLD with built-in DELETE_GROUP('SOLD');

B. You should delete Record Group SOLD with built-in

DELETE_GROUP_ROW('SOLD',ALL_ROWS);

C. You should delete Record Group SHIP with built-in

DELETE_GROUP_ROW('SHIP',ALL_ROWS);

D. You cannot delete Record Group SOLD at run time.

E. You should delete Record Group SHIP with built-in DELETE_GROUP('SHIP');

F. You cannot delete Record Group SHIP at run time.

View Answer

Q2. You are building the Customer.fmb module, and you define a multirecord data block based on the CUSTOMERS table. The data block is called CUST.

You specify a Tabular layout style for the CUST items. When the window is at its maximum size, only some of the items can be viewed in the window. To view all items together, you should enable users to scroll horizontally through the CUST items; however, the Cust_ID and Cust_Name items should always be visible.

Which combination of canvas types is most appropriate to display the CUST items together?

A. Vertical Toolbar canvas and a Tab canvas

B. Content canvas and an overlay Tab canvas

C. Content canvas and an overlay stacked canvas

D. Horizontal Toolbar canvas and a content canvas

E. Tab canvas and an overlay stacked canvas

View Answer

Q3. You are developing a Human Resources application, and you create an Employees button in the Departments form. The When-Button-Pressed trigger calls the Employees form to display the employees in the current department. You have set the Employees button properties so that navigation to the button does not occur. The Validation Unit property of the Departments form is set to Item.

You want to ensure that the Department ID is valid prior to calling the Employees form, even if the user has updated the Department ID and has not navigated out of that item. The Department_Id item has a When-Validate-Item trigger that performs some complex validation logic.

What code in the When-Button-Pressed trigger would force the When-Validate-Item trigger to fire for the Department_Id item without navigating from the item?

A. SET_FORM_PROPERTY('departments',VALIDATION,

PROPERTY_TRUE);

B. ENTER;

C. SYNCHRONIZE;

D. SET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,ITEM_IS_VALID, PROPERTY_TRUE);

E. REDISPLAY;

F. You cannot programmatically cause validation without navigation.

View Answer

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

View Answer

Q5. 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?

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

B. OPEN_FORM, because the second form is invoked in a modal state and there can be only one "Open form stack"

C. CALL_FORM, because it can be issued in Enter-Query mode and can be constrained to be "query only"

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

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

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

View Answer

Q6. What is an indication that the Data Block Wizard is in reentrant mode?

A. There is a tabbed interface.

B. There are no Next> or <Back buttons.

C. You cannot switch between different types of data sources.

D. The Finish button is disabled.

E. The page to create relations does not appear.

View Answer

Q7. View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee's salary if it exceeds 2345.

To resolve compiler or run-time errors and ensure that the code works as intended, what changes should you make to the trigger code?

A. Pass the Forms variable to the package function with the format :block_name.item_name.

B. No changes are required.

C. Define a DECLARE section to declare PL/SQL variables.

D. Define an EXCEPTION section to handle exceptions.

E. Delete the BEGIN and END keywords.

View Answer

Q8. You designed a standard toolbar to accompany a number of forms so the code behind the buttons is written as generically as possible.

One of the features of this toolbar is that the buttons are synchronized with the state of the form.

To achieve this functionality, you wrote generic procedures that are placed in an attached library and are called from various triggers.

For example, if the form is in Enter-Query mode, the procedure set_enter_query_mode will disable the Enter Query button, change the icon for the Exit button, and modify its Tooltip to read "Cancel Query" rather than "Exit".

What must you code to support this approach?

A. Form-level Key triggers that call the generic procedures and item-level When-Button-Pressed triggers that call the DO_KEY() built-in. For example, Key-Entqry has the following code:

set_enter_query_mode;

The When-Button-Pressed trigger on the Enter Query button has the following code:

DO_KEY('ENTER_QUERY');

B. Form-level When-Button-Pressed triggers for each button to call the generic procedures. For example, a form-level trigger on the Enter Query button has the following code:

set_enter_query_mode;

C. Item-level Key triggers for each button as well as item-level When-Button-Pressed triggers for each button to call the generic procedures. For example, the When-Button-Pressed trigger on the Enter Query button has the following code:

set_enter_query_mode;

The Key-Entqry trigger on the Enter-Query button has the following code:

set_enter_query_mode;

D. Block-level Key triggers that call the generic procedures and item-level When-Button-Pressed triggers that call the EXECUTE_TRIGGER()

built-in and pass the name of the button as a parameter. For example, the Key-Entqry trigger has the following code:

set_enter_query_mode;

The When-Button-Pressed trigger on the Enter Query button has the following code:

EXECUTE_TRIGGER('ENTER_QUERY');

View Answer

Q9. View the Exhibit.

You are attempting to drag the Control and CV_Order objects to an object group as shown in the exhibit, but you are unable to release them in the Object Group Children node of the object group.

What is the reason for this?

A. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.

B. You need separate object groups for different types of objects.

C. You cannot drag a block to an object group.

D. You cannot drag multiple types of objects to an object group at the same time.

E. You cannot drag a canvas to an object group.

View Answer

Q10. View the Exhibit.

You are modifying the New_Orders form. You want to change the navigation order of the Orders block so that Order_Status is between Order_Date and Order_Mode in the navigation order.

You attempt to drag the Order_Status item in the Object Navigator (as shown in the exhibit), but Forms does not allow you to release the item in the desired position. Why is this happening, and what can you do to change the navigation order?

A. Because the data block is subclassed, you cannot change the order of items in the object navigator, but you can change item properties to affect the navigation order.

B. Because the data block is subclassed, you will have to delete the object and then create it again in the desired position.

C. Because the item is subclassed, you cannot change any of its properties.

D. Because the data block is subclassed, you can only drag objects to a lower position in the Object Navigator, so you can drag Order_Mode and Customer_Id to a position below Order_Status.

View Answer