Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 31:

  You are coding a When-Checkbox-Changed trigger.

  Which statements are available for use in your code?

  A. unrestricted built-ins only
  B. restricted and unrestricted built-ins only
  C. PL/SQL statements and unrestricted built-ins only
  D. PL/SQL statement-, and any built-ins
  D. PL/SQL statement-, and any built-ins

  ---

  When-Checkbox-Changed trigger Description Fires when an operator changes the state of a check box, either by clicking with the mouse, or using thekeyboard. Definition Level: form, block, or item Legal Commands: SELECT statements, unrestricted built-ins, restricted built-ins

  Reference: Oracle Forms Developer, When-Checkbox-Changed trigger

• Question 32:

  A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.

  Possible navigation units that can occur during navigation of this form are:

  1.

  Outside the form

  2.

  The Human Resources form

  3.

  The Departments block

  4.

  The Employees block

  5.

  The current Departments record

  6.

  The current Employees record

  7.

  The Department_Id item

  8.

  The Employee_Id item

  With the cursor in : Departments.Department_Id, the clerk clicks the :Employees.Employee_Id item. What is the sequence of navigational unit movement that occurs?

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

• Question 33:

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

  B. 10
  C. 25
  D. 50
  E. You cannot use :SYSTEM.MESSAGE_LEVEL to suppress all system messages
  E. You cannot use :SYSTEM.MESSAGE_LEVEL to suppress all system messages

  ---

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

  Which two actions are always necessary when deploying Forms applications that were developed on Windows platform to a UNIX middle tier server?

  A. moving the forms executable files from the development machine to the middle-tier machine
  B. compiling the Forms modules on the middle tier machine
  C. creating a menu module for the application
  D. compiling the Forms modules on the development machine
  E. moving the Forms source files from the development machine to the middle tier machine
  F. creating a Forms PL/SQL library file to contain the application logic
  G. installing forms Builder on the middle-tier machine
  A. moving the forms executable files from the development machine to the middle-tier machine
  D. compiling the Forms modules on the development machine

  ---

  Once you have created your application in Forms Developer, you are ready for application Web deployment. Oracle Forms Services accesses an application in Oracle Fusion Middleware through a specified URL. The URL then accesses the

  HTTP Listener, which communicates with the Listener Servlet. The Listener Servlet starts a Forms run- time process (frmweb.exe on Windows or frmweb on UNIX and Linux) for each Forms Services session.

  Note:

  To deploy a basic form with the default parameters set up by the installer:

  1.

  Create your application in Forms Developer and save it. The .fmb file is a design time file that can only be opened in Forms Developer. The .fmx file is the run-time file created when you compile the .fmb and is used for Web deployment.

  2.

  Modify the formsweb.cfg file so that Oracle Forms Services can access your application module.

  3.

  Make sure the .fmx file location is specified in the FORMS_PATH environment variable.

  4.

  To modify an environment file, select the file in the Environment Configuration page of Fusion Middleware Control and add or edit environment variables as needed by your application

  5.

  Enter the name of your application in the URL as shown:

  http://example.com:8888/forms/frmservlet?

  where "example" is the hostname of your computer and "8888" is the port used by your HTTP Listener. Once you have created a configuration section, add "config=" and the name of the configuration section. In this example, the URL to

  access hrapp.fmx is:

  http://example.com:8888/forms/frmservlet?config=my_

  application

• Question 35:

  You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.

  How should you investigate the source of the problem?

  A. Check the Pre-Text-Item and Post-Text-Item triggers, because users may be encountering a navigation trap.
  B. Check the Navigation properties of the Orders block that have non-default values.
  C. Check the Navigation properties of the Order Items block that have non-default values.
  D. Check the Navigation properties of the items in the Orders block that have non-default values.
  E. Check the Navigation properties of the form that have non-default values.
  F. Check that the items in the Order Items block are enabled.
  A. Check the Pre-Text-Item and Post-Text-Item triggers, because users may be encountering a navigation trap.

  ---

  The Navigation Trap You have seen that the Pre-and Post-navigation triggers fire during navigation, and when they fail the internal cursor attempts to return to the current item(SYSTEM.CURSOR_ITEM).The diagram below illustrates the navigation trap. This can occur when a Pre-or Post-navigation trigger fails and attempts to return the logical cursor to its initial item. However, if the initial item has a Pre-Text-Item trigger that also fails the cursor has nowhere to go, and a fatal error occurs. Note: Be sure to code against navigation trigger failure

  

• Question 36:

  To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?

  A. When-New-Form-instance
  B. When-New-Block-instance
  C. On-Query
  D. Pre-Query
  E. Post-Query
  D. Pre-Query

  ---

  About controlling queries with Pre-Query and Post-Query triggers

  The Pre-Query and Post-Query triggers allow control over query processing. They can be defined at the form or block level. Most often, attach them to specific blocks to control the query functionality of those blocks.

  The Pre-Query trigger fires just before Form Builder issues the SELECT statement to the database, after the operator has defined the example record by entering query criteria in Enter Query mode. Inside a Pre-Query trigger, the example

  record defined by the query criteria is the current record. This means that trigger code can read and set the values of items in the example record using standard :block_name.item_name syntax.

  A Pre-Query trigger can be used to disallow query conditions that might be invalid. When a form is in Enter Query mode, normal validation is suspended and no validation triggers fire as they do in Normal mode. The Pre-Query trigger thus

  allows you to verify that any values entered by the operator are valid query conditions.

  When invalid query conditions have been entered, you can abort the query by raising the FORM_TRIGGER_FAILURE built-in exception in the Pre-Query trigger.

  You can also call SET_BLOCK_PROPERTY to modify the block's WHERE and ORDER BY clauses from within the Pre-Query trigger, to further restrict or order the records the query will retrieve.

• Question 37:

  Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown.

  In the years past, clerks entered credit ratings manually, which resulted in some of them being mistyped. To improve data entry accuracy you modify the Customers form so that the Credit_Rating item is a static list item that allows only those four values.

  Users report to you that some of the customer records can no longer be accessed when they use the modified Customers form. How can you fix this problem?

  A. Ensure that required is set to No for the list item so that a blank line appears in the list.
  B. Set the Mapping of Other Values property for the list item.
  C. Set the Default Value property for the list item.
  D. Set the Query Allowed Property for the list Item.
  E. Users must re-enter the records for those customers that cannot be accessed.
  B. Set the Mapping of Other Values property for the list item.

  ---

  The important property is the "mapping of other values." This property tells Oracle Forms how to handle values that are not expected.

• Question 38:

  The Orders form, whose properties have not been changed from the default, has two non-base table text items to display the sales representative's first and last names.

  You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:

  SELECT LAST_NAME Into :last_name FROM employees WHERE first_name = :first_name; EXCEPTION WHEN NO_DATA_FOUND THEN MESSAGE ('There is no sales rep by this name');

  When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.

  Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.

  Which two things can you do to correct these problems?

  A. Add the code to handle the FORM_TRIGGER_FAILURE exception.
  B. Raise the FORM_TRIGGER_FAILURE exception.
  C. Add code to handle the TOO_MANY_ROWS exception.
  D. Raise the TOO_MANY_ROWS exception.
  E. Code an On-Error trigger.
  F. Code an On-Message trigger.
  G. Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.
  H. Move the code to a form-level When-Validate-Item trigger.
  I. Change the form's validation Unit property to Record.
  A. Add the code to handle the FORM_TRIGGER_FAILURE exception.
  C. Add code to handle the TOO_MANY_ROWS exception.

  ---

  A: FORM_TRIGGER_FAILURE Exception

  Triggers fail only when one of the following occurs:

  *An unhandled exception

  *When you request the trigger to fail by raising the built-in exception FORM_TRIGGER_FAILURE This exception is defined and handled by Forms Builder, beyond the visible trigger text that youwrite. You can raise this exception:

  * In the executable part of a trigger, to skip remaining actions and fail the trigger *In an exception handler, to fail the trigger after your own exception-handling actions havebeen obeyedIn either case, Forms Builder has its own exception

  handler for FORM_TRIGGER_FAILURE , which fails the trigger but does not cause an unhandled exception. This means that you can fail the trigger in a controlled manner.

  C: When you use SELECT in a PL/SQL block, it's important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs.

  Note 1_ When-Validate-Item fires when Forms validates an item.

  Note 2: The scope of a trigger is determined by its position in the formobject hierarchy--that is, thetype of object under which you create the trigger. There are three possible levels that answer the"What Level?"question in the slide graphic:?

  Form level:

  The trigger belongs to the form and can fire due to events across the entireform.?Block level:

  The trigger belongs to a block and can fire only when this block is the currentblock.?Item level:

  The trigger belongs to an individual item and can fire only when this item isthe current item

• Question 39:

  You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.

  What is the best way to populate the Order_Iterns.Quantity item?

  A. Post-Query trigger
  B. Pre Query trigger
  C. When-New-Form-instance trigger
  D. When New-Item-instance trigger
  E. You need to define a master-detail relation so that the item is populated automatically.
  E. You need to define a master-detail relation so that the item is populated automatically.

  ---

  This should be implemented as a master-detail form.

• Question 40:

  Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.

  Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.

  Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?

  A. Add a blank line to the list item when you define the static values.
  B. Set Mapping of other Values for the Credit_Rating Item to NULL.
  C. Set the Required property of the Credit_Rating item to No.
  D. Delete the NOT NULL constraint for the Credit_Rating Column in the database.
  E. You cannot change this type of list item to display a blank value; users must delete the default value records if the credit rating is not known.
  A. Add a blank line to the list item when you define the static values.