Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 51:

  What are two ways that you can assign a value to an item on a form from within the code of a menu item? (Choose two).

  A. Use the COPY built-in.
  B. Use the NAME_IN built-in.
  C. Use the FIND_ITEM built-in.
  D. Use the SET_ITEM_PROPERTY built-in.
  E. Use the EXECUTE_TRIGGER built-in to call code in the form that assigns the value.
  A. Use the COPY built-in.
  E. Use the EXECUTE_TRIGGER built-in to call code in the form that assigns the value.

• Question 52:

  The user must be able to invoke a list of values for valid sales representatives in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Rep Id field. The text item has these properties set:

  -Required: Yes

  -List of Values: SALES_REP_LOV

  -Validate from List: No

  The button has these properties set:

  -Keyboard Navigable: Yes

  -Mouse Navigate: Yes

  -Iconic: Yes

  -

  Icon Filename: list.ico

  An appropriate LOV has been created (called SALES_REP_LOV) and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults.

  You write a When-Button-Pressed trigger at the item level with this code:

  LIST_VALUES;

  To test the form, you attempt to enter a new record. What is the run-time behavior of the form?

  A. The form doesn't compile and therefore cannot be tested.
  B. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.
  C. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
  D. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
  E. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.
  D. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.

• Question 53:

  While using the LOV Wizard to create the LOV called SALES_REP_LOV, which is based on the SALES_REP_RG record group, you assign it to the Sales_Rep_Name item in the form that you are developing.

  After the LOV is created, you realize that you should have assigned the LOV to the Sales_Rep_Id item instead.

  What can you do to make this change?

  A. Change the Column Mapping properties of the SALES_REP_LOV list of values to return the value to SALES_REP_ID rather than to SALES_REP_NAME.
  B. Delete the value in the List of Values property for the Sales_Rep_Name item and set the List of Values property of the Sales_Rep_Id item to SALES_REP_LOV.
  C. Change the Record Group Query property of the SALES_REP_RG record group to select into the Sales_Rep_Id item instead of into the Sales_Rep_Name item.
  D. Delete the SALES_REP_LOV list of values and create it again, because once the LOV is created, you cannot modify the item to which it is assigned.
  B. Delete the value in the List of Values property for the Sales_Rep_Name item and set the List of Values property of the Sales_Rep_Id item to SALES_REP_LOV.

• Question 54:

  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-Commit
  B. Post-Database-Commit
  C. When-Validate-Record
  D. Post-Insert, Post-Update and Post-Delete
  E. You cannot accomplish this using Forms triggers; you must use a database trigger.
  D. Post-Insert, Post-Update and Post-Delete

• Question 55:

  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. No changes are required.
  B. Delete the BEGIN and END keywords.
  C. Define an EXCEPTION section to handle exceptions.
  D. Pass the Forms variable to the package function with the format :block_name.item_name.
  E. Define a DECLARE section to declare PL/SQL variables.
  D. Pass the Forms variable to the package function with the format :block_name.item_name.

• Question 56:

  View the Exhibit.

  You have created three list items, each of which is in a different list style. You have defined the same four list elements for each list item. The exhibit depicts the list items at run time after user input.

  What is the list style of each list item?

  

  A. List 1: Combo box; List 2: Poplist; List 3: Tlist
  B. List 1: Poplist; List 2: Combo box; List 3: Tlist
  C. List 1: Poplist; List 2: Tlist; List 3: Combo box
  D. List 1: Tlist; List 2: Combo box; List 3: Poplist
  E. List 1: Combo box; List 2: Tlist; List 3: Poplist
  F. List 1: Tlist; List 2: Poplist; List 3: Combo box
  B. List 1: Poplist; List 2: Combo box; List 3: Tlist

• Question 57:

  You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets block of the form that has an LOV whose record group uses the following query:

  SELECT event_name, event_date FROM events

  ORDER BY event_date

  In the Choose_Event block of the form, you want users to be able to select an event name into an Event_Name item. The event name will be selected from an LOV that is sorted by the name of the event.

  You do not want to modify either the LOV or the record group at run time.

  Which statement is true for the LOV and the record group as specified at design time?

  A. You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group.
  B. You must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same record group.
  C. You can use the same LOV and record group for the Choose_Event.Event_Name item that you used for the Tickets.Event_Date item.
  D. You can use the same LOV for both items, but you should specify that each item must use a different record group for the LOV.
  A. You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group.

• Question 58:

  In the Product.fmb module, data block items are displayed on two content canvases. You define a set of icon buttons that users must have access to at all times.

  Which canvas type is appropriate to display the buttons?

  A. overlay stacked canvas
  B. overlay Tab canvas that is associated with a separate window
  C. content canvas that is associated with the same window as the two content canvases
  D. Horizontal Toolbar canvas that is associated with a separate window
  E. Horizontal Toolbar canvas that is associated with the same window as the two content canvases
  E. Horizontal Toolbar canvas that is associated with the same window as the two content canvases

• Question 59:

  You want to standardize the appearance of certain text items in a particular form, so you create a Visual Attribute called TEXT_ITEM_VA and define values for all of its properties.

  Which four properties can you set by applying TEXT_ITEM_VA to the items? (Choose four.)

  A. Width
  B. Height
  C. Prompt D. Font Weight
  E. Fill Pattern
  F. Font Spacing
  G. Foreground Color
  E. Fill Pattern
  F. Font Spacing
  G. Foreground Color

• Question 60:

  The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. Youare 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?

  A. CALL_FORM('Departments');
  B. CALL_FORM('Departments',NO_HIDE);
  C. OPEN_FORM('Departments');
  D. OPEN_FORM('Departments',ACTIVATE,SESSION);
  E. OPEN_FORM('Departments',NO_ACTIVATE,NO_SESSION);
  F. NEW_FORM('Departments');
  G. POST;NEW_FORM('Departments',FULL_ROLLBACK);
  D. OPEN_FORM('Departments',ACTIVATE,SESSION);