1. You open a single property sheet to display properties for your
DEPARTMENT data block and DEPARTMENT canvas simultaneously. Which Property
Palette display mode is likely to show more properties?
A . Intersection
B*. Union
Explanation:
Union
The Intersection display mode shows only the properties that multiple
selected objects have in common, while the Union display mode shows all
properties for all selected objects, whether the objects share the
properties in common or not.
2. What does it mean when the Property Palette displays ***** as a
property's value?
A*. Two or more objects are selected, and their values for that property
are not the same.
B . The value "*****" will be inserted into the field automatically.
C . You cannot update that property for the object you have selected.
D . The property is not applicable for the object you have selected.
Explanation:
Two or more objects are selected, and their values for that property are
not the same
Because the Property Palette cannot display more than one value per
property, the only way it can deal with multiple objects is to display
something special when those objects' values are different. The special
display is *****.
3. What happens if you select multiple objects, open the Property Palette,
and change a property's value?
A . The changed value displays as *****.
B . The Property Palette shows each object's old and new values for that
property.
C*. The change is applied to all selected objects.
D . You cannot change a property for multiple objects at one time.
Explanation:
The change is applied to all selected objects
4. Which data block property would you consider changing if your records
include LONG items that are not likely to be edited?
A*. Update Changed Columns Only
B . Update Allowed
C . Query Allowed
D . DML Array Size
Explanation:
Update Changed Columns Only
If your records include LONG items that are not likely to be edited, this
data block property can improve application performance by keeping the
application from sending the voluminous LONG data back to the server
during an update command.
5. What does the Property Palette toolbar field labeled Find do?
A . Locates other objects containing the same property as the one you
currently have selected
B . Allows you to search-and-replace a given property value with a
different value
C . Locates Form Builder files on your hard disk
D*. Forces the Palette to place its focus on the first property matching
the characters you type
Explanation:
Forces the Palette to place its focus on the first property matching the
characters you type
The Property Palette toolbar field labeled Find makes the Property Palette
quickly jump to specific properties. If the group containing the matching
property is closed, the Find field will even open it up for you.
6. What would be the result of completely deleting a data block from the
Object Navigator?
A . The data blocks and components are deleted but can be retrieved using
the Edit | Undo command.
B . The data blocks and components are irreversibly deleted, and all
components from the data block are removed from any canvas that contained
them, including the data block's frame and boilerplate title text.
C*. The data blocks and components are irreversibly deleted, and all
components from the data block are removed from any canvas that contained
them, but the data block's frame and boilerplate title text will stay on
the canvas.
D . The data blocks and components are irreversibly deleted, and all
components from the data block stay on the canvas and must be deleted
manually.
Explanation:
The data blocks and components are irreversibly deleted, all components from the data block are removed from any canvas that contained them, but the data block's frame and boilerplate title text will stay on the canvas.
7. What does the Property Palette context bar do?
A . Nothing
B*. Identifies which object's properties are currently being displayed by
the Property Palette
C . Identifies which program you are in when you open the Property Palette
D . Provides help instructions based on your location in the Property
Palette
Explanation:
Identifies which object's properties are currently being displayed by the
Property Palette.
8. Which of the following occur if you copy multiple properties from one
object and paste them into another?
A*. No Answer is Correct
B . Properties not relevant to the destination object will be added to
that object.
C . Properties with blank properties will be pasted.
D . It is not possible to copy multiple properties at one time.
E . If the destination is a different type of object than the source, the
destination object will be changed to the same type of object as the
source.
Explanation:
No Answer is Correct
The Property Palette can copy and paste individual or multiple properties.
When copying multiple properties, the Palette pastes only the properties
for which an actual value is shown, and only the properties that are
relevant to the object receiving the pasted properties.
9. You created an LOV for stock items and included a Quantity Currently In
Stock column in the LOV. How can you ensure that the user sees accurate
"in stock" numbers each time the LOV is invoked?
A . There is no way to ensure this.
B . Programmatically requery all tables in the application when the user
opens that canvas.
C*. Enable the LOV's Automatic Refresh property.
D . Enable the LOV's Automatic Select property.
Explanation:
Enable the LOV's Automatic Refresh property
The Automatic Refresh property determines whether the LOV's underlying
query executes every time the LOV is invoked, or only the first time it is
invoked. Setting the property to Yes configures it to requery every time.
10. You have created a SALES_TICKET form for a point-of-sale application.
You now want to modify the Transaction_Date_Time item in the form so it is
automatically populated with the current date and time each time a new
record is created. How can you accomplish this?
A . Set the Default Value property to SYSDATE.
B . Set the Initial Value property to SYSDATE.
C . Set the Default Value property to $$DATETIME$$.
D*. Set the Initial Value property to $$DATETIME$$.
Explanation:
Set the Initial Value property to $$DATETIME$$.
The is no Item property called Default Value, and while SYSDATE is a valid
parameter in a SQL query, it will not work in the Initial Value property;
you must use $$DATETIME$$.
11. What does freezing the Property Palette do?
A . Enables you to change a property in multiple objects at one time
B . When multiple objects are selected, shows only those properties that
all selected objects share in common
C*. Forces the Palette to continue displaying properties for the currently
selected object(s), regardless of what object(s) you select from that
point on
D . Opens a second Palette for comparing multiple objects' properties
Explanation:
Forces the Palette to continue displaying properties for the currently
selected object(s), regardless of what object(s) you select from that
point on
12. What is the best way to ensure that an item cannot accept query
criteria?
A . Set the item's Query Length property to 0.
B . Set the item's Queryable property to No.
C*. Set the item's Query Allowed property to No.
D . Set the item's Disable Query property to Yes.
Explanation:
Set the item's Query Allowed property to No
There are no properties named Disable Query or Queryable. Setting the
Query Length property to 0 simply tells Oracle Forms 6i to use the item's
length as the maximum query length.
13. How many characters would you need to type in an LOV to select the
WHEN-KEY-UP item from a list containing WHEN-BUTTON-PRESSED,
WHEN-KEY-DOWN, and WHEN-KEY-UP, assuming they are the only items in the
list and the LOV's properties are set to automatically display the LOV and
automatically enter the value once a row is selected?
A . 3 characters
B . 1 character
C*. 2 characters
D . 10 characters
Explanation:
2 characters
Because all three choices begin with "WHEN-," the LOV only cares about the
first differentiating character, which is the "K" that identifies the KEY
group. The next character needed is the "D" to select DOWN, after which
the row's key value will automatically be entered into the text item.
14. What is the definition of the term "text item"?
A . Any control on your form that allows the user to view and edit text,
numbers, or dates
B . Any control on your form that allows the user to view and edit text
C . Any control on your form that allows the user to view and edit text or
numbers
D . The label preceding a field on a form
E*. Any control on your form that allows the user to view and edit text,
numbers, dates, or long data
Explanation:
Any control on your form that allows the user to view and edit text,
numbers, dates, or long data
15. You have created an LOV for a text item on your canvas, and you would
like the LOV to appear automatically each time the user enters that text
item. What is required to make that happen?
A . Set the Automatic Select property in the LOV Property Palette to Yes.
B*. Set the Automatic Display property in the LOV Property Palette to Yes.
C . Set the Automatic Refresh property in the text item Property Palette
to Yes.
D . Set the Automatic Refresh property in the LOV Property Palette to Yes.
E . Set the Automatic Display property in the text item Property Palette
to Yes.
Explanation:
Set the Automatic Display property in the LOV Property Palette to Yes.
No text item property would effect this change. Of the LOV properties
listed, Automatic Refresh determines whether the LOV's contents are
requeried each time it is opened, and Automatic Select specifies whether
the selected LOV row is placed into the specified text item without the
user having to double-click on the row or click the OK button.
16. Which of the following actions can a user do with a display item?
A . Delete existing database values.
B . Update existing database values.
C*. View existing database values.
D . Insert new database values.
E . All Answers are Correct
Explanation:
View existing database values
A display item shows data but does not allow the user to change it. In
essence, it is a read-only field.
17. To which of the following items does a control block directly
correspond?
A . All Answers are Correct
B . Database
C*. No answer is correct
D . Table
E . Column
Explanation:
No answer is correct
A control block is not associated with a database object. Instead, it
contains either controls (such as buttons), or a group of items with
single values (such as calculated subtotals).
18. When a control block is created, what items does it contain?
A . None, because, you cannot put items in a control block.
B . Text items for all columns in the related database table.
C*. None. You must manually create any items that will go into a control
block.
Explanation:
None. You must manually create any items that will go into a control
block.
By definition, a control block is not related to a database table. And you
can put items into a control block-that is what it's for. But you must do
it manually after the block is created.
19. What is the definition of an input item?
A . A form object through which the user can view data
B . A dialog box
C . A graphics element affecting how a chart will look
D*. A form object through which the user can enter and change data
E . A form object through which the program can enter and change data
Explanation:
A form object through which the user can enter and change data
Input items are the basis of forms-they enable a user to add or edit data.
A dialog box may contain input items, but the dialog itself is a window,
not an input item.
20. Users of your application have requested that they be able to see
STOCK and CUSTOMER canvases on the screen simultaneously. You add a second
window to the application. How can you make the CUSTOMER canvas use the
second window?
A . Change the window's Primary Canvas property.
B . Change the canvas's Visual Attributes group.
C*. Change the canvas's Window property.
D . It is not possible to change a canvas's display window.
Explanation:
Change the canvas's Window property
A canvas's Window property determines which window the canvas is visible
in. The Visual Attributes Group has no window selection properties, and a
window's Primary Canvas property specifies the primary canvas for a window
that displays multiple canvases.
21. Which check box property controls the text that displays next to the
check box?
A*. Label
B . Text
C . Name
D . A check box's text is fixed and cannot be changed.
Explanation:
Label
Remember that both Prompt and Label can place text next to a radio button.
22. Which type of canvas is best suited for displaying tutorial text on
the same canvas as the form about which the user is being taught?
A . Tab
B . Viewport
C*. Stacked
D . Toolbar
E . Content
Explanation:
Stacked
The requirement that the tutorial text be visible on the same form limits
the choices to either stacked or tab. A tab canvas might be useful for a
multipage tutorial, but the requirements did not state the need for
multiple pages, so a simple stacked canvas will fulfill the requirement.
23. You are working with an existing radio group in the Layout Editor and
try to add a radio button to the group. The Layout Editor responds by:
A . Displaying a warning message, and then returning you to the Layout
Editor
B . Offering to create a check box instead, since a radio button group
already exists
C*. Presenting a dialog box giving you the chance to select a radio group
for the new radio button, or create a new radio group for it
Explanation:
Presenting a dialog box giving you the chance to select a radio group for
the new radio button, or create a new radio group for it
The Layout Editor is willing to add buttons to an existing radio group. It
just needs to know which group will get the new button, or if a completely
new group is what you desire.
24. Your Employee form includes a SALARY text item. You want to ensure
that standard users cannot input or change a salary value, but you want
the value to look exactly like a regular field. What is the best way to do
this?
A . Set the item's Enabled property to No, and its Update Allowed property
to No.
B*. Set the item's Insert Allowed property to No, and its Update Allowed
property to No.
C . Set the item's Enabled property to No.
D . It is not possible for an unchangeable item to look like a changeable
item.
Explanation:
Set the item's Insert Allowed property to No, and its Update Allowed
property to No
Changing an item's Enabled property to No causes its contents to display
with light gray characters instead of black. Therefore, this is the only
valid choice.
25. What type of canvas can easily eliminate the need for a menu in your
application?
A*. Toolbar
B . Content
C . Tab
D . Stacked
Explanation:
Toolbar
A toolbar canvas's sole purpose is holding buttons that initiate actions.
The buttons can replace every menu action your users would need to take.
26. The DEPARTMENT table in your database has been augmented with a BUDGET
column. You want to add BUDGET as an item on your Department form, but the
item should be a read-only text box so users cannot change it. The best
way to do this is:
A . In the Layout Editor, create a display item and set its Insert Allowed property to No, its Update Allowed property to No, and its Database Item property to No.
B . In the Data Block Wizard, move the BUDGET column into the Available
Items area. Change the new data block item's Insert Allowed and Update
Allowed properties to No. Proceed to the Layout Editor and add BUDGET as a
text item.
C . In the Data Block Wizard, move the BUDGET column into the Available
Items are C:
Proceed to the Layout Editor and add BUDGET as a text item, and change the
item's Insert Allowed and Update Allowed properties to No.
D*. In the Layout Editor, create a display item and set its Column Name
property to BUDGET.
Explanation:
In the Layout Editor, create a display item and set its Column Name
property to BUDGET.
Setting an item's Database Item property to No keeps it from retrieving
database data, eliminates two answers, but it creates a normal-looking
text box that actually allows the user to type in data; it isn't until the
user tries to save their work that the data block's Insert Allowed and
Update Allowed properties halt the action. This is not optimal design. The
third incorrect answer creates an application in which the field's data
cannot be changed, but the user can still place focus on the field, which
is also not optimal.
27. You have created a form that contains two canvases, ten database
items, and four buttons. The items have all been placed into a group, and
the buttons have been placed into a separate group. What happens when you
click one of the buttons in the Layout Editor?
A*. The group of buttons is selected.
B . Nothing is selected.
C . All groups are selected
D . The button is selected.
E . All items on the button's canvas are selected
Explanation:
The group of buttons is selected.
The primary reason for groups is to ensure that when any item in the group
is selected, all items are selected with it.
28. Which canvas type is most dissimilar to the others?
A . Content
B . Stacked
C . Tab
D*. Toolbar
Explanation:
Toolbar
Content, stacked, and tab canvases are all intended to display database
data. The toolbar canvas type is not; it is intended to display buttons
that work in concert with the items on the other three canvas types.
29. What is the primary difference between tab and stacked canvases?
A . A stacked canvas can contain push buttons.
B . A stacked canvas obscures what is beneath it.
C*. A tab canvas can contain multiple pages.
D . A tab canvas looks much cooler.
Explanation:
A tab canvas can contain multiple pages.
The essence of a tab canvas is the fact that it consists of multiple pages
of data, each page overlaying the others when it is selected by the user
or developer. It is not possible to get this functionality from a single
stacked canvas.
30. What trigger would you use to execute code each time a user modifies
the value of a check box?
A . ON-NEW-CHECKBOX-INSTANCE
B . WHEN-CHECKBOX-UNCHECKED
C . WHEN-CHECKBOX-CLICKED
D . WHEN-CHECKBOX-CHECKED
E*. WHEN-CHECKBOX-CHANGED
Explanation:
WHEN-CHECKBOX-CHANGED
31. You would like to create a trigger that fires each time a window is
closed by the user. You will most likely place the trigger at which of the
following levels:
A . Canvas level
B . Window level
C . Data block level
D . Item level
E*. Form level
Explanation:
Form level
Windows do not have triggers. Placing the WHEN-WINDOW-CLOSED trigger at
the Form level allows it to fire when any window in the module is closed.
32. What trigger would fire each time a new record is created?
A . ON-NEW-RECORD
B*. WHEN-NEW-RECORD-INSTANCE
C . WHEN-VALIDATE-RECORD
D . WHEN-DATABASE-RECORD
Explanation:
WHEN-NEW-RECORD-INSTANCE
ON-NEW-RECORD is not a valid trigger name. Choices WHEN-VALIDATE-RECORD
and WHEN-DATABASE-RECORD fire at other times. Review the section
"Supplementing the Functionality of Input Items" if you need a reminder on
this topic.
33. What do you need to do to within Form Builder to run a form module in
debug mode?
A . Enable Debug Messages and then run your form. The Debugger will appear
automatically.
B*. Enable the Debug Mode button, run the form, and the Debugger displays
automatically.
C . Run the form, and in the Forms Runtime program execute the Help |
Debug menu command.
D . Enable the Debug Mode button, run your form, and in the Forms Runtime
program execute the Help | Debug menu command.
Explanation:
Enable the Debug Mode button, run the form, and the Debugger displays
automatically.
See the section "Running a Form Module in Debug Mode" for a refresher on
this topic.
34. When does the PRE-QUERY trigger fire?
A*. After the user enters query criteria, but before the query executes
B . Before the form enters Enter-Query mode
C . After the form enters Enter-Query mode, but before the user enters
query criteria
D . After the query executes, but before records are shown to the user
Explanation:
After the user enters query criteria, but before the query executes
The PRE-QUERY trigger fires after Enter-Query mode but before a query's
select statement has been finalized, and therefore before the query is
executed.
35. Which built-in causes an editor to display for a text item?
A . WHEN-NEW-ITEM-INSTANCE
B . SHOW-EDITOR
C*. SHOW_EDITOR
Explanation:
SHOW_EDITOR
SHOW-EDITOR is formatted as a trigger, not a built-in, and doesn't exist.
WHEN-NEW-ITEM-INSTANCE exists but is also a trigger, not a built-in.
36. You want to write a trigger that screens a query condition. At what level will you place the trigger?
A . Block
B*. Form
C . Item
D . Record
Explanation:
Form
37. You wish to have certain values in a form initialized when the form is
first opened. What trigger will you use?
A . WHEN-NEW-CANVAS-INSTANCE
B*. WHEN-NEW-FORM-INSTANCE
C . WHEN-NEW-FORM
D . WHEN-FORM-OPENED
E . WHEN-NEW-CANVAS
Explanation:
WHEN-NEW-FORM-INSTANCE
None of the other choices are valid triggers.
38. What part of a trigger specifies the trigger's actions?
A . Type
B . Name
C*. Code
D . Scope
Explanation:
Code
A trigger's actions are defined entirely by its code.
39. Which built-in causes an LOV to display for a text item that has one
defined?
A . WHEN-NEW-ITEM-INSTANCE
B . WHEN-NEW-LOV
C . GO_ITEM
D*. SHOW_LOV
Explanation:
SHOW_LOV
WHEN-NEW-ITEM-INSTANCE and WHEN-NEW-LOV are triggers, not built-ins.
GO_ITEM navigates to an item but does not open an LOV.
40. What trigger can you use to ensure that a query entered by the user
includes at least one item that is indexed, and keep the query from
occurring if not?
A*. PRE-QUERY
B . WHEN-CLEAR-BLOCK
C . ON-SELECT
D . POST-SELECT
E . ON-FETCH
Explanation:
PRE-QUERY
While the other triggers listed are query triggers, only the PRE-QUERY
trigger fires before the select statement is executed.
41. What is the purpose of the KEY-OTHERS trigger?
A . Provides code to execute if a key's own trigger fails
B*. Provides code to execute if user presses a key that has no trigger
attached
C . Provides code to execute if user presses wrong key
D . Provides code that accesses another key's trigger and executes the
code it contains
Explanation:
Provides code to execute if user presses a key that has no trigger
attached.
See the section "Form Trigger Categories" for a refresher on this topic.
42. Your data analysis application is slowing the network to a crawl. You
analyze the queries users are performing and discover that the majority of
their queries are too broad, returning many more records than necessary.
You decide to require that any query have at least three fields containing
criteria. What type of trigger can you use to enforce that requirement?
A . POST-QUERY
B . ON-NEW-QUERY-INSTANCE
C . PRE-UPDATE
D*. PRE-QUERY
E . POST-UPDATE
Explanation:
PRE-QUERY
The PRE-QUERY trigger fires before a query's select statement has been
finalized, and is therefore ideal for screening query criteria before the
query is executed.
43. You have created an alert with three buttons. What value will be
returned if the user selects the second button?
A . BUTTON2
B . DIALOG_BUTTON2
C*. ALERT_BUTTON2
D . It depends on the choice being offered by the button.
Explanation:
ALERT_BUTTON2
44. What is the default level at which validation occurs in the Forms
Runtime program?
A*. Item
B . Form
C . Block
D . Record
Explanation:
Item
By default, the Forms Runtime program validates an item immediately when
the user tries to leave the item.
45. How does the Forms Runtime program respond when a user enters text
into a text item that has an LOV attached and the VALIDATE_FROM_LIST
property set to Yes?
A . The Forms Runtime program ignores the LOV if the user types a value
directly into the field.
B . The Forms Runtime program populates the item automatically with the
first value in the LOV that matches the user's entry.
C*. The Forms Runtime program opens the LOV and shows only items that
match what the user has typed so far.
D . Validate From List is a Data Block property, not an Item property.
Explanation:
The Forms Runtime program opens the LOV and shows only items that match
what the user has typed so far.
See the section "Introduction to Form Builder Validation Properties" for a
refresher on this topic.
46. How can you cause a block to use a database sequence to get unique
IDs?
A . Set the Initial Value property to :sequence.sequence-name.nextval.
B . Set the Validate From List property to
:sequence.sequence-name.nextval.
C . Set the DML Array Size property to :sequence.sequence-name.nextval.
D*. This action is not possible.
Explanation:
This action is not possible.
Data blocks cannot read sequences, and in fact cannot store values at all.
Items, on the other hand, can.
Give yourself half a point if you answered:
Set the Initial Value property to
:sequence.sequence-name.nextval.
which would have been the right answer if the question had referred to an
item instead of a block, and remember to pay closer attention to the
wording of questions. In some Oracle exam questions, a single word defines
why one choice is right and another choice wrong.
47. You have written a contact-tracking application that includes a field
for the last date a client was contacted. You want to use a trigger to
guarantee that whenever the date in that field is changed, the date
entered is later than the date that was there before. What is the best
trigger to use?
A . PRE-UPDATE
B . ON-COMMIT
C . ON-UPDATE
D*. PRE-COMMIT
E . POST-UPDATE
Explanation:
PRE-COMMIT
PRE-COMMIT is a form-level trigger that fires only once at the beginning
of a transaction, so it cannot perform validation on a row-by-row basis.
ON-UPDATE and ON-COMMIT only occur if you have replaced the default Forms
Runtime transaction processing. POST-UPDATE occurs after the update has
occurred, so it is too late for a validity check. The remaining trigger,
PRE-COMMIT, is perfect.
48. Your form module's Validation Unit property is set to Form. The module
includes a data block that has a PRE-TEXT-ITEM trigger. At what point will
the trigger fire?
A*. Never
B . When data is committed
C . Before the form is validated
D . After the form is validated
Explanation:
Never
The trigger will not fire because the object level defined in the trigger
name item is smaller than the module's validation unit.
49. You want to add a delete-confirmation dialog to your application. You
can do so by creating which type of object?
A*. Alert
B . Message
C . Editor
D . Message box
Explanation:
Alert
50. You would like to keep the user from seeing the Forms Runtime
program's "nn records applied and saved" messages. What would you put in
the form's WHEN-NEW-FORM-INSTANCE trigger?
A . :system.message_level := 0;
B . :system.suppress_working := 'TRUE';
C . :system.suppress_working := 'FALSE';
D*. :system.message_level := 5;
Explanation:
:system.message_level := 5;
See the section "Controlling System Messages" for a refresher on this
topic.
51. What is the last DML statement processed during a commit transaction?
A*. INSERT
B . UPDATE
C . DELETE
D . POST
Explanation:
INSERT
The post command does not perform a commit. Of the three remaining
choices, their processing order is delete, update, and then insert.
52. Which of these built-ins can you use in a PRE-UPDATE trigger?
A . DOWN
B . COMMIT_FORM
C*. No Answer is Correct.
D . All Answers are Correct.
E . GO_ITEM
Explanation:
No Answer is Correct.
Each built-in listed is a navigational built-in, which cannot be used
within the navigational trigger PRE-UPDATE.
53. Which navigational built-in will move the focus to a subsequent record
and place it on the same item it was on in the original record?
A . NEXT_BLOCK
B . NEXT_ITEM
C*. DOWN
D . The described action is not possible from a single built-in.
Explanation:
DOWN
54. You would like to modify your form so it uses array processing to send
DML statements to the server in batches of 50. How would you do this?
A . Set the canvas's DML Array Size property to 50.
B*. Set the data block's DML Array Size property to 50.
C . Set the window's DML Array Size property to 50.
D . Array processing is limited to 25 records per batch.
Explanation:
Set the data block's DML Array Size property to 50.
No comments:
Post a Comment