1z1-151無料問題集「Oracle Fusion Middleware 11g: Build Applications with Oracle Forms」

質問 1

View the Exhibit.

The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.
You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On-Update, On-Delete, and on insert triggers have code that:
1. Displays a message to indicate which trigger is firing for which record?
2. Does the thing (either updates, deletes, or inserts)
The other triggers simply display a message, indicating the trigger that is firing.
You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?

（A）Set the DML array size to a value of 10 or greater; for array sizes loss than 10, array processing Is inefficient, and so is not performed.

（B）Set the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the Department_Id to be the primary key.

（C）Use the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed until the processing is finished, giving the appearance that array processing is not taking place.

（D）Delete the "On-" triggers; these triggers remove default processing, including array processing.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

Which three are valid ways to populate a display item?

（A）Executing a query

（B）initial Value property

（C）Calculation

（D）User input

（E）When-Button-Pressed trigger

正解：B、C、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.

（A）False

（B）True

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?

（A）Ensure that the WebUtil block is the first block under the Data Blocks node in the Object Navigator.

（B）Copy the WebUtil object group from the WebUtil object library into a separate object library.

（C）Subclass the WebUtil object group from the WebUtil object library into the Orders form.

（D）Copy the WebUtil library to the same directory as the Orders form.

（E）Ensure that the WebUtil block is the last block under the Data Blocks node in the Object Navigator.

（F）Attach the WebUtil library to the Orders form.

（G）Set the Implementation Class Property for any items that will implement WebUtil JavaBeans.

（H）in the When-New-Form-instance trigger, register the WebUtil javaBeans.

正解：C、E、F 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

View the Exhibit.

You have placed the following code in a Post insert trigger on the Orders block:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FORM SYS.dual;
You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.
As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit.
What is the probable cause of this error?

（A）You should change the code to select the sequence number from SUMMIT.dual instead.

（B）You should create the sequence in the database, because the runtime error is an indication that is does not exist.

（C）The code should be in a database trigger instead

（D）The code should be in Pre_insert trigger instead

（E）You should assign a temporary value to the Order_Id item before saving the form.

正解：E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

You want to display employee records in tabular format, but the form is not wide enough to display all the items in the Employees block. The employee IDs and names of displayed records should always be visible, but you want to scroll the additional information as users tab through the Items, the form should look like a spreadsheet with the first two columns frozen.
Which canvas types would be most appropriate in this scenario?

（A）content canvas in a window with a horizontal scroll bar

（B）content canvas and multiple tab canvases

（C）content canvas and a stacked canvas with a horizontal scroll bar

（D）content canvas and a tab canvas with multiple tab pages

（E）multiple content canvases

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

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）Move the code to a PL/SQL program unit.

（B）Use system variables in the GO_BLOCK statements.

（C）Change the block names to uppercase in the GO_BLOCK statements.

（D）Change all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.

（E）Change the block names to uppercase in the condition (IF ...THEN) statements.

（F）instead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

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）You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.

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

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

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

（E）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.

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

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

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

In Forms Builder, the iconic buttons on the form are blank, but when you click Run Form the form appears in the browser with Images in the iconic buttons.
What are two things that you can check to track the source of this problem?

（A）the FORMS_PATH setting in the Forms environment file

（B）the UI_ICON setting in the operating system

（C）the iconpath setting in the Forms registry file

（D）the classpath setting in the operating system

（E）the UI_ICOM_EXTENSION setting in the operating system

（F）the iconextension setting in the Forms registry file

（G）forms Builder runtime preferences

正解：B、C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

1z1-151 無料問題集「Oracle Fusion Middleware 11g: Build Applications with Oracle Forms」

弊社を連絡する

関連リンク

トップ試験