Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1z1-151) Free Practice Test

Question 1

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

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

View the Exhibit.

You have defined the window, canvas, and text items shown in the Exhibit. What happens when click Run Form?

A. The form runs with the cursor initially in TEXT_ITEM8.

B. The form runs with the cursor initially in TEXT_ITEM9.

C. The form does not compile until you move TEXT_ITEM10.

D. The form does not compile until you move TEXT_ITEM8.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

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. Set the Canvas property for the radio group to Employee_Appraisal.

C. Drag the radio group node from the Object Navigator to the Employee__Appraisal canvas in the Layout Editor.

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. Open the Layout Editor for both canvases; drag the radio buttons from Employee_Training canvas to the Employee_Appraisal canvas.

F. Drag the radio button nodes from the Object Navigator to the Employee Appraisal canvas in the Layout Editor.

Correct Answer: E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

You are coding a When-Checkbox-Changed trigger.
Which statements are available for use in your code?

A. restricted and unrestricted built-ins only

B. PL/SQL statements and unrestricted built-ins only

C. unrestricted built-ins only

D. PL/SQL statement-, and any built-ins

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Which statement is always true about using OPEN_FORM to open multiple forms in an application?

A. Only A and B are true.

B. Only C and D are true.

C. Only B and C are true.

D. A global record group is always created.

E. Code is always shared among forms.

F. A calling form must pass data to a called form.

G. Database transactions are always continued across forms.

H. None of the statements above are true.

Correct Answer: H

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Which three are valid ways to populate a display item?

A. User input

B. When-Button-Pressed trigger

C. Executing a query

D. Calculation

E. initial Value property

Correct Answer: B,D,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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. Raise the TOO_MANY_ROWS exception.

B. Move the code to a form-level When-Validate-Item trigger.

C. Add the code to handle the FORM_TRIGGER_FAILURE exception.

D. Raise the FORM_TRIGGER_FAILURE exception.

E. Code an On-Message trigger.

F. Change the form's validation Unit property to Record.

G. Code an On-Error trigger.

H. Add code to handle the TOO_MANY_ROWS exception.

I. Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.

Correct Answer: C,H

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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 item is using an LOV for validation.

B. The form is in Enter-Query mode.

C. The validation unit of the form needs to be changed.

D. There is a syntax error in the call to the MESSAGE() built-in.

E. Validation for the Customer_Id item failed.

F. The MESSAGE () built-in is not allowed in validation triggers.

Correct Answer: A,B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

Which three statements are true about the PL/SQL Packages panel in the Forms debugger?

A. You can view packages only while the runtime process executes PL/SQL.

B. You can view the values of variables that are defined in the package specification.

C. You ran select an option button to view the packages that have not yet been instantiated.

D. You can select an option button to view server packages.

Correct Answer: A,B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1z1-151) Free Practice Test