Oracle 1z0-151 問題集

質問 1：
View the Exhibit.

The Departments table in the database contains four columns. In a new form, you use the Data Block Wizard to add all columns to the block, but in the layout Wizard, you choose all columns except Location_Id to add to the canvas. The Object Navigator and layout Editor appear as shown in the Exhibit.
You then decide that you do need to display Location_Id on the canvas. What object must you select before invoking the Layout Editor in re-entrant mode to make this change?
A. Frame 16 in either the Object Navigator or the layout Editor
B. Location_Id in the Object Navigator
C. the Departments data block in the Object Navigator
D. Canvas4 in either the Object Navigator or the Layout Editor
E. the text item tool in the Layout Editor
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which type of variable must be declared before it is used in a trigger?
A. PL/SQL variable
B. parameter
C. Form item
D. global variable
E. system variable
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!');
end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?
A. IF ERROR_CODE = 20101 THEN
MESSSAGE(SQLERRM);
END IF;
B. IF ERROR-CODE = 20101 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF;
C. IF ERROR_CODE = 06512 THEN
MESSSAGE(DBMS_ERROR_TEXT);
END IF;
D. IF ERROR_CODE = 40509 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF
E. IF ERROR_CODE = 40509 THEN
MESSSAGE (SQLERRM);
END IF;
F. IF ERROR_CODE = 06512 THEN
MESSSAGE (SQLERRM);
END IF;
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.

You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:

The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?
A. Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.
B. Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.
C. Change the initial Value property to Good and the Value When Unchecked property to Null.
D. Change the initial Value property to Good.
E. Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.
F. Change the Check Box Mapping of Other Values property to Not Allowed.
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
View the Exhibit.

You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names.
You cannot change the names of the default object library tabs, so you must create new tabs in order to have descriptive names.
A. False
B. True
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
View the Exhibit.

You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.
As shown in the Object Navigator in the Exhibit, which objects are menu items?
A. ITEM5 and ITEM only
B. ITEM4, ITEM5, and ITEM6 only
C. ITEM6 only
D. ITEM4 and ITEM5 only
E. ITEM 4 and ITEM6 only
F. MENU3 and ITEM5_MENU only
G. MENU3, ITEM4, ITEM5, ITEM5_MENU, and ITEMG
H. MENU3 only
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which symbol when used in an object's Property Palette, indicates an inherited property that has been changed?

A. Option A
B. Option C
C. Option D
D. Option B
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
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. False
B. True
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
The Orders form, whose properties have not been changed from the default, has two non- base table text items to display the sales representative's first and last names.
You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:
SELECT LAST_NAME Into :last_name FROM employees
WHERE first_name = :first_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE ('There is no sales rep by this name');
When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.
Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.
Which two things can you do to correct these problems?
A. Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.
B. Move the code to a form-level When-Validate-Item trigger.
C. Code an On-Error trigger.
D. Code an On-Message trigger.
E. Raise the FORM_TRIGGER_FAILURE exception.
F. Add the code to handle the FORM_TRIGGER_FAILURE exception.
G. Change the form's validation Unit property to Record.
H. Raise the TOO_MANY_ROWS exception.
I. Add code to handle the TOO_MANY_ROWS exception.
正解：F,I
解説: (Topexam メンバーにのみ表示されます)