Question 1

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

Accepted Answer

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

Question 2

In a master-detail form,the default value of the ____________________ property is No,so by default,Forms Builder fetches detail records immediately.

Accepted Answer

Deferred

Question 3

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

Accepted Answer

Adjust

Question 4

When a user performs a(n)____________________ event,which is any operation that causes the current record in the master block to change,the detail block values also change.

Accepted Answer

coordinati

Question 5

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?

Accepted Answer

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 
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 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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.

Accepted Answer

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

Question 15

In a master-detail form,the master block and the detail block are ____________________,which means that the master record and the detail record are associated by a relationship.

Accepted Answer

The answer of In a master-detail form,the master block and...

Question 16

The ____________________ event would be associated with a form trigger that checks to make sure the user has entered a search condition.

Accepted Answer

The answer of The ____________________ event would be associated with...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

When counting ____________________,the DBMS determines how many records the query will retrieve,but does not yet actually retrieve the records.

Accepted Answer

The answer of When counting ____________________,the DBMS determines how many...

Question 19

What are the two ways to display an image on a form?

Accepted Answer

There are two ways to display a graphic

Question 20

When the Delete Record Behavior property value is set to Non Isolated,Forms Builder creates an _________________________ trigger,which fires when the user attempts to delete the master record.

Accepted Answer

ON-CHECK-D

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

In a master-detail form,the default value of the ____________________ property is No,so by default,Forms Builder fetches detail records immediately.

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

When a user performs a(n)____________________ event,which is any operation that causes the current record in the master block to change,the detail block values also change.

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?

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

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

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

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

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

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

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.

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

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.

In a master-detail form,the master block and the detail block are ____________________,which means that the master record and the detail record are associated by a relationship.

The ____________________ event would be associated with a form trigger that checks to make sure the user has entered a search condition.

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

When counting ____________________,the DBMS determines how many records the query will retrieve,but does not yet actually retrieve the records.

What are the two ways to display an image on a form?

When the Delete Record Behavior property value is set to Non Isolated,Forms Builder creates an _________________________ trigger,which fires when the user attempts to delete the master record.

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

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

In a master-detail form,the default value of the ____________________ property is No,so by default,Forms Builder fetches detail records immediately.

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

When a user performs a(n)____________________ event,which is any operation that causes the current record in the master block to change,the detail block values also change.

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?

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

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

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

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

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

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

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.

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

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.

In a master-detail form,the master block and the detail block are ____________________,which means that the master record and the detail record are associated by a relationship.

The ____________________ event would be associated with a form trigger that checks to make sure the user has entered a search condition.

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

When counting ____________________,the DBMS determines how many records the query will retrieve,but does not yet actually retrieve the records.

What are the two ways to display an image on a form?

When the Delete Record Behavior property value is set to Non Isolated,Forms Builder creates an _________________________ trigger,which fires when the user attempts to delete the master record.

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