Oracle Oracle Certifications 1Z0-151 Questions & Answers

• Question 31:

  View the Exhibits.

  

  The hierarchical tree shown at run time in Exhibit 1 is populated programmatically. Default hierarchical tree properties are shown in Exhibit?

  

  Which properties of the hierarchical tree shown in Exhibit 1 have been changed from the default?

  A. Allow Empty Branches and Multi Selection only

  B. Allow Empty Branches and Show Symbols only

  C. Multi Selection and Show Symbols only

  D. Allow Empty Branches, Multi Selection, and Show Symbols

  Correct Answer: A

  Both Chen and Popp are selected, so Multi-selection is set to Yes (not B). + and symbols are displayed, so Show Symbols is yes (not B, C, D). Allow Empty Branches is set to Yes (so A is ok), see note below.

  Note: Setting Hierarchical Tree Item Properties Hierarchical Tree properties include the following:

  *

  Item Type: Must be set to Hierarchical Tree

  *

  Allow Empty Branches: Yes / No. No is the default.

  If set to Yes, all leaf nodes will initially display in the tree with the plus sign (+) next to it, indicating that expansion is possible, even when there is nothing to expand. If set to Yes, the Show Symbols property must also be set to Yes.

  If set to No, leaf nodes will not have an expand/collapse symbol

  *

  Multi Selection: Whether multiple nodes may be selected at one time No is the default.

  *

  Show Lines: Whether a hierarchical tree displays lines leading up to each node Yes is the default.

  *

  Show Symbols: Whether a hierarchical tree should display + or - symbols in front of each branch node

  *

  Record Group: Name of the record group from which the hierarchical tree derives its values

  *

  Data Query: Specifies the query-based data source

• Question 32:

  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

  Correct Answer: B

  Note: Toolbar canvases can contain buttons and other GUI elements, and allow you to provide a common interface for all canvases displayed within a window. You can associate the toolbar canvas with the window shared by the content canvases, and it will display. The location at which the toolbar displays can be controlled by the type of toolbar canvas used. A vertical toolbar canvas is used to display the toolbar along the left or right edge of the window.

• Question 33:

  In the Orders form, users often have a need to return to the first record. Because there are many employee records, it may take a long time for them to scroll up to the first record, so you create a button with the label First Record.

  When users click the first Record button, you want to display your own custom message instead of the

  system message "FRM-40100: At first record."

  The system message should be displayed in other cases when users attempt to scroll above the first

  record.

  You code the following When-Button-Pressed trigger:

  :SYSTEM.mesage_level := '5'

  UP;

  WHILE FORM_SUCCESS LOOP

  UP;

  END LOOP;

  MESSAGE ('This is the first Order');

  The button works perfectly to return to the first record and display your custom message instead of the

  system message. However, users report that as they continue to use the form after clicking the button, no

  longer see other helpful messages. For example, the message "FRM 40102:

  Record must be entered or deleted first" no longer appears when they attempt to scroll past the last record.

  How can you resolve this Issue so that all system messages continue to be displayed after the trigger code

  runs?

  A. instead of setting the system message level to 5 in the code, set it to 50.

  B. instead of setting the system message level to 5 in the code, set it to 25.

  C. Add the line of code just before the end of the loop to reset the system message level.

  D. Add a line of code just after the end of the loop to reset the system message level.

  E. Instead of setting the system message level in the When-Button-Pressed trigger, use an On- Error trigger to customize the message.

  F. Set the system message level in a When-New-Form-Instance trigger, so that all system messages appear except when in the scope of the trigger.

  Correct Answer: F

  Incorrect answers:

  A, B: changing the system message level would not help.

  C, D: The line would have to be added after the line MESSAGE ('This is the first Order'); in order to work.

• Question 34:

  You have the Orders form open in Forms Builder. You create an object group in the Orders form and try to drag various components in the Object Navigator to the object group.

  Which two components will you be unable to place in the object group?

  A. the Orders block of the Orders form

  B. the Order_CV canvas of the Orders form

  C. the When-New-Item- instance trigger of the Order_Items.Quantity item in the Orders form

  D. the When-New Form-instance trigger of the Orders form

  E. the Product_id item in the Order_Items block of the Orders form

  Correct Answer: CE

  C: Object libraries can contain individual items; for example, iconic buttons. The smallest unit accepted in an object group is a block.

  E: Including a block in an object group also includes its items, the item-level triggers, the block- level triggers and the relations. You cannot use any of these objects in an object group without the block.

  Incorrect answers:

  A: Including a block in an object group also includes its items, the item-level triggers, the block- level triggers and the relations

  Note: An object group is a logical container for a set of Forms Builder objects. You need to define an object group when you want to package related objects for copying or subclassing in another module or if you want to bundle numerous objects into higher-level building blocks that you can use again in another application. You can package the various objects in an object group and copy the entire bundle in one operation.

• Question 35:

  You want to display fields of a form module on multiple layouts that are visible simultaneously, what can enable you to achieve this?

  A. multiple content canvases that display in the same window

  B. one content canvas that displays in multiple windows

  C. multiple content canvases that display in multiple windows

  D. multiple forms, because you cannot have multiple content canvases in the same form that are visible simultaneously

  Correct Answer: A

  There is a basic difference between canvas and windows is that a canvas is placeholder for several controls. A window may contain several canvases.

• Question 36:

  You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:

  GO_BLOCK('orders'); EXECUTE_QUERY;

  This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?

  A. Set the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.

  B. Add the following as the first of the key-Exqry trigger to Yes. SYSTEM.mode := 'NORMAL';

  C. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK ('orders'); ENTER_QUERY;

  D. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block: ENTER_QUERY; GO_BLOCK ('orders');

  E. Change the key-Exqry trigger to: IF : SYSTEM.MODE := 'ENTER-QUERY' THEN GO_BLOCK ('orders'); EXECUTE_QUERY; ELSE MESSAGE ('you cannot execute a query for the Order_Items block'): END IF; Define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK ('orders'); ENTER_QUERY

  F. Change the Key-Exeqry trigger to: IF :SYSTEM.MODE != 'ENTER-QUERY' THEN GO_BLOCK('orders'); EXECUTE_QUERY; ELSE MESSAGE ('You cannot execute a query in this block'); ENTER_QUERY; GO_BLOCK ('orders');

  G. You cannot change this behavior, but you should use the On-Message trigger to display a more meaningful message.

  Correct Answer: C

  Note: You can use system variables and built-ins to obtain information about queries.

  Using SYSTEM.mode

  Use the SYSTEM.mode system variable to obtain the form mode. The three values are NORMAL ,

  ENTER_QUERY , and QUERY.

  NORMAL Indicates that the form is currently in normal processing mode. ENTER-QUERY Indicates that

  the form is currently in Enter Query mode. QUERY Indicates that the form is currently in fetch processing

  mode, meaning that a query is currently being processed.

  Note 1: ENTER_QUERY procedure

  Clears the current block and creates a sample record. Operators can then specify query conditions before

  executing the query with a menu or button command.If there are changes to commit, the Forms Builder

  prompts the operator to commit them before continuing ENTER- QUERY processing

  Note 2: EXECUTE_QUERY procedure

  Clears the current block, opens a query, and fetches anumber of selected records. If there are changes

  tocommit, Forms Builder prompts the operator to committhem before continuing EXECUTE-

  QUERYprocessin

• Question 37:

  The Orders application enables the Orders form to be opened from the Customers form. Users are confused because when they save a new or changed order, they sometimes receive an error message that indicates that no changes have been made.

  What could be the possible cause of this problem?

  A. The Orders form is Opened in the same session as the Customers form.

  B. The Orders form is opened in a different session from the Customers form.

  C. The Orders form is opened in ACTIVATE mode.

  D. The Orders form is opened in NO_ACTIVATE mode.

  E. The trigger that opens the Orders form calls COMMIT_FORM after open form.

  Correct Answer: E

  If you want to end the current transaction before opening the next form, call the COMMIT_FORM built-in before OPEN_FORM. You can check to see if the value of :SYSTEM.form_status='CHANGED' to decide whether a commit is needed. Alternatively, you can just post changes to the database with POST , then open the nextform in the same transaction

  Note: Control and Transactions WhenOpening Another Form When you use OPEN_FORM

  *

  By default, control passes immediately to the Orders formand no statements after OPEN_FORM are processed

  *

  If the Activate_Mode argument is set to NO_ACTIVATE ,you retain control in the current form

  *

  The transaction continues unless it was explicitlycommitted before

• Question 38:

  Which setting of :SYSTEM.MESSAGE_LEVEL suppresses all system messages?

  A. 0

  B. 10

  C. 25

  D. 50

  E. You cannot use :SYSTEM.MESSAGE_LEVEL to suppress all system messages

  Correct Answer: E

  Controlling System Messages You can prevent system messages from being issued, based on their severity level. FormsBuilder classifies every message with a severity level that indicates how critical or trivial the information is; the higher the numbers, the more critical the message. There are six levels that you can affect.

  

  Note: Suppressing Messages According to Their Severity In a trigger, you can specify that only messages above a specified severity level are to be issuedby the form. You do this by assigning a value to the MESSAGE_LEVEL system variable. Formsthen issues only those messages that are above the severity level defined in this variable.The default value for MESSAGE_LEVEL (at form startup) is 0. This means that messages of all severities are displayed.

• Question 39:

  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.

  Correct Answer: A

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

  You have been assigned to maintain a forms application that was designed by a developer who has left the company.

  The form uses different property classes to standardize the appearance of objects in the form. For example, all buttons should be of the same width.

  The CV_Tools canvas contains several buttons. The Print invoice button is not quite wide enough to display its complete label.

  In forms Builder, you open the Button_PC property class and change its Width property to a higher number. All the buttons become larger except the Print invoice button, which remains its original size. What could have caused this problem?

  A. The Print invoice button was copied from, rather than subclassed from, the Button_PC property class.

  B. The subclass information property for the Print invoice button is blank.

  C. The Width property of the Print invoice button is an inherited property.

  D. The Width property of the Button_PC property class is a variant property.

  E. The X Position of the print invoice button is a variant property.

  F. The X Position Property is not included in the Button_PC property

  Correct Answer: A