최신 1z0-151 무료덤프 - Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

문제1

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. 1, 2, and 3

B. 1, 3, and 2

C. 3 only

D. 1 and 2 only

E. 2 and 3 only

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제2

문제3

View the Exhibit.

You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?

A. Define WebUtil events that the form listens and responds to.

B. Subclass the webUtilConfig parameter from the WebUtil object library into the form.

C. Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.

D. Attach the WebUtil PL/SQL library to the form.

E. Write a Pre Form trigger to register WebUtil JavaBeans.

F. Move the WebUtil data block to the first position under the Data Blocks node in the Object Navigator.

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제4

You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?

A. Copy the WebUtil library to the same directory as the Orders form.

B. Ensure that the WebUtil block is the first block under the Data Blocks node in the Object Navigator.

C. Attach the WebUtil library to the Orders form.

D. in the When-New-Form-instance trigger, register the WebUtil javaBeans.

E. Subclass the WebUtil object group from the WebUtil object library into the Orders form.

F. Set the Implementation Class Property for any items that will implement WebUtil JavaBeans.

G. Ensure that the WebUtil block is the last block under the Data Blocks node in the Object Navigator.

H. Copy the WebUtil object group from the WebUtil object library into a separate object library.

정답: C,E,G

설명: (DumpTOP 회원만 볼 수 있음)

문제5

A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the problem, so you decide to use remote debugging.
The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?
1. You set a breakpoint in the When Button-Pressed trigger for the invoice button.
2. The user's screen goes blank.
3. The user reports the host and port to you.
4. You uses the debugger to step through the code.
5. The user clicks a button that calls DEBUG.ATTACH.
6. You attach to the user's process.
7. You open the Orders.fmb file from which the running .fmx was generated.
8. The user clicks the invoice button.

A. 7, 1, 3, 6, 5, 1, 8, 4

B. 8, 3, 6, 5, 4, 7, 1, 2

C. 5, 3, 6, 7, 1, 8, 2, 4

D. 3, 6, 5, 7, 8, 1, 2, 4

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제6

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 change the code to select the sequence number from SUMMIT.dual instead.

C. You should assign a temporary value to the Order_Id item before saving the form.

D. The code should be in Pre_insert trigger instead

E. The code should be in a database trigger instead

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제7

You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the Editor property of Product_Description to MyEditor.

A. True

B. False

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제8

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 = 06512 THEN
MESSSAGE(DBMS_ERROR_TEXT);
END IF;

B. IF ERROR-CODE = 20101 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF;

C. IF ERROR_CODE = 20101 THEN
MESSSAGE(SQLERRM);
END IF;

D. IF ERROR_CODE = 06512 THEN
MESSSAGE (SQLERRM);
END IF;

E. IF ERROR_CODE = 40509 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF

F. IF ERROR_CODE = 40509 THEN
MESSSAGE (SQLERRM);
END IF;

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제9

Which statement is true about flexible code?

A. It is more difficult to maintain.

B. It is more difficult to write, so it decreases developer productivity.

C. It typically includes hard-coded object names.

D. It is specific to a particular module.

E. It is designed for reuse.

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

최신 1z0-151 무료덤프 - Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

우리와 연락하기

유용한 링크

최신 업데이트