Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 131:

  Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).

  A. You cannot raise FORM_TRIGGER_FAILURE in an exception handler.
  B. FORM_TRIGGER_FAILURE does not cause an unhandled exception.
  C. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
  D. If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by another trigger, the calling trigger automatically fails.
  E. Processing continues after FORM_TRIGGER_FAILURE is raised until the end of the PL/SQL block that contains it.
  F. You must code an exception handler to define how you want the FORM_TRIGGER_FAILURE exception to function.
  B. FORM_TRIGGER_FAILURE does not cause an unhandled exception.
  C. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.

• Question 132:

  You should enable the user to add additional values to a list item at run time. You must also ensure that the Record Group LOCATIONS, which is used to populate the list item, can be updated with any user-supplied value.

  What two actions could you take to accomplish this? (Choose two.)

  A. Add a new value to the list item by calling the POPULATE_LIST built-in.
  B. Add a new value to LOCATIONS by calling the POPULATE_GROUP built-in.
  C. Add a new value to the list item by calling the ADD_LIST_ELEMENT built-in.
  D. Remove duplicate values in LOCATIONS by calling the DELETE_LIST_ELEMENT built-in.
  E. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and SET_GROUP_CHAR_CELL built-ins.
  F. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and SET_GROUP_NUMBER_CELL built-ins.
  C. Add a new value to the list item by calling the ADD_LIST_ELEMENT built-in.
  E. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and SET_GROUP_CHAR_CELL built-ins.

• Question 133:

  Order entry clerks use the Orders form to enter the shipping date of an order. Once the shipping date has been entered into the database, the clerks are not allowed to modify it. What property can you set in the Property Palette for the Shipping_Date item to ensure that this data entry restriction is enforced?

  A. Enabled
  B. Database Item
  C. Update Allowed
  D. Insert Allowed
  E. Update Only If NULL
  E. Update Only If NULL

• Question 134:

  View the Exhibit.

  You are developing an account management system for First National Bank. The Layout Editor for the Customer form is shown in the exhibit.

  The three buttons on the form invoke separate forms to enter deposits and withdrawals for the customer's checking, savings, and money market accounts. Often deposits and withdrawals to these accounts are accomplished as part of a single transaction, so they must all be committed together or all rolled back if the commit fails.

  How should you code the Checking button?

  

  A. OPEN_FORM('Checking');
  B. OPEN_FORM('Checking',SESSION);
  C. OPEN_FORM('Checking',SESSION,ACTIVATE);
  D. OPEN_FORM('Checking',SESSION,NO_ACTIVATE);
  A. OPEN_FORM('Checking');

• Question 135:

  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 cannot delete Record Group SOLD at run time.
  B. You cannot delete Record Group SHIP at run time.
  C. You should delete Record Group SOLD with built-in DELETE_GROUP('SOLD');
  D. You should delete Record Group SHIP with built-in DELETE_GROUP('SHIP');
  E. You should delete Record Group SOLD with built-in DELETE_GROUP_ROW('SOLD',ALL_ROWS);
  F. You should delete Record Group SHIP with built-in DELETE_GROUP_ROW('SHIP',ALL_ROWS);
  B. You cannot delete Record Group SHIP at run time.
  C. You should delete Record Group SOLD with built-in DELETE_GROUP('SOLD');

• Question 136:

  You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be decided by the user at run time. How should you define the appropriate data source?

  A. Define a data block based on a Ref Cursor.
  B. Define a data block based on a Table of Records.
  C. Define a data block based on a From Clause query.
  D. Define a data block based on a combination of a Ref Cursor and a Table of Records.
  E. Define a data block based on a From Clause query and define Transactional triggers for controlling DML statements.
  A. Define a data block based on a Ref Cursor.

• Question 137:

  You are developing a customer information application for a pay television company. The customer's home telephone number is used as the account number for the customer. Clerks must be able to update the telephone number in case of changes or data entry errors.

  A data entry clerk will typically open several forms from the Customers form that are synchronized with the currently selected customer using a global variable containing the telephone number.

  Although you also need to modify the other forms, what two triggers should you code in the Customers form to keep the forms synchronized in case the data entry clerk updates the telephone number or selects a different customer? (Choose two.)

  A. Pre-Query
  B. Post-Query
  C. Key-Next-Record
  D. When-New-Record-Instance
  E. When-Validate-Item for the phone number item
  F. When-New-Item-Instance for the phone number item
  D. When-New-Record-Instance
  E. When-Validate-Item for the phone number item

• Question 138:

  Some forms that you wrote have been through part of the testing cycle. One of the testers has reported encountering a navigation trap in your Orders form in which the cursor apparently is tuck?between two items. Which scenario could have caused the navigation trap?

  A. The Pre-Form trigger validates the user and time of day and also contains the code:GO_ITEM ('ORDERS.Date_Ordered'); This is an illegal call to a restricted built-in, resulting in the navigation trap.
  B. Two adjacent text items have When-New-Item-Instance triggers that fail when executed. This left the internal cursor with no place to go when the tester attempted to navigate to them, and there was a fatal error for the form.
  C. A Pre-Text-Item trigger allows the focus into the text item the first time it is executed, but subsequent execution raises a FORM_TRIGGER_FAILURE. A Pre-Text-Item trigger on a different text item also fails.
  D. The Next Navigation Data Block and Previous Navigation Data Block properties of the Orders and Order_Items blocks have been set so that the focus cannot move to the Inventories block.
  E. A When-Validate-Item trigger on a text item validates the contents of the wrong field, and you have coded a GO_ITEM() that sends the focus back to the item that invoked it.
  F. The Next Navigation Item and Previous Navigation Item properties of some text items have been set so that the user is stuck in an infinite navigation loop.
  C. A Pre-Text-Item trigger allows the focus into the text item the first time it is executed, but subsequent execution raises a FORM_TRIGGER_FAILURE. A Pre-Text-Item trigger on a different text item also fails.