Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 11:

  In your Employee.fmb module you have an EMP block, which is currently on a content canvas. You want to display items from the EMP block on a new tab canvas. What are two ways to achieve this? (Choose two.)

  A. 1. Create a tab canvas in the Layout Editor.2. For each item, associate the tab canvas by specifying the Canvas property.3. Set the Rendered property of each item to Yes.
  B. 1. Create a tab canvas in the Layout Editor.2. For each item, associate the tab canvas by specifying the Canvas property.3. For each item, associate the tab page by specifying the Tab Page property.
  C. 1. Create a tab page in the Layout Editor.2. Associate the content canvas with each item by specifying the Item Canvas property.3. For each item, associate the tab page by specifying the Tab Page property.4. Set the Visible property of each item to Yes.
  D. 1. Create a canvas in the Object Navigator.2. Set the Canvas Type property to Content.3. For each item, associate the new canvas by specifying the Item Canvas property.
  E. 1. Create a canvas in the Object Navigator.2. Set the Canvas Type property to Tab.3. For each item, associate the new canvas by specifying the Item Canvas property.4. Set the Rendered property of each item to Yes.
  F. 1. Create a canvas in the Object Navigator.2. Set the Canvas Type property to Tab.3. For each item, associate the new canvas by specifying the Item Canvas property.4. For each item, associate the tab page by specifying the Tab Page property.
  B. 1. Create a tab canvas in the Layout Editor.2. For each item, associate the tab canvas by specifying the Canvas property.3. For each item, associate the tab page by specifying the Tab Page property.
  F. 1. Create a canvas in the Object Navigator.2. Set the Canvas Type property to Tab.3. For each item, associate the new canvas by specifying the Item Canvas property.4. For each item, associate the tab page by specifying the Tab Page property.

• Question 12:

  An application is accessed through the Summit form, which can open the Customers form and the Orders form. The Customers form can also open the Orders form, and the Orders form can open the Customers form. What should you do to ensure that forms are closed in the proper order so that the session closes down when the last form is exited?

  A. You should keep track of the order of the opening of forms in a global record group. Then in the Key-Exit trigger for each form, you shouldallow only the last form that was opened to be closed.
  B. You should make sure that the Summit form that started the session is the last one closed by coding its Key-Exit trigger to exit only if no otherforms are open.
  C. You do not need to do anything because Forms keeps track of the forms that are opened internally and does not allow the user to close themin the wrong order.
  D. You do not need to do anything. No matter which form is closed last, the session will close properly.
  D. You do not need to do anything. No matter which form is closed last, the session will close properly.

• Question 13:

  View the Exhibit and examine the PL/SQL block.

  To resolve compiler or run-time errors, what three changes could you make to this code? (Choose three.)

  

  A. Define the BEGIN and END keywords.
  B. Declare PL/SQL variables in an anonymous block.
  C. Define an EXCEPTION section to handle exceptions.
  D. Define an EXCEPTION section to declare exceptions.
  E. Define an EXCEPTION section to declare PL/SQL variables.
  F. Define a DECLARE section to declare PL/SQL variables and exceptions.
  A. Define the BEGIN and END keywords.
  C. Define an EXCEPTION section to handle exceptions.
  F. Define a DECLARE section to declare PL/SQL variables and exceptions.

• Question 14:

  You have been asked to correct a problem with a form that was created by another developer. Users complain that they are unable to query on the employee Hire Date, which is a base table item. What is a possible cause for this problem?

  A. The Hire Date item is a display item.
  B. The Hire Date item has its Enabled property set to No.
  C. The Hire Date item has its Query Allowed property set to Yes.
  D. The Hire Date item width is not large enough to display the complete date.
  A. The Hire Date item is a display item.

• Question 15:

  You are designing a Human Resources application that uses a menu to implement most of the code. One of the menu items is labeled Raise Salary. The business rule is that the salary should be raised 2% if the salary of the selected employee shown in the form is less than $25,000 per year, but the raise should be 3% if the value of the salary item is $25,000 or greater.

  Which condition can you use in the menu code to determine if the current value of the Salary item in the Employees block is less than $25,000?

  A. IF :EMPLOYEES.SALARY < 25000 THEN...
  B. IF COPY('EMPLOYEES.SALARY') < 25000 THEN...
  C. IF NAME_IN('EMPLOYEES.SALARY') < 25000 THEN...
  D. IF FIND_ITEM('EMPLOYEES.SALARY') < 25000 THEN...
  E. IF GET_ITEM_PROPERTY('EMPLOYEES.SALARY',DATABASE_VALUE) < 25000 THEN...
  C. IF NAME_IN('EMPLOYEES.SALARY') < 25000 THEN...

• Question 16:

  You want to create a calculated item in the Control block of the Human Resources form. This item will contain the total of employee salaries for employees in a particular department. Which statement is true about how to create the calculated item?

  A. You can create it by first creating a text item and then changing the item type.
  B. You can create it in the Layout Editor using a special tool that creates a calculated item.
  C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.
  D. You can create it in the Layout Editor by selecting the Salary item of the Employees block, selecting the Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to automatically calculate a sum of the selected Salary item.
  C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.

• Question 17:

  View the Exhibit.

  A 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 detail records if master records exist.
  B. Users will be unable to delete master records if detail records exist.
  C. If users delete a master record, its detail records will also be deleted.
  D. Users will be able to delete a master record even if detail records exist.
  E. If users delete all detail records, the master record will also be deleted.
  B. Users will be unable to delete master records if detail records exist.

• Question 18:

  Which statement about object libraries is true?

  A. Object libraries are saved as part of the Forms module.
  B. You cannot place an individual item into an object library.
  C. When you open Forms Builder, all object libraries in the current working directory are opened.
  D. Using object libraries can increase network performance by promoting object similarities.
  D. Using object libraries can increase network performance by promoting object similarities.

• Question 19:

  During testing, you received comments that the default functionality of the [Commit] key can cause an error message to be displayed if there are no changes to save when it was activated.

  You decide to provide a button for users to validate the form and issue a commit if necessary. To implement this, you write a form-level procedure called VALIDATE_AND_COMMIT. The same functionality must be provided when the user

  chooses File > Save from the menu or presses the [Commit] key.

  Which should you use?

  A. The When-Button-Pressed trigger with the codeDO_KEY(commit;);A form-level Key-Commit trigger with the codevalidate_and_commit;
  B. The When-Button-Pressed trigger with the codeDO_KEY('COMMIT_FORM');A form-level Key- Commit trigger with the codeDO_KEY('COMMIT_FORM');validate_and_commit;
  C. The When-Button-Pressed trigger with the codeDO_KEY('[COMMIT]');A form-level Key-Commit trigger with the codeDO_KEY('validate_and_commit');
  D. The When-Button-Pressed trigger with the codeDO_KEY('COMMIT_FORM');A form-level Key- Commit trigger with the codevalidate_and_commit;
  E. The When-Button-Pressed trigger with the codevalidate_and_commit;A form-level Key-Commit trigger with the codeDO_KEY('COMMIT_FORM');
  D. The When-Button-Pressed trigger with the codeDO_KEY('COMMIT_FORM');A form-level Key- Commit trigger with the codevalidate_and_commit;

• Question 20:

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

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