Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 81:

  You created a LOV based upon a three-column Record Group called CUST, which was created at design time.

  View the Exhibit and examine the structure of the CUST Record Group. At run time, the user sometimes requires the LOV to be populated from the PROD Record Group.

  Which two built-ins will enable you to create the PROD Record Group and repopulate the LOV? (Choose two.)

  

  A. RETRIEVE_LIST(lov_id, 'PROD');
  B. POPULATE_LIST(lov_id, 'PROD');
  C. SET_LOV_PROPERTY(lov_id,GROUP_NAME,'PROD');
  D. CREATE_GROUP_FROM_QUERY ('PROD','SELECT P_id, '||' date_sold as Date, Name as Desc '||' from products ' );
  E. CREATE_GROUP_FROM_QUERY ('PROD','SELECT P_id as ID, '||' Name as Desc, date_sold as Date '||' from products ' );
  F. CREATE_GROUP_FROM_QUERY ('PROD','SELECT rownum as Index, P_id as ID, '||' Name as Desc, date_sold as Date '||' from products ' );
  C. SET_LOV_PROPERTY(lov_id,GROUP_NAME,'PROD');
  E. CREATE_GROUP_FROM_QUERY ('PROD','SELECT P_id as ID, '||' Name as Desc, date_sold as Date '||' from products ' );

• Question 82:

  View the Exhibit.

  You want to create a menu item to enable users to sort the tabular display of a form either by customer ID, last name, or department ID. You decide to create a radio group as shown at run time in the exhibit.

  Which statement about this radio group is true?

  

  A. You must create the radio group before creating Radio menu items for it.
  B. You must create a Radio menu item before the radio group is created.
  C. You must name the radio group the same as the submenu name so that it will be associated with that submenu.
  D. You must name the radio group Sort, the same as the submenu label, so that it will be associated with that submenu.
  B. You must create a Radio menu item before the radio group is created.

• Question 83:

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

  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 rating values.
  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 85:

  You are developing a form that uses alerts to display database messages rather than associated FRM messages when the SQL statements issued by the form cause database errors to occur. You use a generic alert called DB_Alert to

  display the messages.

  You begin to code an On-Error trigger to trap the FRM-40505 error that occurs when the SQL statement references an invalid column name. The associated database message is "ORA-00904:

  Invalid column name", and this is what you want to be displayed in the alert.

  You create a form-level On-Error trigger with the following code:

  DECLARE

  n NUMBER;

  BEGIN

  IF ERROR_CODE = 40505 THEN

  SET_ALERT_PROPERTY('DB_Alert',ALERT_MESSAGE_TEXT,

  DBMS_ERROR_CODE);

  n := SHOW_ALERT('DB_Alert');

  END IF;

  END;

  You run the form to test it. What will the run-time behavior be when the FRM-40505 error is encountered?

  A. The alert called DB_Alert appears with the message "ORA-00904: Invalid column name".
  B. The alert called DB_Alert appears, but not with the correct message.
  C. The alert does not appear, and the FRM-40505 message appears on the message line.
  D. The alert does not appear, and the message "ORA-00904: Invalid column name" appears on the message line.
  E. The alert does not appear, and the message "FRM-41039: Invalid Alert ID 0" appears on the message line.
  B. The alert called DB_Alert appears, but not with the correct message.

• Question 86:

  View the Exhibit to examine the form.

  The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the CONTROL block. The Mouse Navigate property of the button has been set to No.

  The following code has been written in a When-Button-Pressed trigger on the Check_Values button:

  MESSAGE(:field1||' - '||

  NAME_IN(:SYSTEM.cursor_item)||' - '||

  NAME_IN('SYSTEM.cursor_item'));

  With the focus in FIELD1, and the values field1, field2, and field3 in the text items, what message will be displayed when the button is clicked?

  

  A. field1 - field1 - field1
  B. field1 - field2 - field3
  C. field1 - field2 - Check Values
  D. field1 - field1 - Check Values
  E. field1 - field1 - CONTROL.FIELD1
  F. CONTROL.FIELD1 - CONTROL.FIELD1 - field1
  G. CONTROL.FIELD1 - CONTROL.FIELD2 - field3
  E. field1 - field1 - CONTROL.FIELD1

• Question 87:

  The Orders form has two base table blocks and a control block. There is an Execute Query button in the control block with the following When-Button-Pressed trigger:

  DO_KEY('execute_query');

  A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: "This function cannot be performed here."

  What can you do to fix this error?

  A. Define a Key-Exeqry trigger at the form level.
  B. Set the Mouse Navigate property to No for the Execute Query button.
  C. Set the Query All Records property to Yes for the Order Items block.
  D. Set the Query Allowed property to Yes for at least one item in the Order Items block.
  B. Set the Mouse Navigate property to No for the Execute Query button.

• Question 88:

  View the Exhibit.

  You created and compiled the Summit menu whose properties are shown in the exhibit. You attach the menu to the Orders form and run it to test the menu.

  In addition to the Window item, which items from the Summit menu will appear in the top-level menu of the running form when the Summit menu is displayed?

  

  A. Menu1 only
  B. Save and Exit only
  C. File, Edit, Reports, and Applications
  D. File_Menu, Edit_Menu, Reports_Menu, and Applications_Menu
  E. Save, Exit, Cut, Paste, Order, Invoice, Customers, and Warehouse
  B. Save and Exit only

• Question 89:

  The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. You want to update the Order Entry form to display the additional data. You open the Layout Editor for the canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. You use the text item tool to create a new text item on the canvas, then open its Property Palette and set the Name property to ORDER_STATUS and the Column Name property to Order_Status. When you run the form to test it, you receive the error "FRM 40505 ORACLE error unable to perform query."

  What could be the cause of this error?

  A. You did not change the default value for the Data Type property of the Order_Status text item.
  B. You did not modify the WHERE clause of the Orders block to include the ORDER_STATUS column.
  C. You did not change the default value for the Database Item property of the Order_Status text item.
  D. You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item.
  E. You did not define the Column Name in uppercase so that the column value can be retrieved from the database.
  D. You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item.

• Question 90:

  View the Exhibit.

  You are coding a When-New-Form-Instance trigger to populate a hierarchical tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. King, the president of the company, is the only employee who does not have a

  manager.

  In the trigger, you declare a variable called rg_emps that is of the RECORDGROUP data type. You will use this record group to populate the tree. You use the following code to create the record group:

  rg_emps := Create_Group_From_Query('rg_emps', 'select 1, level, last_name, NULL, to_char (employee_id) from employees connect by prior employee_id = manager_id start with manager_id is null');

  You then programmatically populate the record group, and then populate the tree with the record group.

  You run the form to test it. Will the tree initially appear as shown? If not, why not?

  

  A. Yes, the tree will appear as shown.
  B. No. The first element selected in the select statement should be 4 because you want four levels of the tree to be displayed.
  C. No. You should eliminate the last element selected in the select statement, because you do not want to display the employee ID.
  D. No. The "connect by" statement should be "connect by prior manager_id = employee_id".
  A. Yes, the tree will appear as shown.