Oracle 1z0-151 問題集

質問 1：
A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.
Possible navigation units that can occur during navigation of this form are:
1. Outside the form
2. The Human Resources form
3. The Departments block
4. The Employees block
5. The current Departments record
6. The current Employees record
7. The Department_Id item
8. The Employee_Id item
With the cursor in : Departments.Department_Id, the clerk clicks the
:Employees.Employee_Id item.
What is the sequence of navigational unit movement that occurs?
A. 7, 5, 3, 2, 4, 6, and 8
B. 1, 2, 3, 4, 5, 6, 7, and 8
C. 7, 5, 3, 4, 6, and 8 only
D. 7, 5, 3, 2, 4, 6, and 8 only
E. 7 and 8 only
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.
What happens when you run the form from Forms Builder?
A. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.
B. You receive a compilation error.
C. The form runs, but as soon as you perform any navigation, a runtime error occurs.
D. The form runs, but as soon as it appears, you receive a runtime error.
E. The form runs with no problem.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You create a Customers form by using wizards. When you test the form, you notice that you cannot the complete name that is displayed in the Customer_Name text item. Which three tools can you use to correct this problem?
A. Data Block wizard
B. Object Navigator
C. Layout Editor
D. Layout wizard
E. Object Library
F. Property Palette
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

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

質問 5：
You have just created radio buttons labeled Outstanding, Exceeds, Meets, and Does not Meet for the employee appraisal rating, but you accidentally created it on the Employee_Training canvas rather than on the Employee_Appraisal canvas. How can you move them to the appropriate canvas?
A. Set the Canvas property for the radio buttons to Employee_Appraisal
B. Drag the radio button nodes from the Object Navigator to the Employee Appraisal canvas in the Layout Editor.
C. Open the Layout Editor for both canvases; drag the radio buttons from Employee_Training canvas to the Employee_Appraisal canvas.
D. You cannot move existing radio buttons to another canvas; you will need to delete them from the Employee_Training canvas and create new ones on the Employee_Appraisal canvas.
E. Set the Canvas property for the radio group to Employee_Appraisal.
F. Drag the radio group node from the Object Navigator to the Employee__Appraisal canvas in the Layout Editor.
正解：C
解説: (Topexam メンバーにのみ表示されます)

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

質問 7：
You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.
What is the best way to populate the Order_Iterns.Quantity item?
A. When New-Item-instance trigger
B. You need to define a master-detail relation so that the item is populated automatically.
C. Post-Query trigger
D. Pre Query trigger
E. When-New-Form-instance trigger
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Identify a function of the Forms Servlet.
A. It starts a Forms runtime session.
B. It renders the Forms Services application display for the user.
C. It manages network requests from the Forms Client.
D. It connects to and communicates with the database server.
E. It creates a dynamic HTML file.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly navigate to it by using the mouse.
Which property setting accomplishes this requirement?
A. Enabled = Yes; Keyboard Navigable = No
B. Automatic Skip = Yes
C. Enabled = No; Keyboard Navigable = Yes
D. Enabled = Yes; Keyboard Navigable = Yes
E. Enabled = No; Keyboard Navigable = No
正解：D
解説: (Topexam メンバーにのみ表示されます)