In this quiz the following things are covered.
A) Forms Developer Environment
B) Modes of Operation
C) Query/Where Dialog Box
D) Data blocks
E) Layout Wizard
F) Modifying Layout
G) Reentrant Mode
H) Master-Detail Relationship
I) Control Block
J) Item Properties
K) Input Items
L) Combo Box
M) Radio Group
N) Navigation Trap
O) Transaction Processing
P) Check Box
Q) List Items
R) Visual Attribute
S) LOVs
T) Non Input Items
U) Canvas
V) Windows
W) Trigger Execution Hierarchy
1. An OC4J instance was started on a development PC and then a form was run from the Forms Builder. Which of the following statements describes the behavior of OC4J?
a. It appears in the Forms Builder window that can be minimized once OC4J starts
b. It appears in a separate window that can be closed once OC4J starts
c. It appears in the Forms Builder window that can be closed once OC4J starts
d. It appears in a separate window that should not be closed as the OC4J instance will abort
2. In which ways is an OC4 J instance shutdown neatly?
a. Make Exit selection Runtime Web form menu
b. Close Form Builder which would automatically close the Instance
c. Execute a batch file that is included with the Oracle9iDS
d. Close the Window from which OC4J started
e. Start the OC4J shutdown Instance
3. An Application was created based on the Employees Personal Information
and the Department in which they work. It consists of two blocks. The first one
is the Database Data block based on the Employees Personal Information like Name and Address and the other is non database data block based on the Employees Department Information. At runtime, the cursor is initially in the non database data block, the user clicks the Enter Query toolbar button and tries to search the Personal Information record of Employee whose Name is TOM. What would be the result?
a. Query would execute and the Record providing the Department Information of the employee matching the criteria would be Displayed.
b. Query would execute and the Record providing the Personal Information of the Employee matching the criteria would be displayed
c. Query would not execute as in the Enter query mode user is not allowed to navigate to other block so user cant even provide the search criteria of Employee Name in the Database data block
4. A Stock Maintenance Application maintaining information about the Automobiles was created. When the web form was interacted by the user, the
user wanted to search a record of either Automobile having Id as 'A001' or
'A002'. Which of the following methods would successfully open the Query/Where Dialog Box?
a. Enter an Alphabet with a colon (: a) in the Automobile id item then press Execute Button
b. Enter a Number with a colon (: 1) in the Automobile id item then press Execute Button
c. Enter any Alphabet in the Automobile Id item then press Execute Button
d. Enter a colon (:) in the Automobile Id item then press Execute Button
5. An Application needs a Department Module to be created. A Developer creates a Database data Block using the Data Block Wizard, after creating the Block based on the Departments table, while creating the Layout wizard, various items were placed on the canvas. The user wants to change the Employee_id Text Item to Display Item. How would it be possible?
a. It is not possible to change the Item type once its been created
b. The item type can be changed while placing the item on the canvas using layout wizard
c. Create a new Display Item and name it as Employee_id
d. None of the above
6. A number column called STATUS has been added to the ORDERS table. The SQL script was run to populate that column.
The Orders form should be updated to display the additional data. Currently, there is a non-base table display item in the Orders block called Total that is no longer desired. The Total item is located on the canvas in the position where the Status item should appear. The Property Palette for Total was opened, its name was changed to Status, and its Item Type was changed to Text Item. The form was run, but when a query was executed on the block, no data was displayed in the Status item. What should be done to correct this problem?
a. Set the Database Item property to Yes for the Status item
b. Use the form to populate the Status item, since the SQL script that was run obviously did not work
c. Set the Name property for the Status item to STATUS, because it must be uppercase to match the column name in the database
d. Use the Data Block Wizard in reentrant mode to add the item, because add a base table item cannot be added by changing the item type of an existing item
7. Three possible credit ratings are assigned to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). A RATING column was added to the CUSTOMERS table and the DBA was asked to add an item to the form so that data entry clerk can populate the RATING column. To restrict data entry clerks to one of these three values, the DBA decided to create a radio group for the Rating item. With the Customers block selected in the Layout Editor, he used the radio button to create three radio buttons on the canvas. He then set the labels (Poor, Good, and Excellent) and values (1, 2, and 3) for the radio buttons. He set the name of the radio group to RATING, its Data Type to Number, and its Database column to Rating. He then ran the form to test it. When he executed a query, however, no records were returned, although there were many customer records in the database. What can he do to make the query return the records?
a. Set the Mapping of Other Values property for the radio group to Null
b. Create a fourth radio button for an undetermined credit rating and leave its value blank
c. Create a fourth radio button for an undetermined credit rating and explicitly set its value to Null
d. Choose a different type of input, because radio groups do not allow query of Null values
e. None of the above
8. Which of the following statement is correct with regard to Data properties of a text item?
a. If the Maximum Length of an item is set to a value that is greater than the value for Width, the item will not be displayed at run time
b. The Initial Value for an item can be set outside the range of values specified by the Lowest Allowed Value and the Highest Allowed Value properties because Initial Value defines an exception to that range
c. If the Required property is set to Yes for an item whose corresponding database column does not have a NOT NULL constraint, an error will occur at run time
d. If Data Length Semantics property is set to BYTE, the Maximum Length property may have to be manually adjusted depending on the character set that is being used
9. The DBA added a STATE column defined as VARCHAR2(2) to the State table. This column will contain two-letter state abbreviations; because the State table is quite large, storing complete state names would waste space in the database. The DBA asks JOHN to add a corresponding State item to the State block of the Geographical Management form.
JOHN opened the Layout Editor of the Geographical Management form and created a list item on the canvas in the State block. In the Property Palette for the list item, he changed the Name property to State and the Database Item property to Yes. He then open the Elements in List property and add some state abbreviations and names to the list, as shown in the exhibit. When he ran the form to test it, after selecting a value from the list and clicking Commit, he received an FRM error. Its corresponding database error is the following: ORA-01401: inserted value too large for column
What should he do to correct this problem?
a. Have the DBA increase the column width in the database
b. Change the List Style property for the State item to T-list
c. Change the List Style property for the State item to Combo Box
d. Set Initial Value for the State item to one of the elements in the list
e. Set Mapping of Other Values for the State item to a two-letter state abbreviation
f. Change the elements in the list of the State item so that the list elements are the state names and the list element values are the state abbreviations
10. a Visual Attribute called VA was created to standardize the appearance of certain text items in a particular form, and values for all of its properties were defined. Which properties can be set by applying VA to the items?
a. Width
b. Height
c. Prompt
d. Font Weight
e. Fill Pattern
f. Foreground Color
11. There is an EMP block in the Employee.fmb module, which is currently on a content canvas. Items from the EMP block should be displayed on a new tab canvas. What are the ways to achieve this?
a. Create a tab canvas in the Layout Editor
For each item, associate the tab canvas by specifying the Canvas property
Set the Rendered property of each item to Yes
b. Create a Tab page in the Layout Editor
Associate the content canvas with each item by specifying the Item Canvas property
For each item, associate the tab page by specifying the Tab Page property
Set the Visible property of each item to Yes
c. Create a tab canvas in the Layout Editor
For each item, associate the tab canvas by specifying the Canvas property
For each item, associate the tab page by specifying the Tab Page property
d. Create a canvas in the Object Navigator
Set the Canvas Type property to Content
For each item, associate the new canvas by specifying the Item Canvas property
e. Create a new canvas in the Object Navigator
Set the Canvas Type property to Tab
For each item, associate the new canvas by specifying the Item Canvas property
For each item, associate the tab page by specifying the Tab Page property
12. An Application was created in which the various triggers were defined at the Form level, Block level, Item level. The Execution Hierarchy property of the Trigger defined at the Form level was set to Before, For the Block level trigger it was set to Before, For the Item level Trigger it was set to after. How would the various triggers fire, based on the execution Hierarchy?
a. Firstly Block level then Form and in the last Item level trigger would fire
b. Firstly Item level then Block level and in the last Form level
c. Firstly Block level then Form level and in the last Item level.
