다운로드 Oracle : 1z1-151 질문 & 답 PDF & Test Software

처음 도전하는 1z1-151 시험이라면 무엇부터 시작해야 할지 막막하실 수 있습니다. PassTIP의 Oracle Fusion Middleware 11g: Build Applications with Oracle Forms 모의고사 90문항으로 학습 방향을 잡아 보시기 바랍니다.

Oracle 1z1-151 시험 개요:

Oracle 1z1-151 시험 요강 주제:

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms 관련 궁금증을 해결해 드립니다

최신 11g 1z1-151 무료샘플문제

문제 #1

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. Delete the Key-Exqry trigger and put its code in an On-Select trigger.
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. Change the last line of the When-Button-Pressed code to:
DO_KEY ('EXECUTE_QUERY');

문제 #2

To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.
You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?

A. The MESSAGE () built-in is not allowed in validation triggers.
B. There is a syntax error in the call to the MESSAGE() built-in.
C. The item is using an LOV for validation.
D. The validation unit of the form needs to be changed.
E. Validation for the Customer_Id item failed.
F. The form is in Enter-Query mode.

문제 #3

The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?

A. Define multiple content canvases; display one in a modeless window and the others in modal windows.
B. Define multiple content canvases and display them in multiple modal windows.
C. This is not possible because items from a single block must be displayed on the same canvas and window.
D. Define multiple content canvases and display them in multiple modeless windows.
E. Define multiple content canvases and display them in the same modeless window.

문제 #4

Identify a function of the Forms Servlet.

A. It starts a Forms runtime session.
B. It creates a dynamic HTML file.
C. It connects to and communicates with the database server.
D. It manages network requests from the Forms Client.
E. It renders the Forms Services application display for the user.

문제 #5

The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FROM SYS.dual;
Which statement is true about this code?

A. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.
B. You should place this code in a Post_insert trigger to minimize the gaps in Order IDs.
C. If the named sequence does not exist, it is automatically created the first time the code is called.
D. If you place this code in a trigger, you should ensure that Order_Id has its required property set to Yes.
E. If you place this code in a trigger, you should ensure that Order_Id has its Database Item property set to No.
F. You should place this code a in a database trigger to minimize the gaps in Order IDs.
G. If you place this Code in a trigger that fires when the record is inserted into the database, you will likely have more gaps in Order IDs than if you use the sequence as a default value for the item.

질문과 대답: