1Z0-151 Online Practice Questions and Answers

Correct Answer: C

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

Correct Answer: D

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

Correct Answer: D

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

Correct Answer: C

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

Correct Answer: AD

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

Correct Answer: A

Note: ORACLE APPLICATION SERVER FORMS SERVICES ARCHITECTURE The OracleAS Forms Services consists of three components: a Forms Client that is downloaded automatically to the end user's browser and cached, the Forms Listener Servlet, and the Forms Runtime - on the middle tier.

Forms Client (Java Applet) When a user runs a Forms session, the Forms Client - a thin 100 percent Java Applet - dynamically downloads from the Oracle Application Server. This generic Java Applet provides the user interface for the associated Forms Runtime process on the middle tier, and handles user interaction and visual feedback such as that generated by navigating between items or checking a checkbox. The same Java applet is used for any Forms application, therefore it is downloaded only once and cached on the client and so is available for subsequent Forms applications

Correct Answer: AC

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

Correct Answer: BCDG

B: Order_Items is a detail block.

C (not F): A master block record cannot be deleted if there are corresponding detail block records.

D: To delete an order, all the corresponding order items must be deleted, for example through an ONCHECK-DELETE-MASTER trigger.

G: The Orders block is a master block.

Incorrect answers:

E: Order_items can very well be deleted without deleting the corresponding order.

J: There are no triggers for INVENTORIES.

Either Master or Detail Triggers would have been created if it was either a Master or Detail block.

Note: Master/Detail Triggers: Oracle Forms generates master/detail triggers automatically when a master/detail relation is defined between blocks. The default master/detail triggers enforce coordination between records in a detail block and the master record in a master block. Unless developing custom block- coordination schemes, you do not need to define these triggers.

*

On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is a master block in a master/detail relation.

*

On-Clear-Details Fires when Oracle Forms needs to clear records in a block that is a detail block in a master/detail relation because those records no longer correspond to the current record in the master block.

*

On-Populate-Details Fires when Oracle Forms needs to fetch records into a block that is the detail block in a master/detail relation so that detail records are synchronized with the current record in the master block.

Correct Answer: B

Referencing Objects by Internal ID Finding the object ID:

lov_id := FIND_LOV('my_lov')