Product Description
Exam Number/Code: 1z0-141
Exam name: oracle9i forma developer:build internet applications
1z0-141 test is the important of Oracle certifaction. Only you pass the 1z0-141 exam you could have the chance to get Oracle certifaction. To help examinee, Exambible publish the Questions and Answers about 1z0-141 exam. And the 138 simulation exam are all designed by expert from Exambible. Examinees could have an enough prepare by these simulation exercises and pass the 1z0-141 test successfully.
Exambible also provide free 1z0-141 Demo, examinees can download and use before buying 1z0-141 Q&As, then decide if they need to purchase.
More Oracle 9i Internet Application Developer Resources
Recommended Oracle exams
- Oracle 1Z0-146 exam: Oracle 11g: Advanced PL/SQL
- Oracle 1Z0-517 exam: Oracle EBS R12.1 Payables Essentials
- Oracle 1z0-010 exam: oracle8:new features for administrators
- Oracle 1z0-236 exam: 11i Applications DBA Fundamentals II
- Oracle 1z0-035 exam: orcacle9i dba new features for oracle7.3 and oracle9 ocps
- Oracle 1z0-311 exam: oracle application server 10g:administration
- Oracle 1z0-640 exam: Siebel 7.7 Analytics Data Warehouse Dev.Prof.Core Exam
- Oracle 1Z0-144 exam: Oracle Database 11g: Program with PL/SQL
- Oracle 1z0-273 exam: Hyperion Financial Management 4.1 Administrator I&II
- Oracle 1z0-232 exam: Oracle 11i System Administration
- Oracle 1Z0-519 exam: Oracle EBS R12.1 Inventory Essentials
- Oracle 1Z1-238 exam: R12 Oracle: Install, Patch and Maintain Oracle Applications
Oracle 9i Internet Application Developer 1z0-141 Web Demo
This webdemo is just a demo data, only for reference and learning, there is no other purposes.
1. Your company assigns three possible credit ratings to customers:
Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The
DBA has just added a RATING column to the CUSTOMERS table and has asked
you to add an item to your form so that credit ratings can be recorded.
To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item.
You want to allow for an undetermined (Null) credit rating, and users
should be able to update the credit rating from a value to an
undetermined rating. How can you implement this?
A. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to Null.
B. Create three radio buttons for each of the credit ratings, and set
the Mapping of Other Values for the radio group to one of the credit
rating values.
C. Create four radio buttons, and leave blank the value for the undetermined credit rating.
D. Choose a different type of input item, because radio groups do not allow entry and update of null values.
Answer: C
2. You want to create a calculated item in the Control block of the
Human Resources form. This item will contain the total of employee
salaries for employees in a particular department. Which statement is
true about how to create the calculated item?
A. You can create it by first creating a text item and then changing the item type.
B. You can create it in the Layout Editor using a special tool that creates a calculated item.
C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.
D. You can create it in the Layout Editor by selecting the Salary item
of the Employees block, selecting the Control block from the block
list, clicking the Text Item tool, and drawing a text item on the
canvas to automatically calculate a sum of the selected Salary item.
Answer: C
3. Consider the following scenario:
In a multiform application, the user started in FormA.
1. From FormA, the user invoked FormB using CALL_FORM.
2.You want to create a calculated item in the Control block of the
Human Resources form. This item will contain the total of employee
salaries for employees in a particular department. Which statement is
true about how to create the calculated item?
A. You can create it by first creating a text item and then changing the item type.
B. You can create it in the Layout Editor using a special tool that creates a calculated item.
C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.
D. You can create it in the Layout Editor by selecting the Salary item
of the Employees block, selecting the Control block from the block
list, clicking the Text Item tool, and drawing a text item on the
canvas to automatically calculate a sum of the selected Salary item.
Answer: C
3. Consider the following scenario:
In a multiform application, the user started in FormA.
1. From FormA, the user invoked FormB using CALL_FORM.
2. From FormB, the user invoked FormC using OPEN_FORM.
3. From FormC, the user invoked FormD using OPEN_FORM.
4. From FormB, the user invoked FormE using CALL_FORM.
There is an additional form in the application, called FormF. Which statement is true?
A. FormF can be invoked from FormC using CALL_FORM.
B. FormF can be invoked from FormA using OPEN_FORM.
C. FormF can be invoked from FormD using CALL_FORM.
D. FormF can be invoked from FormE using CALL_FORM.
E. FormF can be invoked from FormB using OPEN_FORM.
Answer: D
4. The two-column LOCATION Record Group has 10 rows.
At run time, the user wants to mark two or more LOCATION records for
use by another Forms Builder object. The rows will be used to construct
a WHERE clause for a subsequent data block query.
Which built-in enable individual rows to be marked?
A. ADD_GROUP_COLUMN
B. SET_RECORD_PROPERTY
C. GET_GROUP_SELECTION
D. SET_GROUP_SELECTION
E. RESET_GROUP_SELECTION
F. GET_GROUP_RECORD_NUMBER
Answer: D
5. You created a query Record Group at design time. Which built-in can
you use to execute the query defined in the Record Group object?
A. ADD_GROUP_ROW
B. POPULATE _GROUP
C. ADD_GROUP_COLUMN
D. SET_GROUP_SELECTION
E. CREATE_GROUP_FROM_QUERY
F. POPULATE _GROUP_WITH_QUERY
Answer: B
6. In a multiform application, one form must invoke another. The form
modules are called Customers and Orders internally, but the compiled
files are saved as CUST.FMX and ORD.FMX, respectively.
There is a button in the Customers form with a When-Button-Pressed trigger to invoke the Orders form.
There is a requirement that only one Orders form can be running at a
time, so the trigger must check to see if the form is already open. If
it is open, the focus must be sent to it. If it is not open, it has to
be opened.
Which of these trigger codes will achieve the required functionality?
A. IF NOT FIND_FORM('ord') THEN
OPEN_FORM('ord');
ELSE
GO_FORM('orders');
END IF;
B. IF ID_NULL(FIND_FORM('ord')) THEN
OPEN_FORM('orders');
ELSE
GO_FORM('ord');
END IF;
C. IF ID_NULL(FIND_FORM('orders')) THEN
OPEN_FORM('ord');
ELSE
GO_FORM('orders');
END IF;
D. IF NOT FIND_FORM('orders')) THEN
OPEN_FORM('orders');
ELSE
GO_FORM('ord');
END IF;
Answer: C
7. You have the Orders form open in Forms Builder. You create an object
group in the Orders form and you try to drag various components in the
Object Navigator to the object group. Which two components will you be
unable to place in the object group? (Choose two.)
A. the Orders block of the Orders form
B. the Order_CV canvas of the Orders form
C. the When-New-Item-Instance trigger of the Order_Items.Quantity item in the Orders from
D. the When-New-Form-Instance trigger of the Orders form
E. the Product_Id item in the Order_Items block of the Orders form
Answer: CE
8. Which two statements correctly describe the relationship between a content canvas and a window? (Choose two.)
A. Only one content canvas can be associated with a window.
B. Only one content canvas at a time can appear in a window.
C. One or more content canvases can be associated with a window.
D. A content canvas can be associated with two or more windows.
E. A content canvas cannot be larger than the window with which it is associated.
F. A maximum of two content canvases can appear in a window at the same time.
Answer: BC
