Oracle 1z0-151 問題集

質問 1：
View the Exhibit.

You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?
A. Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.
B. Attach the WebUtil PL/SQL library to the form.
C. Move the WebUtil data block to the first position under the Data Blocks node in the Object Navigator.
D. Write a Pre Form trigger to register WebUtil JavaBeans.
E. Subclass the webUtilConfig parameter from the WebUtil object library into the form.
F. Define WebUtil events that the form listens and responds to.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Users do not want to see the "Working" message while a long query completes.
You are designing a form with a query that takes o long time to execute. What can you do to stop the "Working" message from appearing?
A. Use the SET_APPLICATION_PROPERTY built-in to set the message level in a When- New-Form-instance trigger.
B. Before the line of code that executes the query, add the line:
:SYSTEM.MESSAGE_LEVEL := '10';
C. You do not need to do anything, the default behavior of Forms is to display the
"Working" message only if you add code to do so.
D. Before the line of code that executes the query, add the line:
:SYSTEM.SUPPRESS_WORKING : = 'TRUE';
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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. Post-Query
B. On-Query
C. When-New-Form-instance
D. Pre-Query
E. When-New-Block-instance
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three are valid ways to populate a display item?
A. When-Button-Pressed trigger
B. User input
C. Calculation
D. Executing a query
E. initial Value property
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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. Delete the "On-" triggers; these triggers remove default processing, including array processing.
B. 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.
C. 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.
D. 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.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
What happens when you click Run Form Debug in Forms Builder?
A. The form runs in a simulated three-tier environment by using an applet viewer that is included with the product to enable debugging.
B. The form runs on your local machine by using a debug executable client.
C. The form runs in a three-tier environment by using the application server URL that you specify in runtime preferences.
D. The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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 create the sequence in the database, because the runtime error is an indication that is does not exist.
B. You should assign a temporary value to the Order_Id item before saving the form.
C. The code should be in a database trigger instead
D. The code should be in Pre_insert trigger instead
E. You should change the code to select the sequence number from SUMMIT.dual instead.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You must be careful when coding a When-Button-Pressed trigger, because it does not accept restricted built-ins.
A. False
B. True
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?
A. menu items
B. individual menus
C. all of the above
D. submenus
E. main menus
正解：C
解説: (Topexam メンバーにのみ表示されます)