1Z0-151 Online Practice Questions and Answers

The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:

SELECT orders_seq.NEXTVAL INTO :orders.order_id FROM SYS.dual;

Which statement is true about this code?

A. If you place this Code in a trigger that fires when the record is inserted into the database, you will likely have more gaps in Order IDs than if you use the sequence as a default value for the item.

B. If you place this code in a trigger, you should ensure that Order_Id has its required property set to Yes.

C. If you place this code in a trigger, you should ensure that Order_Id has its Database Item property set to No.

D. If the named sequence does not exist, it is automatically created the first time the code is called.

E. You should place this code a in a database trigger to minimize the gaps in Order IDs.

F. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.

G. You should place this code in a Post_insert trigger to minimize the gaps in Order IDs.

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

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.

View the Exhibit.

You have integrated the WebUtil utility into the Orders form. You code a When-Button-Pressed trigger to call some WebUtil functionality, and then run the form to test it. Everything works as it should.

You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.

What is a probable cause of this error?

A. You have invoked WebUtil functionality from a trigger that does not accept restricted built- ins.

B. You have invoked WebUtil functionality from a Pre-form trigger.

C. You did not recompile the WebUtil library after adding new triggers.

D. You did not enable the GetClientinfo JavaBean.

E. Java is not installed on the client machine, so SET_JAVA_VERSION returns an error.

View the Exhibit.

You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?

A. Write a Pre Form trigger to register WebUtil JavaBeans.

B. Attach the WebUtil PL/SQL library to the form.

C. Subclass the webUtilConfig parameter from the WebUtil object library into the form.

D. Define WebUtil events that the form listens and responds to.

E. Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.

F. Move the WebUtil data block to the first position under the Data Blocks node in the Object Navigator.

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 examine the form.

The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the CONTROL block. The Mouse Navigate property of the button has been set to No.

The following code as been written in a When-Button-Pressed trigger on the Check_Values button:

MESSAGE(:field1| | ' - ' | | :SYSTEM.cursor_item | | ' - ' | | :SYSTEM.trigger_item);

With the focus in Field1 and the values 1, 2, and 3 in the text items, what message will be displayed when the button is clicked.

A. -4

B. 1 -2 -3

C. 1 field1 Check Values

D. Field1 -1 Check Values

E. 1 CONTROL.FIELD1 CONTROL.FIELD1

F. 1 CONTROL.FIELD1 CONTROL.CHECK_VALUES

G. :field1 - :SYSTEM.cursor_item - :SYSTEM.trigger_item

There are certain errors that are specific to the Salary item on the Employees form. You want to trap these errors only when the user navigates from the Salary item.

You have a form-level On-Error trigger that traps errors that apply to the form in general, but yon additionally code an item-level On-Error trigger for the Salary item.

When testing the form, you find that the general errors are not trapped when you navigate from the Salary item. What can you do to correct this problem?

A. Call the form level On-Error trigger from the item-level On-Error trigger.

B. Call the item-level On-Error trigger from the form-level On-Error trigger.

C. Change the Execution Hierarchy property for the item-level On-Error trigger.

D. Change the Execution Hierarchy property for the form-level On-Error trigger.

E. Move all the code to a PL/SQL program unit and call it from both the form level and item level On-Error triggers.

Which type of variable must be declared before it is used in a trigger?

A. PL/SQL variable

B. Form item

C. global variable

D. system variable

E. parameter

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.