Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 101:

  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. OPEN_FORM('ORDERS',NO_ACTIVATE);
  B. OPEN_FORM('MY_ORDERS',NO_ACTIVATE);
  C. IF NOT FIND_FORM('ORDERS') THENOPEN_FORM('MY ORDERS');ELSEGO_FORM('ORDERS');END IF;
  D. IF ID_NULL(FIND_FORM('ORDERS')) THENOPEN_FORM('ORDERS');ELSEGO_FORM('ORDERS');END IF;
  E. IF ID_NULL(FIND_FORM('ORDERS')) THENOPEN_FORM('MY_ORDERS');ELSEGO_FORM('ORDERS');END IF;
  F. IF NOT FIND_FORM('MY_ORDERS') THENOPEN_FORM('ORDERS');ELSEGO_FORM('ORDERS');END IF;
  E. IF ID_NULL(FIND_FORM('ORDERS')) THENOPEN_FORM('MY_ORDERS');ELSEGO_FORM('ORDERS');END IF;

• Question 102:

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

  The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. The DBA ran a SQL script to populate that column. You want to update the Orders form to display the additional data. You currently have a non-base-table display item in the Orders block called Order_Total that you no longer want to use. The Order_Total item is located on the canvas in the position where you want the Order_Status item to appear. You open the Property Palette for Order_Total, change its name to Order_Status, and change its item type to Text Item.

  You run the form, but when you execute a query on the block, no data is displayed in the Order_Status item. What should you do to correct this problem?

  A. Set the Database Item property to Yes for the Order_Status item.
  B. Use the form to populate the Order_Status item, since the SQL script that the DBA ran obviously did not work.
  C. Set the Name property for the Order_Status item to ORDER_STATUS, because it must be uppercase to match the column name in the database.
  D. Use the Data Block Wizard in reentrant mode to add the item, because you cannot add a base table item by changing the item type of an existing item.
  A. Set the Database Item property to Yes for the Order_Status item.

• Question 104:

  View the Exhibit.

  In the Human Resources form shown in the exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id fields in the Departments data block.

  What must you select prior to invoking the Layout Wizard in reentrant mode to modify these item properties?

  

  A. Frame5
  B. Frame8
  C. Canvas4
  D. the Departments block
  E. the DEPARTMENT_ID, MANAGER_ID, and LOCATION_ID items
  A. Frame5

• Question 105:

  Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that credit ratings can be recorded. To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item. You want to allow for an undetermined (Null) credit rating, and users should be able to update the credit rating from a value to an undetermined rating.

  How can you implement this?

  A. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to Null.
  B. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to one of the credit ratingvalues.
  C. Create four radio buttons, and leave blank the value for the undetermined credit rating.
  D. Choose a different type of input item, because radio groups do not allow entry and update of null values.
  C. Create four radio buttons, and leave blank the value for the undetermined credit rating.

• Question 106:

  You need to resize the INVENTORY tab canvas. The Viewport Width and Height properties are 200 and 300. You change the values to 150 and 120, respectively.

  What implication may this have on your design?

  A. Some tab pages may be obscured at run time.
  B. By decreasing the Viewport Width property, some tab pages may be deleted.
  C. Objects previously within the borders of a tab page may fall outside the tab page border, and you will get compilation errors.
  D. Objects previously within the borders of a tab page may fall outside the tab page border and will be visible at run time only by navigating to them programmatically.
  E. Objects previously within the borders of a tab page may fall outside the tab page border and will be assigned to the null canvas.
  C. Objects previously within the borders of a tab page may fall outside the tab page border, and you will get compilation errors.

• Question 107:

  What type of message indicates a Forms message that cannot be suppressed?

  A. a Busy message
  B. a level 0 message
  C. a Working message
  D. a level 25 message
  E. a level 50 message
  F. a message with a level less than 0
  G. a message with a level greater than 25
  H. a message with a level greater than 50
  G. a message with a level greater than 25

• Question 108:

  View the Exhibit.

  You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhibit, when the query cannot be performed you want to display to the user a

  message with the actual database error that is received.

  What can you do to implement this?

  

  A. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built-in:IF NOT FORM_SUCCESS THENmessage(DBMS_ERROR_TEXT);END IF;
  B. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built-in:IF NOT FORM_SUCCESS THENmessage(SQLERRM);END IF;
  C. Place this code in a form-level On-Error trigger:IF ERROR_CODE = 40505 THENmessage (DBMS_ERROR_TEXT);END IF;
  D. Place this code in a form-level On-Error trigger:IF ERROR_CODE = 40505 THENmessage (SQLERRM);END IF;
  E. Add this exception handler to the When-New-Form-Instance trigger:EXCEPTIONWHEN ERROR_CODE = 40505 THENMESSAGE(DBMS_ERROR_TEXT);
  F. Add this exception handler to the When-New-Form-Instance trigger:EXCEPTIONWHEN ERROR_CODE = 40505 THENMESSAGE(SQLERRM);
  C. Place this code in a form-level On-Error trigger:IF ERROR_CODE = 40505 THENmessage (DBMS_ERROR_TEXT);END IF;

• Question 109:

  View the Exhibit.

  You are coding a trigger (shown in the exhibit) to display the database error that occurs when users encounter the FRM-40505 error about being unable to execute a query. You have created an alert called Query_Alert. For the FRM-40505

  error, the trigger should display the database error message in the Query_Alert. For all other errors, the trigger should display default messages on the console message line.

  Examine the code for the On-Error trigger. When you attempt to compile this trigger, you receive a compilation error with the message "Error 215 at line 2, column 4: String length constraints must be in range (1..32767)".

  What corrections should you make so that the trigger compiles and functions properly?

  

  A. Eliminate the n variable because SHOW_ALERT does not return a value.
  B. Change the n variable to a NUMBER data type and change SLQERRM to DBMS_ERROR_TEXT.
  C. Change the n variable to a NUMBER data type, replace SHOW_ALERT with FIND_ALERT, and change the line beginning withSET_ALERT_PROPERTY to SET_ALERT_MESSAGE_PROPERTY('Query_Alert',SQLERRM);.
  D. Change all occurrences of error_code, error_type, and error_text to message_code, message_type, and message_text.
  B. Change the n variable to a NUMBER data type and change SLQERRM to DBMS_ERROR_TEXT.

• Question 110:

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