Online Access Free 1z0-151 Exam Questions

When you plan to use a toolbar canvas, you should allow room for it on the content canvas so that items on the canvas are not obscured.

• A.True
• B.False

View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!');
end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

• A.IF ERROR_CODE = 06512 THEN
  MESSSAGE (SQLERRM);
  END IF;
• B.IF ERROR_CODE = 40509 THEN
  MESSSAGE (SQLERRM);
  END IF;
• C.IF ERROR-CODE = 20101 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF;
• D.IF ERROR_CODE = 20101 THEN
  MESSSAGE(SQLERRM);
  END IF;
• E.IF ERROR_CODE = 40509 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF
• F.IF ERROR_CODE = 06512 THEN
  MESSSAGE(DBMS_ERROR_TEXT);
  END IF;

You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in the form. The code (with line numbers added) is:
1. PROCEDURE get_image IS
2. Product_image_id ITEM := FIND_ITEM ('control.product_image');
3. Filename VARCHAR2(250);
4. BEGIN
5. Filename := TO_CHAR(:order_items.product_id) | | '.jpg';
6. READ_IMAGE_FILE (filename, 'jpeg', product_image_id);
7. END;
Management wants all codes to be in PL/SQL libraries to facilitate reuse. You create a PL/SQL library and drag the program unit from the orders form to the Program Units node of the library. You then delete the program unit from the Orders form.
What three things must you do to compile the PL/SQL library and to use the code in the Orders form?

• A.Change the way the program unit is called in the Orders form.
• B.Delete the BEGIN and END statements (lines 4 and 7).
• C.Generate the a .plx file.
• D.Attach the library to the orders form.
• E.insert the RELEASE keyword between lines 1 and 2.
• F.Change line 5 to:
  filename := to_char(name_in 'order_items.product_id' )) | | '.jpg';.
• G.Save the library.
• H.Change product_id to an in parameter and filename to an OUT parameter.

The Orders form has three blocks: Orders, Orders_Items, and inventories. It also has a button labeled Next Block with a When-Pressed trigger.
IF :SYSTEM.cursor_block = 'orders' THEN
GO_BLOCK('order_items');
ELSIF :SYSTEM.cursor_block = 'order_items' THEN
GO_BLOCK('inventories');
ELSIF :SYSTEM.cursor_block = 'inventories' THEN
GO_BLOCK ('orders');
END IF;
The button is not functioning correctly; it does not cause navigation to occur. What must you do to fix the issue?

• A.Move the code to a PL/SQL program unit.
• B.Change the block names to uppercase in the condition (IF ...THEN) statements.
• C.Use system variables in the GO_BLOCK statements.
• D.Change all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.
• E.Change the block names to uppercase in the GO_BLOCK statements.
• F.instead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK

The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?

• A.Define multiple content canvases; display one in a modeless window and the others in modal windows.
• B.Define multiple content canvases and display them in multiple modeless windows.
• C.Define multiple content canvases and display them in the same modeless window.
• D.This is not possible because items from a single block must be displayed on the same canvas and window.
• E.Define multiple content canvases and display them in multiple modal windows.