Question 1

A static list item can dynamically retrieve database data values.

Accepted Answer

A) True 
 B)False

Question 2

The ____ is used to create Boilerplate text.

Accepted Answer

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

Question 3

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.

Accepted Answer

The answer of To create a display item,you select the...

Question 4

A(n)____________________ is a drop-down list that the user opens when needed.

Accepted Answer

The answer of A(n)____________________ is a drop-down list that the...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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)____________________.

Accepted Answer

The answer of In the code for the PL/SQL formula,you...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

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

Question 9

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 ____.

Accepted Answer

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

Question 10

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 ____.

Accepted Answer

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

Question 11

Forms Builder supports five types of static list.

Accepted Answer

A) True 
 B)False

Question 12

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.

Accepted Answer

A) True 
 B)False

Question 13

What are some approaches for improving data retrieval performance in forms?

Accepted Answer

Create indexes on fields used in search

Question 14

If an LOV has been configured not to display records before the user performs a search,when the LOV first opens,it displays only the ____________________ field,which allows the user to enter a search condition before retrieving any LOV records.

Accepted Answer

The answer of If an LOV has been configured not...

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The Let the user filter records before displaying them check box specifies the LOV Filter ____________________ property.

Accepted Answer

The answer of The Let the user filter records before...

A static list item can dynamically retrieve database data values.

The ____ is used to create Boilerplate text.

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.

A(n)____________________ is a drop-down list that the user opens when needed.

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

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)____________________.

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

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.

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 ____.

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 ____.

Forms Builder supports five types of static list.

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.

What are some approaches for improving data retrieval performance in forms?

If an LOV has been configured not to display records before the user performs a search,when the LOV first opens,it displays only the ____________________ field,which allows the user to enter a search condition before retrieving any LOV records.

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

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

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

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

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

The Let the user filter records before displaying them check box specifies the LOV Filter ____________________ property.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Introduction to Oracle 10g Database Administration

Filters

Exam 10: Advanced Forms Builder Topics

A static list item can dynamically retrieve database data values.

The ____ is used to create Boilerplate text.

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.

A(n)____________________ is a drop-down list that the user opens when needed.

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

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)____________________.

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

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.

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 ____.

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 ____.

Forms Builder supports five types of static list.

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.

What are some approaches for improving data retrieval performance in forms?

If an LOV has been configured not to display records before the user performs a search,when the LOV first opens,it displays only the ____________________ field,which allows the user to enter a search condition before retrieving any LOV records.

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

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

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

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

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

The Let the user filter records before displaying them check box specifies the LOV Filter ____________________ property.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Introduction to Oracle 10g Database Administration

Filters