Free Oracle 1Z0-141 Exam Dumps Questions & Answers

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 Window property of the canvas.
• B.  A content canvas can be associated with two or more windows by setting the Primary
  Canvas property of the windows.
• C.  A window cannot display more than one content canvas during a run time session.
• D.  A content canvas can be associated with a window by setting the Primary Canvas property of the window.
• E.  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.
• F.  Two or more content canvases can be displayed by associating each of them with a different window.

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?

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

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 Check Box Mapping of Other Values property to Null.
• D.  Change the Initial Value property to Good and the Value When Unchecked property to
  Null.
• E.  Change the Initial Value property to Good and the Check Box Mapping of Other Values property to Checked.
• F.  Change the Initial Value property to Good.

A form named Orders is saved to the file system as MY_ORDERS.FMB. You are modifying the Customers form, and you want to code a When-Button-Pressed trigger to invoke the
Orders form only if the Orders form is not already open. What is the correct code to place in the When-Button-Pressed trigger?

• A.  IF NOT FIND_FORM('MY_ORDERS') THEN
  OPEN_FORM('ORDERS');
  ELSE
  GO_FORM('ORDERS');
  END IF;
• B.  OPEN_FORM('ORDERS',NO_ACTIVATE);
• C.  IF ID_NULL(FIND_FORM('ORDERS')) THEN
  OPEN_FORM('MY_ORDERS');
  ELSE
  GO_FORM('ORDERS');
  END IF;
• D.  IF ID_NULL(FIND_FORM('ORDERS')) THEN
  OPEN_FORM('ORDERS');
  ELSE
  GO_FORM('ORDERS');
  END IF;
• E.  OPEN_FORM('MY_ORDERS',NO_ACTIVATE);
• F.  IF NOT FIND_FORM('ORDERS') THEN
  OPEN_FORM('MY ORDERS');
  ELSE
  GO_FORM('ORDERS');
  END IF;

Which two statements correctly describe the relationship between a content canvas and a window? (Choose two.)

• A.  A content canvas can be associated with two or more windows.
• B.  A content canvas cannot be larger than the window with which it is associated.
• C.  One or more content canvases can be associated with a window.
• D.  Only one content canvas at a time can appear in a window.
• E.  Only one content canvas can be associated with a window.
• F.  A maximum of two content canvases can appear in a window at the same time.