Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 71:

  View the Exhibit.

  

  The orders form contains two canvases. Orders_CV displays one order and all of its order items.

  Help-CV displays context-sensitive help.

  When users invoke the help screen for the Customer_Id item, the help information obscures the Custormer_Id item, as shown in the Exhibit. Users would like to be able to see both the item and its help information simultaneously.

  How can you move the help information to the right so that the Customer_Id item is visible?

  A. increase the Viewport X Position on the Help_CV canvas.
  B. increase the Viewport X Position on Canvas on the Orders_CV canvas.
  C. Decrease the Width on the Help_CV canvas.
  D. in the Layout Editor for the Orders_CV canvas, select View > Stacked Views, and then select the Help_CV canvas. Drag the Help_CV canvas to the right of the Customer_Id item.
  A. increase the Viewport X Position on the Help_CV canvas.

  ---

  Note: Viewport X Position on Canvas, Viewport Y Position on Canvas property Description Specifies the location of the view's upper left corner relative to the upper left corner of the canvas. The size and location of the viewport define the view ; that is, the part of the canvas that is actually visible in the window to which the canvas is assigned. Applies to canvas

• Question 72:

  Users do not want to see the "Working" message while a long query completes.

  You are designing a form with a query that takes o long time to execute. What can you do to stop the "Working" message from appearing?

  A. Before the line of code that executes the query, add the line: :SYSTEM.MESSAGE_LEVEL := '10';
  B. Before the line of code that executes the query, add the line: :SYSTEM.SUPPRESS_WORKING : = 'TRUE';
  C. Use the SET_APPLICATION_PROPERTY built-in to set the message level in a When-New- Form- instance trigger.
  D. You do not need to do anything, the default behavior of Forms is to display the "Working" message only if you add code to do so.
  B. Before the line of code that executes the query, add the line: :SYSTEM.SUPPRESS_WORKING : = 'TRUE';

  ---

  You can turn the 'Working...' message off with system.suppress_working command.

  SYSTEM.SUPPRESS_WORKING examples

  Assume that you want to have the form filled with data when the operator enters the form. The following When-New-Form-Instance trigger will prevent the unwanted updates that would normally occur when you fill the blocks with data.

  :System.Suppress_Working := 'TRUE';

  Go_Block ('DEPT');

  Execute_Query;

  Go_Block ('EMP');

  Execute_Query;

  Go_Block ('DEPT');

  :System.Suppress_Working := 'FALSE';

• Question 73:

  View the Exhibit.

  

  You have defined the window, canvas, and text items shown in the Exhibit. What happens when click Run Form?

  A. The form runs with the cursor initially in TEXT_ITEM8.
  B. The form runs with the cursor initially in TEXT_ITEM9.
  C. The form does not compile until you move TEXT_ITEM8.
  D. The form does not compile until you move TEXT_ITEM10.
  A. The form runs with the cursor initially in TEXT_ITEM8.

• Question 74:

  The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is run from the Customers form, any queries should be restricted to the customer that is currently selected. The Customers form button

  that runs the Orders form sets a global variable to the current customer ID. The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:

  DEFAULT_VALUE (NULL, 'GLOBAL.Customer_id');

  IF: GLOBAL.customer_id IS NOT NULL

  THEN

  SET_BLOCK_PROPERTY ('orders', DEFAULT_WHERE, 'orders.customer_id = ' | | :GLOBAL.CUSTOMER_id);

  END IF;

  EXECUTE_QUERY

  You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders form.

  What changes must you make to the code so that the menu code functions as it does in the form?

  A. Change both occurrence of :GLOBAL.customer_id to 'GLOBAL.customer_id'.
  B. Change 'GLOBAL.customer_id' in line 1 to :GLOBAL.customer_id.
  C. Change both occurrence of :GLOBAL.customer_id to NAME_IN ('GLOBAL.customer_id').
  D. You do not need to change anything; the code compiles and functions correctly in the menu item.
  E. You cannot add this type of code in the menu because it refers to the items on the form that cannot be referenced from a menu.
  C. Change both occurrence of :GLOBAL.customer_id to NAME_IN ('GLOBAL.customer_id').

  ---

  Because you cannot refer directly to form values in menu code, change :GLOBAL.customer_id to the following indirect reference: NAME_IN('GLOBAL.customer_id')

  Note: You could also change the references to the global variable to use the NAME_IN built-in; however, this is not strictly necessary, because global variables are available directly throughout the application.

  Reference: Managing Oracle Forms Menu Modules

• Question 75:

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

  ---

  SYSTEM.trigger_block: The block that the input focus was in when the trigger initially fired.

  Note: Uses for Trigger Focus Variables The variables for locating trigger focus are useful for navigating back to the initial block, record,and item after the trigger code completes. For example, the trigger code may navigate to otherblocks, records, or items to perform actions upon them, but after the trigger fires, you may wantthe cursor to be in the same item instance that it was in originally. Because the navigation in thetrigger occurs behind the scenes, the user will not even be aware of it.

• Question 76:

  Which statement is always true about a visual indicator that a text item has a list of values associated with it?

  A. An iconic list button appears next to the text item.
  B. A list of values lamp appears as a tool tip when the cursor is placed over the text item.
  C. A list of values lamp appears next to the text item.
  D. A list of values lamp appears on the status line when the cursor enters the text item.
  E. A button with an ellipsis appears in the text Item when the cursor enters the text item.
  A. An iconic list button appears next to the text item.

  ---

  Example, Address has a list of values:

  

• Question 77:

  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 and display them in multiple modeless windows.
  B. Define multiple content canvases and display them in the same modeless window.
  C. Define multiple content canvases and display them in multiple modal windows.
  D. Define multiple content canvases; display one in a modeless window and the others in modal windows.
  E. This is not possible because items from a single block must be displayed on the same canvas and window.
  D. Define multiple content canvases; display one in a modeless window and the others in modal windows.

  ---

  Note 1:

  The most common canvas type is the content canvas (the default type). A content canvas is the "base" view that occupies the entire content pane of the window in which it is displayed. You must define at least one content canvas for each

  window you create.

  Note 2:

  Modal and Modeless Windows in Oracle Forms

  A window in oracle forms is a container for all visual objects that make up a Forms application. You can create two different type of windows in oracle forms. Lets have a brief comparisons between these two types of windows.

  *

  Modal Window:

  A modal window is a restricted window that the user must respond to before moving the input focus to another window. Modal windows:

  Must be dismissed before control can be returned to a modeless window Become active as soon as they display

  Require a means of exit or dismissal

  *

  Modeless Window:

  A modeless window is an unrestricted window that the user can exit freely. Modeless windows:

  Can display many at once

  Are not necessarily active when displayed

  Are the default window type

• Question 78:

  A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the problem, so you decide to use remote debugging.

  The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?

  1.

  You set a breakpoint in the When Button-Pressed trigger for the invoice button.

  2.

  The user's screen goes blank.

  3.

  The user reports the host and port to you.

  4.

  You uses the debugger to step through the code.

  5.

  The user clicks a button that calls DEBUG.ATTACH.

  6.

  You attach to the user's process.

  7.

  You open the Orders.fmb file from which the running .fmx was generated.

  8.

  The user clicks the invoice button.

  A. 5, 3, 6, 7, 1, 8, 2, 4
  B. 8, 3, 6, 5, 4, 7, 1, 2
  C. 7, 1, 3, 6, 5, 1, 8, 4
  D. 3, 6, 5, 7, 8, 1, 2, 4
  A. 5, 3, 6, 7, 1, 8, 2, 4

• Question 79:

  The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.

  You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.

  

  You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:

  

  The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?

  A. Change the initial Value property to Good.
  B. Change the Check Box Mapping of Other Values property to Not Allowed.
  C. Change the initial Value property to Good and the Value When Unchecked property to Null.
  D. Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.
  E. Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.
  F. Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.
  E. Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.

  ---

  

  Incorrect answers:

  F: A check box is not limited to two values.

• Question 80:

  You have just created radio buttons labeled Outstanding, Exceeds, Meets, and Does not Meet for the employee appraisal rating, but you accidentally created it on the Employee_Training canvas rather than on the Employee_Appraisal canvas. How can you move them to the appropriate canvas?

  A. Open the Layout Editor for both canvases; drag the radio buttons from Employee_Training canvas to the Employee_Appraisal canvas.
  B. Drag the radio button nodes from the Object Navigator to the Employee Appraisal canvas in the Layout Editor.
  C. Drag the radio group node from the Object Navigator to the Employee__Appraisal canvas in the Layout Editor.
  D. Set the Canvas property for the radio buttons to Employee_Appraisal
  E. Set the Canvas property for the radio group to Employee_Appraisal.
  F. You cannot move existing radio buttons to another canvas; you will need to delete them from the Employee_Training canvas and create new ones on the Employee_Appraisal canvas.
  A. Open the Layout Editor for both canvases; drag the radio buttons from Employee_Training canvas to the Employee_Appraisal canvas.

  ---

  Note: Example of radio group:

  Creating radio buttons

  We will now create radio buttons for the Sex item to give the user an option of selecting either Male or Female.28.

  *

  To do this, right click on the Sex

  item in the Layout Editor and go to itsProperty palette.

  *

  In the Property Palette, Set:- Item Type : Radio Group- Initial Value : M30.

  Once you return back to the Layout Editor, you have to insert radio buttons.Select Radio Button icon from the toolbox. Drop the radio button into the form.

  *

  A window will appear, prompting you to select the radio group you would liketo attach this radio button to. Select the radio group Sex .