Oracle 1z0-151 問題集

質問 1：
The Orders application enables the Orders form to be opened from the Customers form.
Users are confused because when they save a new or changed order, they sometimes receive an error message that indicates that no changes have been made.
What could be the possible cause of this problem?
A. The Orders form is opened in NO_ACTIVATE mode.
B. The Orders form is opened in ACTIVATE mode.
C. The trigger that opens the Orders form calls COMMIT_FORM after open form.
D. The Orders form is Opened in the same session as the Customers form.
E. The Orders form is opened in a different session from the Customers form.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
View the exhibit.

In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and Mouse Navigable set to No.
You are coding a When-Button-Pressed trigger for the First Record button with the following code:
SCROLL_UP;
WHILE FORM_SUCCESS LOOP
SCROLL_UP;
END LOOP;
What happens when the user clicks First Record with the cursor in the 72nd record in the block, as shown in the Exhibit?
A. Because there is no scroll bar, the cursor navigates only as far as the first visible record, which is record 63.
B. A runtime error is encountered because there is no scroll bar for the block.
C. The form goes into an infinite loop and has to be killed by using operating system commands.
D. internal navigation to the first record occurs, but the visible cursor remains on record 72.
You should add the SYNCHRONIZE command to synchronize the display with the internal state of the form.
E. The display scrolls so that the first record is visible, bur the cursor stays on the last visible record, which should be record 10.
F. The cursor successfully navigates to the first record.
正解：F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save What is the behavior of the record being inserted violates a database constraint?
A. The record is committed to the database. The form redisplays the record with a warning in case the user would like to correct the entry. The user is able to navigate to another record or exit the form.
B. The record is posted to the database but not committed. The form redisplays the record with an error message so that the user can correct the data. Navigation to another record cannot occur until the correct data is committed or the new record is deleted. If the user exits the form without correcting the entry, a database rollback is performed.
C. A database rollback is performed. The form redisplays the record with an error message so that the user can correct the entry. The user is able to navigate to another record or exit the form.
D. A database rollback is performed. The form redisplays the record with an error message so that an correct the entry. Navigation to another record cannot occur until the correct data is committed or the record is deleted.
E. The record is committed to the database. The form redisplays the record with an error message so that the user can correct the data. The user is unable to exit the form or move to another record until the correct data is committed of the new record is deleted.
正解：B
解説: (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 been assigned to maintain a Forms application that was designed by a developer who has left the company.
The CV_Tools canvas contains several buttons. There is limited space on the canvas, but the first button is not quite wide enough to display its complete label. In the Layout Editor, you widen the button slightly and find that the width of all the buttons increases so that they now overlap each other.
What could have caused this problem?
A. The buttons were created by dragging them from an object group.
B. All other buttons were subclassed from the first button.
C. The first button was copied from another button.
D. The buttons inherit their properties from the same property class.
E. The buttons were created by using a Smart Class.
F. The first button was subclassed from another button.
G. All other buttons were copied from the first button.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You want to use the Forms Debugger to diagnose a problem with the RAISE_STATUS program unit that is stored in the database.
Forms Builder, you set a breakpoint in the stored code, and then run the Human Resources form in debug mode. You click the Raise_Salaries button, which has a When Button Pressed trigger that calls RAISE_SALARIES.
However, you are unable to see the RAISE_SALARIES procedure when you step through the code, and it does not appear in the stack frame. What could be the reason for this problem?
A. You are not connected to the database.
B. The breakpoint should have been set in the When-Button-Pressed trigger, not in the stored program unit.
C. You cannot use the Forms Debugger to diagnose problems with stored program units.
D. The stored program unit was not compiled with the debug information included.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:
IF NOT FORM_SUCCESS THEN
MESSAGE ('Stored Procedure failure');
RAISE FORM_TRIGGER_FAILURE;
END IF;
You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?
A. You must handle database errors in an exception clause of the trigger.
B. You cannot test for failure of a stored procedure, because database errors are transparent to Forms.
C. You must test for FORM_FATAL when testing for failure of a stored procedure.
D. You must test for FORM_FAILURE when testing for failure of a stored procedure.
E. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You want to display fields of a form module on multiple layouts that are visible simultaneously, what can enable you to achieve this?
A. multiple content canvases that display in the same window
B. multiple forms, because you cannot have multiple content canvases in the same form that are visible simultaneously
C. multiple content canvases that display in multiple windows
D. one content canvas that displays in multiple windows
正解：A
解説: (Topexam メンバーにのみ表示されます)

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