|
|
QUESTIONS |
FORMS Fundamental Exam Questions
Introduction
to From Builder
Q: What are the Oracle Developer Tool components? Q: The Back-End development tool consists of ______ Q: The Front-End development tool consists of ______ Q: The Form Builder components are _____ Q: What is a Form Module in the Form Builder? Q: What is a menu module in the Form Builder? Q: What do you store in a PL/SQL library? Q: What do you store in an Object Library? Q: What are the main objects of a Form Module? Q: Describe a window object in a Form Module. Q: What is a block in a Form Module? Q: What is an item in a From Module? Q: Describe a canvas in a Form Module. Q: What are the types of canvases in a Form Module? Q: Describe the Object Navigator in a Form Module. Q: Describe property palette in a Form Module. Q: What does a property palette for an object contain in a Form Module?
Q: Describe the Data Block Wizard tool. Q: Describe the Layout Wizard tool.
Form Builder (Hands-On) Q: Use the Form Builder
tool to
create a Data block for the “Customer” table. Q: How to you connect to the database objects using the
Form Builder tool? Q:
How can you create a "Datablock" for a form application using
the "Form Builder
" tool? Q: How can you create a "layout" for a form application
using the "Form Builder
" tool? Q:
How can you use a "Content canvas" for a form application using
the "Form Builder
" tool? Q:
Use the "Execute Query
" option to query customer's information. Q:
How can you navigate a table using the "Form Builder
" tool? Q:
What does the "NEXT RECORD" option do? Q:
What does the "PREVIOUS RECORD" option do? Q:
What does the "Enter Query
" option do? Q:
How can you manipulate table's record? Q:
Insert, delete and update a record. Q:
How can you save a transaction using the "Form Builder
" tool?
Tab canvas, Master-Detail relationship
Figure
1
Figure
2
Figure
3 Q: How can you create a "Datablock" for a form application using the "Form Builder " tool? Q: How can you create a "layout" for a form application using the "Form Builder " tool? Q: How can you use a "Content canvas" for a form application using the "Form Builder " tool? Q: Use the "Execute Query " option to query customer's information. Q: How can you navigate a table using the "Form Builder " tool? Q: What does the "NEXT RECORD" option do? Q: What does the "PREVIOUS RECORD" option do? Q: What does the "Enter Query " option do? Q: How can you manipulate table's record? Q: Insert, delete and update a record. Q: How can you save a transaction using the "Form Builder " tool? Q: What is a Master/Detail relationship between two data blocks in the Form Module? Q: Can a Form Module contain more than one canvas? Q:
Having performed Fact Finding, and determine
the user's initial requirements, you are ready to create a data entry form based
on those requirements. Keeping in mind that this is an iterative process, and the
User is closely involved in the design. During your interviews, you have
identified that tables Customer, Ord, and Items
will
be required, and you have an idea of the "Look-and-Feel" of the Form.
Your client asks you to create an easy to use data entry Form for their
“Customer Order” data entry application. See
Figure 1, 2, and 3 for screen layout requirements.
Help , Hint , format mask , properties
Figure
4
Q: Describe a property palette for an object in the Form
Module. Q: What does a property palette provide for you to modify
an object? Q: How do you manipulate an object in the Form Builder tool? Q:
During your prototyping iterations, the user
thought it would be useful to have a Help
option on the Form. A Help
function will enable them to view descriptions of Form items as they move from
item to item, and see helpful hints for each item. They also want to have
multi-lines on their “comments” item with word wrap; and apply their display
format mask
requirements.
Your
tasks are: 1-
Build Help
functionality on the data
entry Form at the items' level. The
Figure 4 is an example of tool tip for the “CUSTID” item. 2- Provide
“Display Format Mask” for all currency and date items based on your
client’s layout requirements and content. For example, date should be keyed in
the format MM-DD-YY, or currency amounts displayed with the dollar '$' sign,
with format mask
$99,999.99.
3- Provide
a multi-lines “comments” box for comments and make sure the text is word
wrapped. 4- Run
and test all user functional requirements. Q: How can you create a help for an item in the From
Module? Q: How can you create a hint for an item in the Form
Module? Q: What are the differences between a help object and hint
object? Q: How can you change a format mask of an item in the Form
Module? Q: How can you execute a query?
LOVs , Record Group
Figure
5 Q: What is a List of Values (LOV) in a Form Module? Q: How can you search a List of Values for a string? Q: What is a Record Group in the Form Module? Q: What is a Tab Canvas? Q: How does a Record Group work with a List of Values? Q: Your client needs more robust customer’s information
retrieval. You are going to provide them with a list of customer names by adding
a List Of Values (LOV) to the Form. This
will help the data entry clerks to find a customer quickly without knowing the
customer’s ID. The list should
contain at a minimum, the customer's name and ID. This
will provide a fast and quick way to access customer information and increase
the accuracy of the data entry. See
Figure 5.
Your
tasks are: 1- Add
a List Of Values (LOV) to the Form. 2- Retrieve
customer ID by using customer name. 3- Query
specific customer information using customer name. 4- Run
and test all user functional requirements.
Radio Buttons
Figure
6
Q: Describe a Radio Button Group. Q: How do you use a Radio Button Group? Q: Describe a Radio Button Item. Q: What are the differences between a Radio Button Group
and a Radio Button Item? Q: When do you use a Radio Button? Q: Your users have indicated that they keep track of their
salesmen's commission plans. The
company has commission plans "A," "B," "C," and
Blank. The “Blank” commission plan means that this is not applicable to
salesman. Middle Management would
like to stream line their salesmen contract assignment process. The company
assigns salesmen, based on their commission performance. Those salesmen with
higher than average commission will be rewarded and assigned to lucrative
contracts. To
accommodate Management's need for tracking high performing salesmen, they ask
you to change the commission plan item to the radio button style. See
Figure 6. Your
tasks are: 1- Change
the commission plan column to the Radio Buttons
. 2- Change
the "order tab page" to implement the Radio Buttons
. 3- Run
and test all user functional requirements. Note: The Radio Buttons
are
useful when there are two or more possible values but only one value can be
true.
Display items , Summary and function columns
Figure
7 Q: Describe a Display Item in the Form Module. Q: What are the Summary Columns in the Form Module? Q: What are the Function Columns in the Form Module? Q: What are the differences between Summary Columns and
Function Columns? Q: How do you calculate a SUM of a group of items in a
block? Q: While designing the tables, you have identified a
derived field in one of the tables (Item).
There should not be a column in a table that is calculated or generated
by two other columns. This is the Third Normal form rule. It should be rectified
for good database design. Their DBA
will remove any columns whose contents are depended on the other columns.
In the "Item" table the "itemtot" column is a column
depended on quantity * actualprice. See
Figure 7. Your
tasks are: 1- Modify
the "Items
" tab canvas
layout to
generate a new item called "itemtotal".
This field will be populated from other “Item” table’s column
during order entry (quantity * actualprice). 2- Avoid
populating the “itemtotal” from the table’s column. 3- Add
a display field to calculate the grand total of all calculated field call "itemtotal"
for each customer's order. 4- Run
and test all user functional requirements.
Triggers
Figure
8 Q: What is a Forms Trigger? Q: Describe the WHEN-BUTTON-PRESSED
trigger. Q: Describe the PRE-QUERY trigger. Q: Describe the POST-QUERY trigger. Q: Describe the PRE-INSERT trigger. Q: Describe the WHEN-NEW-FORM-INSTANCE trigger. Q: Now, the user’s DBA removed the “itemtot” column
whose content was depended on the other columns.
Your client wants you to remove the “itemtot” item from layout
screen. Also,
your application only shows products' ID. Your
client wants to see product's description since product's ID does not tell them
what the product is. They
want you to remove duplicate item information from "Items
" tab canvas
; and add a new item to display product's description
in the "Items" tab canvas. See
Figure 8.
Your
tasks are: 1- Remove
duplicate item information from "Items
" tab canvas
. 2- Add
a new item to display product's description “Product Description” in the
"Items
" tab canvas
. 3- Run
and test all user functional requirements.
Horizontal Toolbar, Push Button , Trigger
Figure
9 Q: Describe a canvas in the Form Module. Q: The four types of canvases are: ________ Q: Describe all four types of canvases. Q: How do you create a horizontal toolbar? Q: How do you create a push button item? Q: New functional requirements came in from the users.
They need a horizontal toolbar to have on their Form.
The toolbar should contain all the frequently used options. This will
make ease of use of some options. The
following are the list of all the frequently used functions they expect to use:
Move to previous record,
Move to next record,
Add new record,
Delete current record,
Save work, and
Exit the application. See
Figure 9.
Your
tasks are: 1- Adding
more functionality to the application. 2- Create
a horizontal Toolbar. 3- Create
push button for above frequently used functions list. 4- Create
and compile triggers for each push button created on step 3. 5- Run
and test all user functional requirements.
Sizing , Layout appearances
Figure
10 Q: Describe a Window in the Form Module. Q: The properties of an object can be changed to control
the behavior of the _____. Q: What is a Data Block in the Form Module? Q: How do you resize an object in the Layout Editor? Q: How do you move an object or a group of objects in the Layout Editor? Q: What are the handlers in a selected object? Q:
On pervious Hands-On, your users only see the
horizontal toolbar canvas
instead
of the Customer, Orders, and Items
canvases.
They have to drag the window in order to see their “Customer Order”
application. They complain that it
is cumbersome to drag the window in order to use the application.
You have been assigned to fix this problem.
The requirement from your client is: to make sure your layout was
properly sized so your client doesn't need to drag or expand the window size. See
Figure 10.
Your
tasks are: 1- Make
sure the canvas was sized properly. 2- Run
and test all user functional requirements.
Trigger (PRE-QUERY ), Set dynamically properties
Figure
11
Q: Describe the PRE-QUERY trigger. Q: How do you set a block property dynamically? Q: Can you attach several triggers to an object in the
Form Module? Q: On the
"Orders" tab, your client wants to see the most recent or last
customer orders. They ask you to
sort the customer orders list based on their order’s date.
They like to have two radio buttons to allow them to manipulate the order
of displayed records by order date. You
have been assigned to create two radio buttons, Labeled "Ascending"
and "Descending"
to sort displayed record order by "order date." See
Figure 11. Your
tasks are: 1- Create
a Radio Group. 2- Create
two Radio Buttons
associated
with step 1 (Radio Group). 3- Label
the first Radio Button “Ascending.” 4- Label
the second Radio Button “Descending.” 5- Run
and test all user functional requirements.
Sequence object, Trigger (PRE-INSERT )
Figure
12 Q: Describe a Sequence object in a Form Module. Q: How do you create a sequence object in a Form Module? Q: Describe the PRE-INSERT trigger. Q: How do you create and use a PRE-INSERT trigger in a
Form module? Q: How do you navigator through tab canvases? Q: What for do you use an object’s property palette? Q: How do you read and test a sequence object? Q: It is very cumbersome for your users to assign a new
customer ID to a new customer. It
requires finding what the last customer ID was entered into their system; then
they increment it by 1 and use that number for a new customer ID. This is not very a professional way of doing business
particularly if you have multiple transactions to enter. You
have been assigned to solve this problem and automate this process.
They ask you to add a sequence number to customer ID (CUSTID) starting
with 200 and incremented by 1. So,
your customer ID would start from 200, 201, 202, and so on. See
Figure 12.
Your
tasks are: 1- Create
a sequence number to generate a unique customer ID. 2- Assign
the generated sequence number to each customer each time a new customer is added
to a table. 3- Run
and test all user functional requirements.
Call FORMS
Figure
13
Q: What are the ways you can execute a form in a form? Q: What are the differences between the OPEN_FORM,
CALL_FORM, and NEW_FORM build-in subprograms? Q: What is a Global variable? Q: How can you create a form to call another form? Q: How do you compile a trigger in a form module? Q: Your client wants to have another application Form to
query, insert, delete, and update their product history prices.
They want to open the Form from their “Customer Order” application. It
is their requirement that the window size for product price should be small
enough to fit on a small portion of their application. Also, it is part of their
requirement to have a Push Button
to click
in order to open and run the product history prices application from the
“Items
” tab canvas
. You
should modify their application to provide such request. See
Figure 13.
Your
tasks are: 1- Create
the product history prices Form. 2- Test
all its user functional requirements, such as insert, delete, and update. 3- Create
a Push Button
on the
“Items
” tab canvas
to open
the Form that created from step 1. 4- Create
and compile trigger to call the Form that was created from step 1. 5- Run
and test all user functional requirements.
Global Variable , Trigger
Figure
14 Q: How do you define a binding variable in a multiple
forms? Q: How do you assign a value to a global variable? Q: How do you pass a global variable value from one form
to another? Q: How do you use a global variable to execute a query
based on its parameter? Q: Describe the "WHEN-NEW-FORM-INSTANCE
" trigger. Q: How do you create the "WHEN-NEW-FORM-INSTANCE
" trigger? Q: Now, your client desires it would be better if they
could get specific history of product price rather than entire product history
prices table. They want you to add
more functionality to their application to display only current history of
product prices information. Note: The current product would be defined by where the position of
your cursor is. You
have been assigned to modify their application to query only history of product
price information for a product rather than entire table. See
Figure 14.
Your
tasks are: 1- Automate
the “product history prices” application to query only a history of product
prices. 2- Pass
product ID as a parameter between these two Form applications. 3- Run
and test all user functional requirements.
Main Menu
Figure
15
Q: What is a main menu in the Form Builder? Q: Are the main menus independent of form? How? Q: What is the default main menu name? Q: How do you use NAME_IN and COPY build-in subprogram? Q: How do you create a default main menu? Q: How do you modify a default main menu? Q: Your client loves what you have done for them.
But they would like you add the same functionality you did at Hands-On 12
to have it on the main menu of the “Customer Order” application. You
have been assigned to modify the main menu and add functions from Hands-On 12 to
their window's main menu. See
Figure 15.
Your
tasks are: 1- Modify
the default main menu and add a menu item as “Data” and a sub-menu item as
“Product Price” on the “Customer Order” Form. 2- Delete
some unused menu items. 3- Pass
product ID as a parameter between these two Form applications. 4- Run
and test all user functional requirements.
Pop up menu
Figure
16 Q: Describe a Pop-Up menu in a Form Module. Q: How do you create a Pop-Up menu? Q: Your client wants to have capability to cut, paste, and
copy words or lines when they type their comments in the "comments"
item at the "Customer" tab canvas
. You
have been assigned to add the above functions into the "comments"
item in their application. See
Figure 16.
Your
tasks are: 1- Add
more functionality into the “comments” text item. 2- Create
pop-up menu to have cut, past, and copy functions. 3- Associate
pop-up menu to the “comments” item. 4- Run
and test all user functional requirements.
Move Objects, Layout Appearances
Figure
17 Q: How do you use a window in the Form Module? Q: Describe a Data Block in the Form Module. Q: Describe a Control Block in the Form Module. Q: What are the differences between a control block and a
data block? Q: How do you move an object or objects around in the
Layout Editor? Q: How do you copy and paste an object or objects in the
Layout Editor and in the Object Navigator? Q: How do you select a object or objects in the
Layout Editor and in the Object Navigator? Q: All your client functional requirements have been met.
Now, your user focuses on the appearance of the application.
They would like you to move and add some objects.
They want their logo be displayed on each of their application tab
canvas. See
Figure 17.
Your
tasks are:
Run Application from desktop
Figure
18 Q: How can you run an application from desktop? Q: They ask you that they would like to run their
application from the desktop
. They
want to use Forms “Runtime” to execute their application. See
Figure 18.
Your
tasks are: 1- Create
an icon on the client PC desktop
. 2- Use
Forms “Runtime” to run their application. 3- Associate
their “Customer Order” application to the Forms “Runtime.” 4- Run
and login to application from icon. 5- Run
and test all user functional requirements.
Viewing
a picture using BLOB
datatype
Q: Describe the BLOB datatype. Q: How do you create an item containing picture in a
canvas? Q: Since you had inserted the employee pictures into the
EMP table successfully (from PL/SQL hands-on), now the organization wants to
view the pictures that were inserted. You
have been assigned to develop an application form to display all of the employee
information plus their pictures.
REF
CURSOR
Q:
What is a REF Cursor? Q: What is a table of records?
FORM
BLOCK
and
TRANSACTIONAL TRIGGERS
Q: What is a transactional trigger? Q: How do you use a stored procedure in stead of tables to
create a form? Q: When do you use a transactional trigger?
Parameter
List
Q: How do you pass a parameter from one form to another? Q: Describe the following build-in procedures and functions:
CREATE_PARAMETER_LIST
ADD_PARAMETER
GET_PARAMETER_LIST
DESTROY_PARAMETER_LIST
DELETE_PARAMETER
Introduction to Schema Builder Q: How can you create a table using the "Schema Builder " tool? Q: How can you define a column, attribute, and primary key
using the
"Schema Builder
" tool?. Q: How can you define a required field and unique key using the
"Schema Builder
" tool?. Q: How can you grant an object privilege to the public using the
"Schema Builder
" tool? Q: How can you check what other users can access using the
"Schema Builder
" tool? Q: How can you remove a table using the "Schema Builder
" tool?
Introduction
to Query Builder
Q: Create a query using the "Query Builder
" tool. Q:
How can you join multiple tables using the "Query Builder
" tool? Q:
How can you establish table relationship between multiple tables using
the "Query Builder
" tool? Q:
Execute a query using the "Query Builder
" tool. Q:
Sort a query using the "Query Builder
" tool. Q:
How can you add a "WHERE" clause condition to a query using the
"Query Builder
" tool? Q:
List a query using the "Query Builder
" tool. Q:
Save a query using the "Query Builder
" tool.
Introduction
to Graphics Builder
Q:
How can you create a chart using the "Graphics Builder
" tool? Q: How can you run a query
against a chart? Q:
How can you modify a query? Q:
How can you save a query? |
|