Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 111:

  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 112:

  You are developing a Human Resources application, and you create an Employees button in the Departments form. The When-Button-Pressed trigger calls the Employees form to display the employees in the current department. You have set the Employees button properties so that navigation to the button does not occur. The Validation Unit property of the Departments form is set to Item.

  You want to ensure that the Department ID is valid prior to calling the Employees form, even if the user has updated the Department ID and has not navigated out of that item. The Department_Id item has a When-Validate-Item trigger that performs some complex validation logic.

  What code in the When-Button-Pressed trigger would force the When-Validate-Item trigger to fire for the Department_Id item without navigating from the item?

  A. ENTER;
  B. SYNCHRONIZE;
  C. REDISPLAY;
  D. SET_FORM_PROPERTY('departments',VALIDATION,PROPERTY_TRUE);
  E. SET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,ITEM_IS_VALID,PROPERTY_TRUE);
  F. You cannot programmatically cause validation without navigation.
  A. ENTER;

• Question 113:

  The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the Order_Date in descending order, because order entry clerks usually must access only the most recent orders.

  Which one of the following combinations of property settings for the Orders block will provide the fastest response time before a record appears in the block upon executing a query?

  A. Query Array Size: 0Number of Records Buffered: 0Query All Records: Yes
  B. Query Array Size: 1000Number of Records Buffered: 0Query All Records: Yes
  C. Query Array Size: 1000Number of Records Buffered: 0Query All Records: No
  D. Query Array Size: 0Number of Records Buffered: 1000Query All Records: No
  E. Query Array Size: 0Number of Records Buffered: 1000Query All Records: Yes
  D. Query Array Size: 0Number of Records Buffered: 1000Query All Records: No

• Question 114:

  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. Item Type
  B. Column Name
  C. Conceal Data
  D. Database Item
  E. Query Allowed
  F. Calculation Mode
  G. Validate from List
  D. Database Item

• Question 115:

  View the Exhibit.

  You are modifying the New_Orders form. You want to change the navigation order of the Orders block so that Order_Status is between Order_Date and Order_Mode in the navigation order.

  You attempt to drag the Order_Status item in the Object Navigator (as shown in the exhibit), but Forms does not allow you to release the item in the desired position.

  Why is this happening, and what can you do to change the navigation order?

  

  A. Because the data block is subclassed, you cannot change the order of items in the object navigator, but you can change item properties to affect the navigation order.
  B. Because the data block is subclassed, you can only drag objects to a lower position in the Object Navigator, so you can drag Order_Mode and Customer_Id to a position below Order_Status.
  C. Because the data block is subclassed, you will have to delete the object and then create it again in the desired position.
  D. Because the item is subclassed, you cannot change any of its properties.
  A. Because the data block is subclassed, you cannot change the order of items in the object navigator, but you can change item properties to affect the navigation order.

• Question 116:

  You created a query Record Group at design time.

  Which built-in can you use to execute the query defined in the Record Group object?

  A. ADD_GROUP_ROW
  B. POPULATE _GROUP
  C. ADD_GROUP_COLUMN
  D. SET_GROUP_SELECTION
  E. CREATE_GROUP_FROM_QUERY
  F. POPULATE _GROUP_WITH_QUERY
  B. POPULATE _GROUP

• Question 117:

  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');
  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);

• Question 118:

  View the Exhibit.

  You are developing a Human Resources application. There is a query-only form that displays employee IDs, names, and department numbers. When users double-click an employee ID, another form opens displaying all the columns from the

  EMPLOYEES table so that users can update the records (as shown in the exhibit).

  You use a global variable to pass the value for Employee_Id to the update form. When users modify the name and exit the update form, how can you synchronize the data in the query-only form so that the new name is displayed?

  

  A. Requery the data in a When-New-Form-Instance trigger of the query-only form.
  B. Requery the data in a Pre-Form trigger of the query-only form.
  C. Requery the data in a When-Form-Navigate trigger of the query-only form.
  D. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a When-New-Form-Instance trigger of the query-only form.
  E. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a Pre-Form trigger of the query-only form.
  F. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a When-Form-Navigate trigger of the query-only form.
  C. Requery the data in a When-Form-Navigate trigger of the query-only form.

• Question 119:

  View the Exhibit and examine the Property Palettes of the BONNY canvas and the CLYDE window. The requirements of the application specify that the CLYDE window should not be resizable.

  The form contains two items, both 50 points wide by 15 points high, which are associated with the canvas.

  The first item is a text item; the X Position property is 30, and the Y Position property is 40. The second item is a display item; the X Position property is 150, and the Y Position property is 250.

  What are two ways to allow the user to view the display item at run time? (Choose two.)

  

  A. At run time, with the cursor in the text item, press the Tab key.
  B. Define CLYDE as a modal window and display it with a horizontal scroll bar.
  C. Define CLYDE as a modeless window and display it with a horizontal scroll bar.
  D. Define CLYDE as a dialog window and display it with a horizontal scroll bar.
  E. Define CLYDE as a document window and display it with a vertical scroll bar.
  F. Define CLYDE as a modeless window and display it with a vertical scroll bar.
  E. Define CLYDE as a document window and display it with a vertical scroll bar.
  F. Define CLYDE as a modeless window and display it with a vertical scroll bar.

• Question 120:

  View the Exhibit.

  You are running the Employees form in debug mode and stepping through a procedure (as shown in the exhibit). You know that the stored function RAISE_SALARIES performs the correct calculation.

  Which Forms Builder menu item from the Debug menu should you select to position the marker on the line of code that begins as follows?

  IF :employees.salary > 2000

  

  A. Go
  B. Step Into
  C. Step Over
  D. Step Out
  E. Stop
  C. Step Over