Online Access Free 1Z0-141 Practice Test

View the Exhibit.
You want to create a menu item to enable users to sort the tabular display of a form either by customer ID, last name, or department ID. You decide to create a radio group as shown at run time in the exhibit.
Which statement about this radio group is true?

• A.You must create a Radio menu item before the radio group is created.
• B.You must create the radio group before creating Radio menu items for it.
• C.You must name the radio group Sort, the same as the submenu label, so that it will be associated with that submenu.
• D.You must name the radio group the same as the submenu name so that it will be associated with that submenu.

View the Exhibit.
You are coding a When-New-Form-Instance trigger to populate a hierarchical tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. King, the president of the company, is the only employee who does not have a manager.
In the trigger, you declare a variable called rg_emps that is of the RECORDGROUP data type. You will use this record group to populate the tree. You use the following code to create the record group:
rg_emps := Create_Group_From_Query('rg_emps', 'select 1, level, last_name, NULL, to_char(employee_id) from employees connect by prior employee_id = manager_id start with manager_id is null');
You then programmatically populate the record group, and then populate the tree with the record group.
You run the form to test it. Will the tree initially appear as shown? If not, why not?

• A.No. The "connect by" statement should be "connect by prior manager_id = employee_id".
• B.No. The first element selected in the select statement should be 4 because you want four levels of the tree to be displayed.
• C.Yes, the tree will appear as shown.
• D.No. You should eliminate the last element selected in the select statement, because you do not want to display the employee ID.

You create a text item in the Object Navigator. Which property must you change from the default value so that the text item will not be part of the SQL statement when a query is issued on the block?

• A.Column Name
• B.Calculation Mode
• C.Conceal Data
• D.Validate from List
• E.Database Item
• F.Item Type
• G.Query Allowed

The Warehouse.fmb module contains two data blocks. You want to display items from each data block on separate content canvases. You must ensure that both content canvases are visible together at run time. Which two statements about content canvases are correct?
(Choose two.)

• A.A content canvas can be associated with a window by setting the Primary Canvas property of the window.
• B.Two or more content canvases can be displayed by setting their viewports to be smaller than the window with which they are to be associated.
• C.A content canvas can be associated with a window by setting the Window property of the canvas.
• D.A content canvas can be associated with two or more windows by setting the Primary
  Canvas property of the windows.
• E.A window cannot display more than one content canvas during a run time session.
• F.Two or more content canvases can be displayed by associating each of them with a different window.

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?

• A.Users will be unable to delete master records if detail records exist.
• B.Users will be unable to delete detail records if master records exist.
• C.If users delete a master record, its detail records will also be deleted.
• D.If users delete all detail records, the master record will also be deleted.
• E.Users will be able to delete a master record even if detail records exist.