Oracle 1z0-151 問題集

質問 1：
Which four types of variables must have their names preceded by a colon when they are referenced in trigger code?
A. system variables
B. Form items
C. parameters
D. PL/SQL variables
E. global variables
正解：A,B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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 メンバーにのみ表示されます)

質問 3：
View the Exhibit.

You are attempting to drag the Control and CV_Order objects to an object group as shown in the Exhibit, but you are unable to release them in the Object Group Children node of the object group.
What is the reason for this?
A. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.
B. You cannot drag multiple types of objects to an object group at the same time.
C. You need separate object groups for different types of objects.
D. You cannot drag a canvas to an object group.
E. You cannot drag a block to an object group.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You are planning the alerts that are needed for your Human Resources application. You wish to display the following in alerts:
* A message to inform the user about being at the just record
* A warning about a potential conflict with the data just entered
* A message to display a validation error to the user
* A warning that the salary is out of range and that asks whether the user wants to correct it You want the note symbol (

) to appear on alerts that display only informative messages, the warning symbol to appear on messages where you will allow the user to continue despite some data problem, and the alarm boll symbol to appear where the user will not be allowed to continue without correcting the situation that caused the alert to be displayed.
You want to define the minimum number of alerts possible and customize them at run time.
Which alerts should you define?
A. On Caution style alert and one stop style alert
B. One Note style alert and caution style alert
C. One Note style alert and one Stop style alert
D. On Note style alert, one Caution style alert, and one Stop style alert
E. Two Caution style alerts and one Stop style alert
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which statement is always true about using OPEN_FORM to open multiple forms in an application?
A. Only C and D are true.
B. None of the statements above are true.
C. Database transactions are always continued across forms.
D. Only B and C are true.
E. A global record group is always created.
F. Only A and B are true.
G. Code is always shared among forms.
H. A calling form must pass data to a called form.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
The Orders form has the following triggers defined:
1. Post-Text-Item on Customer_Id
2. Pre-Text-Item on Sales_Rep_Id
3. When-New-Item-instance on Sales_Rep_Id
The form's Validation Unit property is set to Record.
When the user navigates from Customer_Id to Sales_Rep_Id, which triggers fire and what is the sequence?
A. 3 only
B. 1 and 2 only
C. 2 and 3 only
D. 1, 2, and 3
E. 1, 3, and 2
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
View the Exhibit.

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.
What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?
A. the Departments block
B. Canvas4
C. the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items
D. Frames
E. Frame5
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which statement is always true about a visual indicator that a text item has a list of values associated with it?
A. A list of values lamp appears next to the text item.
B. A button with an ellipsis appears in the text Item when the cursor enters the text item.
C. A list of values lamp appears on the status line when the cursor enters the text item.
D. A list of values lamp appears as a tool tip when the cursor is placed over the text item.
E. An iconic list button appears next to the text item.
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders.
You code the following triggers:
When-New Form instance on the Orders form:
GO_BLOCK('orders');
EXECUTE_QUERY;
You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger.
To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.
What is the best way to correct this issue to ensure that the customer can never query another customer's orders?
A. Change the last line of the When-Button-Pressed code to:
DO_KEY ('EXECUTE_QUERY');
B. Delete the Key-Exeqry trigger and add the its first line after the call to GO_BLOCK in the When-New-Form-instance trigger.
C. Delete the Key-Exqry trigger and put its code in a Pre-Query trigger.
D. Delete the Key-Exqry trigger and put its code in an On-Select trigger.
正解：A
解説: (Topexam メンバーにのみ表示されます)