Deck 6: Creating Custom Forms

Question 1

One way to help users avoid errors is to programmatically disable command buttons.

Answer 1

True

Question 2

It is good practice to intercept the default system error message and replace it with a custom error message.

Answer 2

True

Question 3

To ensure that a user enters only digits in a postal code field with a character data type,use a Data Type validator.

Answer 3

False

Question 4

The error code FRM-40735 indicates that a DBMS error occurred.

Question 5

If the triggering event occurs within any block item,the block trigger fires.

Question 6

The property values used in the SET_ITEM_PROPERTY function are the same as those used in the Property Palette.

Question 7

When a form contains an ON-ERROR trigger and a runtime error occurs,form execution immediately transfers to the ON-ERROR trigger.

Question 8

Use the Not NULL property to indicate that a field value is required.

Question 9

To specify the European date format for the Data Type text item property,use EDate.

Question 10

To configure a form button item,you modify the ID property,which is the name that Forms Builder uses to reference the button.

Question 11

To display a value in a text item automatically when a form first opens,you set the text item's Initial Value property to the desired value.

Question 12

The Forms Debugger is used to find and correct syntax errors.

Question 13

Whenever an ORA- or FRM- error occurs while a form is running,the WHEN-ERROR event occurs.

Question 14

By default,the validation unit for a data form is at the item level.

Question 15

The following code could be used to disable a command button: SET_ITEM_PROPERTY('UPDATE_BUTTON',ENABLED,PROPERTY_FALSE);

Question 16

When you create a custom form,you manually create the form canvas in the Object Navigator.

Question 17

To disable a text field so the user cannot modify it,use the SET_ITEM_PROPERTY function to disable it.

Question 18

An item validation trigger is an item-level trigger that you associate with the items WHEN-VALIDATE-ITEM event.

Question 19

To display an alert to the user,use the SHOW_ALERT subprogram.

Question 20

The DBMS_ERROR_CODE procedure contains the error code for the most recent FRM- error that occurred.

Question 21

When creating multiple canvases in the same form,multiple developers can each work with one of the canvases.

Question 22

What system variable displays the operating system date?

A) $$DATE$$
B) $$DATETIME$$
C) $$DBDATE$$
D) $$DBDATETIME$$

Question 23

To convert a data block to a control block,you change the Database Data Block property value to No.

Question 24

What type of variable is always available to any form?

A)public variable
B)system variable
C)global variable
D)form variable

Question 25

If working with multiple canvases in the same form,when you create a new data block,you can select the canvas name on which the block items are to appear on the Layout Wizard Canvas page.

Question 26

A form may contain either data blocks or control blocks,but not both.

Question 27

What kind of error occurs when a form is running?

A)syntax error
B)system error
C)user error
D)runtime error

Question 28

How do you reference a form item within a form trigger?

A)item_name
B):item_name
C)block_name.item_name
D):block_name.item_name

Question 29

If the error does not have an associated error handler in the ON-ERROR trigger,then the standard error message is displayed rather than a custom message.

Question 30

Error messages that are generated by the DBMS begin with the prefix ____.

A)FRM
B)ORA
C)DBMS
D)DB

Question 31

What command clears the value from the form item?

A):receiving_block.color = "";
B):receiving_block.color = '';
C):receiving_block.color.clear;
D):receiving_block.color:='';

Question 32

What view of Object Navigator should be used when creating a custom form?

A)Ownership View
B)Visual View
C)Forms View
D)Canvas View

Question 33

A ____ is a data block that you do not associate with a particular database table.

A)data form block
B)control data block
C)custom form block
D)free form block

Question 34

When a form contains multiple data blocks and multiple canvases,you must specify which canvas initially appears when the user runs the form.

Question 35

All data is shared between two canvases stored in separate form files.

Question 36

When you link a control block to a data block,use the Data Block Wizard to create a master-detail relationship between the data block and the control block.

Question 37

When you create a form with a master-detail relationship between a control block and a data block,you must manually specify the link between the blocks.

Question 38

What built-in procedure can be used to clear out form values?

A)DELETE_ITEMS
B)CLEAR_ITEMS
C)CLEAR_FORM
D)EMPTY_FORM

Question 39

Which button event is triggered when a button is pressed?

A)ON-BUTTON-PRESS
B)WHEN-BUTTON-PRESSED
C)WHEN-BUTTON
D)ON-BUTTON

Question 40

A data form block cannot be turned into a control block.

Question 41

Which of the following is an appropriate use of the MESSAGE subprogram?

A)Display a message with 300 characters
B)Ask the user a question
C)Get user confirmation
D)Tell the user that a save was successful

Question 42

Which error severity indicates an error message that identifies a condition that causes the form to operate incorrectly?

A)10
B)15
C)20
D)25

Question 43

What command moves the form focus to the item name s_id in the shipment block?

A)GO_ITEM(:s_id);
B)GO_ITEM(:shipment.s_id)
C)GO_ITEM(shipment:s_id)
D)GO_ITEM(shipment.s_id)

Question 44

What is the default value for SYSTEM.MESSAGE_LEVEL?

A)0
B)5
C)10
D)15

Question 45

What trigger event is part of the Message Handling category?

A)PRE-FORM
B)ON-ERROR
C)POST-QUERY
D)PRE-INSERT

Question 46

What property is used to limit the length of an entry in a text item?

A)Max Length
B)Maximum Length
C)Length
D)Length Limit

Question 47

The currently selected item on a form has the ____.

A)form hilight
B)insertion point
C)form focus
D)field point

Question 48

What is the maximum number of characters that can be displayed in the message line?

A)50
B)100
C)200
D)400

Question 49

What type of value is returned from an alert?

A)NUMBER
B)VARCHAR2
C)CHAR
D)NVARCHAR2

Question 50

How do you set tab order for a form?

A)arrange items alphabetically in Object Navigator
B)arrange items in desired tab order in Object Navigator
C)set Tab Order property in Property Palette for each item
D)create items in correct order

Question 51

How do you display an alert?

A)Using DISPLAY_ALERT
B)Using SHOW_ALERT
C)Using ALERT
D)Using POPUP_ALERT

Question 52

When a trigger is attached to a block,the trigger's ____ extends to all items within the block.

A)scope
B)range
C)timing
D)execution hierarchy

Question 53

When in a multiple form application,the form focus is moved to another form with the ____ command.

A)GO_ITEM
B)GO_BLOCK
C)TO_FORM
D)GO_FORM

Question 54

The ON-DELETE trigger event is an example of a(n)____ trigger.

A)Interface event
B)Block processing
C)Navigational
D)Validation

Question 55

To suppress all error messages with severity below 10,use the code: ____.

A):SYSTEM.MESSAGE_LEVEL = 10
B):SYSTEM.MESSAGE_LEVEL <= 10
C):SYSTEM.MESSAGE_LEVEL = 9
D):SYSTEM_MESSAGE_LEVEL = 11

Question 56

How do you specify that a text field should contain a right-justified number?

A)Rnumber
B)Right Number
C)Right Justify Number
D)Rt Justify Number

Question 57

Using the GO_ITEM built-in to move the form focus is an example of ____.

A)external navigation
B)internal navigation
C)program navigation
D)trigger navigation

Question 58

What message would be best to display in an alert rather than on the message line?

A)Record Saved
B)New Customer Inserted
C)Order processed
D)Are you sure you want to exit?

Question 59

What error level indicates an informative message that identifies a data entry error,such as entering an incorrect data value in a text item?

A)0
B)5
C)10
D)15

Question 60

When using the Forms Debugger,to pause program execution on a certain command,set a ____.

A)stop
B)break
C)breakpoint
D)pausepoint

Question 61

Which event do you associate an item validation trigger with?

A)WHEN-VALIDATE-ITEM
B)VALIDATE-ITEM
C)ON-EXIT
D)ON-VALIDATION

Question 62

Which of the following contains the error message for a FRM error?

A)DBMS_ERROR_CODE
B)DBMS_ERROR_TEXT
C)ERROR_CODE
D)ERROR_TEXT

Question 63

You create a command button by drawing the button on the canvas using the ____________________ tool on the tool palette.

Question 64

How do you specify tab canvas order?

A)order tab pages in Object Navigator
B)order blocks on tabs in Object Navigator
C)set Tab Order property using Property Palette
D)the tab page creation order sets order

Question 65

Which FRM- error indicates that a DBMS error occurred?

A)00000
B)23143
C)40735
D)88125

Question 66

When using Forms Debugger,a(n)____________________ is used to monitor the value of a specific variable or form item value during program execution

Question 67

Use a ____ canvas to direct a user through a sequence of steps for performing a task.

A)content
B)stacked
C)tab
D)modular

Question 68

How do you programmatically move form focus to a different canvas?

A)use the GO_CANVAS command
B)use the GO_ITEM command to move focus to an item in the canvas
C)use the GO_BLOCK command to move focus to a block in the canvas
D)use the Property Palette for the canvas to set the Focus property

Question 69

A(n)____________________ form displays the data fields from a variety of database tables,and contains programs that support organizational processes.

Question 70

A(n)____________________ variable is a variable representing a value that is always available to any form.

Question 71

The system variable ____________________ represents the current database server date.

Question 72

A (n)____________________ block is a data block that you do not associate with a particular database table.

Question 73

When using a debugger,a(n)____________________ pauses execution on a specific command.

Question 74

Trigger events that start with ____________________ will fire their associated triggers before the action.

Question 75

How do you create a tab canvas?

A)create a content canvas then a tab canvas on it
B)create a tab canvas only
C)create a stacked canvas then a tab canvas on it
D)create a base canvas then a tab canvas on it

Question 76

What is the default validation unit in Forms Builder?

A)Form
B)Block
C)Item
D)Canvas

Question 77

What determines the first canvas to be displayed in a form with multiple canvases?

A)the first created
B)the first alphabetically
C)the first canvas listed in Object Navigator
D)the canvas with the first data block listed in Object Navigator

Question 78

A(n)____________________ is an error that does not keep a program from compiling,but that generates an error while the program is running.

Question 79

What is meant by nonnavigable?

A)A user cannot place the mouse in the field
B)A user cannot edit the field
C)A user cannot use the tab key to get to the field
D)A user cannot access the form at all

Question 80

WHEN-BUTTON-PRESSED is an example of a(n)____________________ event.