Question 1

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.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of To change the order of boilerplate objects,you...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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.

Accepted Answer

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

Question 14

The ____ list item type always displays the current selection.

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 15

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

Accepted Answer

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

Question 16

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.

Accepted Answer

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

Question 17

The ____ trigger coordinates the master and detail blocks.

Accepted Answer

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

Question 18

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.

Accepted Answer

A) True 
 B)False

Question 19

During the ____________________ phase of query processing,the DBMS prepares to retrieve the requested records.

Accepted Answer

The answer of During the ____________________ phase of query processing,the...

Question 20

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

Accepted Answer

A) True 
 B)False

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.

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

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

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

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

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

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

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

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

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

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

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

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.

The ____ list item type always displays the current selection.

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

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.

The ____ trigger coordinates the master and detail blocks.

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.

During the ____________________ phase of query processing,the DBMS prepares to retrieve the requested records.

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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.

The ____ list item type always displays the current selection.

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

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.

The ____ trigger coordinates the master and detail blocks.

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.

During the ____________________ phase of query processing,the DBMS prepares to retrieve the requested records.

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

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