Deck 10: Advanced Forms Builder Topics

Question 1

Lists should be used in place of radio buttons if there are more than two items to choose from.

Answer 1

False

Question 2

Forms Builder supports a number of items that display data but do not allow the user to change the displayed value.

Answer 2

True

Question 3

Forms Builder supports five types of static list.

Answer 3

False

Question 4

When the user opens a Poplist,the drop-down box displays up to 10 items at once.

Question 5

You should always use T-Lists for lists with more than five to ten selections.

Question 6

When you display image items on a form,the displayed image should be about the same size as the form image item.

Question 7

Boilerplate form items display database data.

Question 8

To count the number of records that a data block form query retrieves before the form actually retrieves the records,you place the form in Query Count mode.

Question 9

To load a file image into the form image item,you use the READ_ IMAGE_FILE built-in procedure.

Question 10

You can create a form trigger that requires users to enter a search condition.

Question 11

You use dynamic images to display images that are retrieved from the database or file system while the form is running.

Question 12

Production databases can contain thousands,or hundreds of thousands,of data records.

Question 13

An LOV must retrieve at least half of the records before the LOV display appears.

Question 14

A T-List always displays the current selection.

Question 15

You should use a form list item to allow the user to select from a limited number of choices that do not change very often.

Question 16

Display Items can only be created using the Display Item Wizard.

Question 17

A static list item can dynamically retrieve database data values.

Question 18

A user can type a value into a Combo box if the desired value does not appear in the list.

Question 19

When creating a dynamic image,it is best to use ANY as the file type.

Question 20

When setting an image item's Sizing Style property,a value of Scale will cause the image to be resized to fit the space.

Question 21

When creating a summary display item,you must change the summary items ____ property value to 1,or a separate summary item will appear for each record displayed.

A)Number of Items Displayed
B)Item Count
C)Display Number
D)Number Displayed

Question 22

The ON-CLEAR-DETAILS and ON-POPULATE-DETAILS triggers are always present in a form with a master-detail relationship.

Question 23

The ____ is used to create Boilerplate text.

A)Text tool
B)Display Item tool
C)Line tool
D)Frame tool

Question 24

Form list items display ____,which means that the developer specifies the list values when he or she creates the form.

A)static lists
B)fixed lists
C)pre-created lists
D)loaded lists

Question 25

In a complete delete the form deletes the master record and then deletes all of the associated detail records in the detail blocks database table.

Question 26

The MODIFY-PROPERTY built-in is used to set relation properties at runtime.

Question 27

During the Check phase,the DBMS checks the query syntax to confirm that the syntax is correct and that the user has adequate system and object privileges for the requested database objects.

Question 28

What setting for the Calculation Mode property of a display item should be chosen if no calculation is to be performed?

A)Formula
B)Summary
C)None
D)NULL

Question 29

If a database field has a BLOB data type,what type of item is created by the Layout Editor?

A)BLOB
B)image
C)list
D)text

Question 30

You can configure an LOV's Record Group Fetch Size,Automatic Refresh,and Filter Before Display properties on the LOV Wizard Property page.

Question 31

The ____ file_type tends to slow down the performance of the READ_IMAGE_FILE built-in.

A)JPEG
B)BMP
C)ANY
D)GIF

Question 32

When the Delete Record Behavior property for a relation has a value of Master Only,Forms Builder removes the ON-CHECK-DELETE-MASTER trigger from the form.

Question 33

The Display Item tool appears as a ____.

A)text box with a white background
B)text box with a gray background
C)text box with a yellow background
D)text box with a blue background

Question 34

In a master-detail relationship,a master database record can have multiple related detail records that are defined through foreign key relationships.

Question 35

When is a dynamic image loaded?

A)when the form is designed
B)when the form is saved
C)when the form is compiled
D)at runtime

Question 36

The LOV Automatic Refresh property determines whether the LOV display refreshes each time the user opens the LOV.

Question 37

When you place boilerplate objects,such as text and shapes,on top of other boilerplate objects,in what order do the objects appear?

A)most recently created on the bottom
B)most recently created on top
C)text items always appear on top of shapes
D)shapes always appear on top of text

Question 38

When you add a new master-detail relationship to a form that already has an existing master-detail relationship,the new relationship uses the forms existing triggers and program units are always created.

Question 39

Forms Builder creates a relation object for a master-detail form.

Question 40

A display item that displays a calculated value does not have to be in the same ____ as the source items used in the calculation formula.

A)canvas
B)window
C)form
D)data block

Question 41

After counting query hits,how would you go on to execute the query?

A)Press the Continue button
B)Press the Execute Query button
C)Select Run from the Query menu
D)Select Execute from the Run menu

Question 42

When setting the Delete Record Behavior property for a relation object,a setting of ____ prevents the user from deleting a master record when associated detail records exist in the database.

A)Isolated
B)Non Isolated
C)Cascading
D)Restricted

Question 43

In a master-detail form,the master block is FACULTY,and the detail block is STUDENT,so the relation object name is ____.

A)MASTER_FACULTY
B)DETAIL_STUDENT
C)FACULTY_STUDENT
D)STUDENT_FACULTY

Question 44

For a master-detail relation,when the ____ property value is set to Yes,the form displays an error message stating that the form cannot insert or query detail records without a parent (master)record present.

A)Prevent Masterless Operations
B)No Detail Without Master
C)Master Required
D)Restrict Masterless Options

Question 45

The ____ event occurs just before the data block form retrieves the records.

A)WHEN_QUERY
B)PRE_QUERY
C)PRE_FORM
D)PRE_LOAD

Question 46

Your form contains a list that holds the states.You wish to save the value NY in the database if the user selects the value "New York" from the list.How do you configure this?

A)Set the Display Property to New York
B)Set the List Item Value to NY
C)Set the List Item Value to New York
D)There is no way to do this using Forms Builder

Question 47

After you create a list item,you configure it using its ____.

A)List Properties
B)List Wizard
C)LOV display
D)Property Palette

Question 48

____ is a built-in exception that halts processing of the current transaction.

A)END_TRANSACTION
B)FORM_END_TRANSACTION
C)FORM_TRIGGER_STOP
D)FORM_TRIGGER_FAILURE

Question 49

The ____ list item type always displays the current selection.

A)T-List
B)Poplist
C)Combo box
D)Scroll list

Question 50

What search term would you enter in an LOV display to retrieve all records?

A)%
B)*
C)NULL
D)'A-Z'

Question 51

From which Forms Services menu would you select an option to count query hits?

A)Form
B)Edit
C)Query
D)Value

Question 52

You would change the ____ property to force the user to enter a search condition in an LOV before displaying records.

A)Open Empty
B)Filter Before Display
C)Require Search Filter
D)Must Filter

Question 53

The ____ list item type allows the user to type a value.

A)T-List
B)Poplist
C)Combo box
D)Scroll list

Question 54

If you would like Forms Builder to calculate the appropriate fetch size for an LOV display,you would set the property that controls this behavior to ____.

A)-1
B)0
C)1
D)NULL

Question 55

A ____ pointer is an item in an Oracle 10g object table that creates a relationship between two tables by specifying the location of the related field.

A)REF
B)relation
C)join
D)link

Question 56

You can convert an existing text item to a list item by opening the text items Property Palette,and changing the ____ property value to List Item.

A)Data Type
B)Item Type
C)Type
D)List Type

Question 57

The LOV ____ property determines the number of records that the Oracle 10g DBMS fetches in each query processing cycle.

A)Record Group Fetch Size
B)Fetch Size
C)Record Group Size
D)Result Size

Question 58

The ____ property determines the type of list that will be displayed.

A)List Type
B)Item Type
C)List Style
D)Style

Question 59

Within a trigger,an exception is generated using the syntax ____.

A)RAISE exception_name;
B)RUN exception_name
C)ERROR exception_name;
D)THROW exception_name;

Question 60

For a relation object,if ____ is set to No then when the user selects a new master record,the form fetches the detail records immediately,regardless of the value of Automatic Query.

A)Query on Open
B)Nonautomatic Query
C)Immediate
D)Deferred

Question 61

The ____ program unit is called by the ON-CLEAR-DETAILS trigger.

A)CLEAR_MASTER
B)DELETE_DETAILS
C)CLEAR_ALL_MASTER_DETAILS
D)CLEAR_ALL

Question 62

How do you find the parameters needed to modify relation properties at runtime?

A)Using code completion in the PL/SQL Editor
B)Using Forms Builder Help
C)Each parameter name in the Property Palette can be used
D)Parameter names from the Relation Wizard can be used

Question 63

If an image should be scaled to fit an image item,a value of ____________________ should be specified for the Sizing Style property.

Question 64

The ____ program unit is responsible for displaying error messages generated by triggers.

A)SHOW_ERRORS
B)CHECK_PACKAGE_FAILURE
C)DISPLAY_TRIGGER_ERRORS
D)CHECK_ERRORS

Question 65

The ____ trigger coordinates the master and detail blocks.

A)WHEN-POPULATE-DETAILS
B)ON-LOAD
C)ON-POPULATE-DETAILS
D)PRE-COORDINATE

Question 66

If you are configuring a form trigger to handle the user clicking a radio button,with what event is the trigger associated?

A)WHEN-SELECTED
B)WHEN-RADIO-CHANGED
C)WHEN-RADIO-CLICKED
D)WHEN-STATE-CHANGED

Question 67

In the code for the PL/SQL formula,you reference form items within the formula using the block name and item name,separated by a period and prefaced with a(n)____________________.

Question 68

To create a display item,you select the Display Item tool on the ____________________ tool palette,and then draw the display item on the form canvas.

Question 69

When the Delete Record Behavior property is set to ____,neither deletion trigger is present,and the form deletes master records without trigger intervention.

A)Cascade
B)No Delete
C)Non Isolated
D)Isolated

Question 70

To change the order of boilerplate objects,you select the object,and then click the ____________________ to Front button.

Question 71

The ____ trigger is responsible for executing cascading deletes.

A)PRE-DELETE
B)ON-CHECK-DELETE-MASTER
C)CASCADE-DELETE
D)WHEN-DELETE

Question 72

A(n)____________________ is a read-only text item that does not allow user input.

Question 73

What method is used to change a relation property at runtime?

A)SET_RELATION_PROPERTY
B)SET_PROPERTY
C)SET_VALUE
D)SET_RELATION_VALUE

Question 74

Boilerplate ____________________ are frames and shapes.

Question 75

If you were creating a display item that calculates an average,you would set the property for the item that determines the calculation type to ____.

A)AVG
B)Formula
C)Summary
D)Calculated

Question 76

A(n)____________________ imported image incorporates the image data into the form design (.fmb)file and compiles it into the .fmx file.

Question 77

When loading an image file using the correct built-in,how do you specify the file hat·jpg stored in the folder c:-data?

A)'hat·jpg'
B)"hat·jpg"
C)c:-data-hat·jpg
D)'c:-data-hat·jpg'

Question 78

A(n)____________________ is a structure that contains information about the BLOB type and points to the alternate memory location where the BLOB image data will eventually be stored.

Question 79

You should use a form ____________________ item to allow the user to select from a limited number of choices that do not change very often.

Question 80

A dynamic image is loaded with the ____________________ built-in.