Deck 5: Introduction to Forms Builder

Question 1

When running a form,the Forms Builder system translates the design specification into a Java applet.

Answer 1

True

Question 2

Boilerplate objects are entry fields such as text boxes and radio buttons.

Answer 2

False

Question 3

When a form is in Normal mode you can enter a search expression in the form fields and retrieve matching records.

Answer 3

False

Question 4

A data block form is a form associated with only one database table.

Question 5

In the Object Navigator tree,if an object node is a plus sign (+),it means that the object has lower-level objects that you can view by expanding the node.

Question 6

All forms created with Forms Builder are displayed in the Forms Services window.

Question 7

A content canvas fills the entire window.

Question 8

A form representing a database view is exactly the same as one representing a database table.

Question 9

You can only create data blocks for tables in your own schema using the Data Block Wizard.

Question 10

Once a window has been created the title cannot be changed.

Question 11

Forms Builder displays forms in a browser using a Java applet.

Question 12

The most common block items are radio buttons.

Question 13

The extension .fmb indicates a compiled form.

Question 14

In the Object Navigator,Ownership View displays only one hierarchical relationship: it shows which items are in a specific data block.

Question 15

When you delete a record using the Remove Record button the record is deleted from the database immediately.

Question 16

Forms Builder wizards can only be used for initial setup of data blocks,layout,etc.All modifications must be done manually.

Question 17

Web servers store the files that people can access via the Internet using a browser.

Question 18

When you use the Data Block Wizard to add content to a form you are asked to name each item.

Question 19

A data block form can only display a single record at a time.

Question 20

When you create a data block,the system automatically generates the text items and labels for data fields in that table and provides the code for inserting,modifying,deleting,and viewing data records.

Question 21

You can create data block forms that display data from multiple database tables that have
master-detail relationships.

Question 22

In the PL/SQL Editor the only way to tell the compilation status of a program is to save it and view the resulting error message if uncompiled.

Question 23

It is considered a bad practice to compile each trigger just after you enter the source code

Question 24

A ____ Web page always displays the same information.

A)static
B)dynamic
C)fixed
D)normal

Question 25

To write a trigger,you must specify the triggers object,the event that starts the trigger,and the code that executes when the trigger fires.

Question 26

How do you view more information about an error?

A)select Display Error from the Help menu
B)hit Error Info button on toolbar
C)select Error from File menu
D)view information in message line when cursor is in error field

Question 27

A ____ appears at the outside of every Forms Builder form.

A)project logo
B)Forms Services Window
C)Forms Builder form
D)Form menu

Question 28

A ____ is a form that is associated with one or more specific database tables.

A)table form
B)view form
C)data block form
D)relational form

Question 29

All form objects have the same properties on the Property Palette.

Question 30

Netscape Navigator and Internet Explorer are two popular ____.

A)Web servers
B)Web browsers
C)user interfaces
D)programming languages

Question 31

A Java ____ is a self-contained Java program that runs in a Web browser's generic Java runtime environment.

A)web program
B)script
C)servlet
D)applet

Question 32

The user opens a LOV display by placing the insertion point in the text item associated with the LOV and pressing CTRL+L.

Question 33

What is the purpose of the message line?

A)display status messages
B)display user messages
C)display database login status
D)display name of current form

Question 34

Every form object has a Property Palette.

Question 35

How do you retrieve all database records using a form?

A)In Enter Query mode execute query without entering any search values in form
B)Use Retrieve All Records button
C)In Normal Mode,press Enter Query button
D)In Enter Query mode,type a * in any one of the search fields and execute query

Question 36

How do you exit Enter Query Mode?

A)Use Cancel Query button
B)Click Normal Mode button
C)Select Normal Mode from menu
D)Reopen form

Question 37

If you enter a value in a form field that has an incorrect data type (a letter in a NUMBER field),where is the error caught?

A)in the database
B)in the form
C)in the form trigger
D)in the error checker

Question 38

A format mask can be used to modify the way a text value,such as a telephone number,is displayed.

Question 39

Errors often occur when a SQL command within the PL/SQL trigger code has an error.

Question 40

When you create an LOV,a button to open it is automatically placed on the form.

Question 41

The ____ text item property specifies that the item can appear in the form,but cannot be used for an insert or update operation.

A)Query Only
B)Queryable
C)No Update
D)Query Enabled

Question 42

Which view of Object Navigator is useful for quickly accessing specific objects without having to open all of the higher-level objects in which the target object resides?

A)Ownership View
B)Visual View
C)Layout View
D)Graphical View

Question 43

If a form displayed a customer and a list of customer orders,what would be the type of block containing the customer orders?

A)master block
B)detail block
C)foreign block
D)linked block

Question 44

The ____ text item property specifies whether the user can navigate to the item using the Tab key or mouse pointer.

A)Tabbable
B)Enabled
C)View
D)Read-only

Question 45

What is the name for a label that describes the data value that appears in the associated text field,such as Order ID or Payment Method?

A)field label
B)prompt
C)item
D)column label

Question 46

What is the meaning of a minus sign (-)next to an object in Object Navigator?

A)the object has not been compiled
B)the object has been expanded
C)the object does not have any lower-level objects
D)the object is unsaved

Question 47

The ____ component of Forms Builder is used to modify object properties.

A)Property Sheet
B)Property Editor
C)Property Palette
D)Property Form

Question 48

The ____ of the Data Block Wizard is used to specify whether the data comes from a table or a view.

A)Table page
B)Welcome page
C)Type page
D)Name page

Question 49

The ____ enables different related canvases to appear on a single tab page.

A)content canvas
B)stacked canvas
C)toolbar canvas
D)tab canvas

Question 50

You use a Property Palette in ____ mode to modify one or more properties of a group of objects so that all objects in the group have the same value or values.

A)intersection
B)multiple
C)locked
D)joined

Question 51

The ____ contains multiple canvases that are stacked on top of one another and that you can display or hide to change the appearance of the canvas as needed.

A)content canvas
B)stacked canvas
C)toolbar canvas
D)tab canvas

Question 52

In a(n)____ layout,multiple records appear in a table on the form.

A)matrix
B)field-style
C)index
D)tabular-style

Question 53

How must two tables be related to be displayed in the same form?

A)primary key
B)many-many
C)master-detail
D)linked

Question 54

The ____ of the Data Block Wizard allows you to chose the table or view columns that will appear on the form

A)Table page
B)Column page
C)Field page
D)Type page

Question 55

What is the name for form objects that do not contribute directly to the form's functionality,but enhance its appearance?

A)static images
B)boilerplate objects
C)fixed items
D)labels

Question 56

What is the default name of the very first form you create in Forms Builder?

A)MODULEA
B)MODULE1
C)FORMA
D)FORM1

Question 57

In Object Navigator,____ shows how form objects contain other objects: a form contains windows,a window contains canvases,and a canvas contains data blocks.

A)Ownership View
B)Visual View
C)Layout View
D)Graphical View

Question 58

Which mode should the Update Layout property of a frame be in to preserve changes made in the Layout Editor?

A)Manually
B)Locked
C)Automatically
D)Never

Question 59

What Forms Builder object holds graphical user interface objects such as buttons and text fields?

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

Question 60

You can visually tell when a wizard is in ____ mode because all of the wizard pages appear at once,rather than one at a time with a Next button to move through them in the wizard window,and tabs appear at the top of the window.

A)edit
B)update
C)reentrant
D)normal

Question 61

Why it a good idea to use a LOV to edit a foreign key value?

A)minimize user errors
B)faster
C)takes less space on form
D)to avoid duplicates

Question 62

What should you do before compiling a form trigger?

A)make sure you are connected to the database
B)close all other Forms Builder windows
C)save the trigger
D)save the form

Question 63

What is another name for a format mask?

A)formatter
B)format model
C)format type
D)format node

Question 64

When you click the Save button on the Forms Services toolbar,a ____ containing a SQL INSERT command executes.

A)database trigger
B)form trigger
C)command
D)query

Question 65

The ____________________ provides a graphical display of the form canvas that you can use to draw and position form items,and to add boilerplate objects such as labels,titles,and graphic images.

Question 66

In a(n)____________________ Web page,the content varies based on user inputs or data retrieved from external sources.

Question 67

When a form is in ____________________ mode,you can view data records,sequentially step through the records,and change data values.

Question 68

How do you refer to a form item in a PL/SQL block?

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

Question 69

In a data block form,____________________ display text data values in text fields.

Question 70

When a form is in ____________________ mode,you can enter a search expression in one of the form fields,and then retrieve the associated records.

Question 71

To use a wizard to modify an existing data block or layout,you must start the wizard in ____________________ mode.

Question 72

The Object Navigator provides two views: Ownership View and ____________________.

Question 73

The ____________________ property specifies the maximum number of characters that can be entered into a text item.

Question 74

What is the most likely cause when you receive the error "message identifier DUAL (or some other table name used in the trigger)must be declared." when compiling a form trigger?

A)table does not exist
B)not connected to database
C)table name is invalid
D)table is not declared properly

Question 75

The property that is used to convert the value of a text item to upper or lower-case letters is called ____________________.

Question 76

Every form object has a(n____________________,which is a window that displays a list of object properties and their associated values.

Question 77

What item type is used for fields that are editable using radio buttons?

A)radio button
B)radio group
C)button group
D)radio button type

Question 78

What command is used to open an LOV when writing a form trigger?

A)OPEN_LOV
B)DISPLAY_LOV
C)LAUNCH_LIST
D)LIST_VALUES

Question 79

What is the difference between a record group and a database table?

A)record group only has 1000 records
B)record group only has 1 field
C)record group only exists while form is running
D)record group is static

Question 80

The ____ property allows you to specify how the check box appears when the form first opens,when a user creates a new blank record,or when the value for the check box field is a different value than the ones for when the check box is checked or unchecked.

A)Default Value
B)Check Box Mapping of Other Values
C)Value when Checked
D)Value when Unchecked