Question 1

What type of parameter allows the user to select values that specify the data that the report displays?

Accepted Answer

A) System 
B) User 
C) Variable 
D) Query 
A) System 
B) User 
C) Variable 
D) Query

Question 2

A field must have the same horizontal and vertical elasticity.

Accepted Answer

A) True 
 B)False

Question 3

When previewing a form as a web page using the Run Web Layout button,all formatting changes made in the Paper Design window will be displayed.

Accepted Answer

A) True 
 B)False

Question 4

What is the extension for report builder design files?

Accepted Answer

A) frm 
B) rdf 
C) rbf 
D) fbr 
A) frm 
B) rdf 
C) rbf 
D) fbr

Question 5

Where in the Report Wizard are summary columns created?

Accepted Answer

A) Data page 
B) Summary page 
C) Totals page 
D) Columns page 
A) Data page 
B) Summary page 
C) Totals page 
D) Columns page

Question 6

The ____________________ file is a text file that specifies configuration information for a specific user for most of the Developer utilities,including Forms Builder and Reports Builder.

Accepted Answer

The answer of The ____________________ file is a text file...

Question 7

Field ____ determines whether it expands and contracts depending on its data value.

Accepted Answer

A) flex 
B) confine 
C) size 
D) elasticity 
A) flex 
B) confine 
C) size 
D) elasticity

Question 8

What is the name of the user preferences file used by Reports Builder?

Accepted Answer

A) cauprefs.ora 
B) upref.txt 
C) preferences.xml 
D) userprefs.xml 
A) cauprefs.ora 
B) upref.txt 
C) preferences.xml 
D) userprefs.xml

Question 9

What type of column displays data calculated by a PL/SQL function?

Accepted Answer

A) function 
B) formula 
C) summary 
D) calculated 
A) function 
B) formula 
C) summary 
D) calculated

Question 10

Describe the different options for viewing a Reports Builder report as a Web page.

Accepted Answer

When you click the Run Web Layout button

Question 11

A frame can be used to set properties for a group of objects at the same time.

Accepted Answer

A) True 
 B)False

Question 12

How can you modify a report's query?

Accepted Answer

A) Select SQLQuery from File menu 
B) Double click query in Data Model window 
C) Use SQLQuery toolbar button in Paper Layout view 
D) Right-click query in Design view 
A) Select SQLQuery from File menu 
B) Double click query in Data Model window 
C) Use SQLQuery toolbar button in Paper Layout view 
D) Right-click query in Design view

Question 13

How can you limit the number of records that appear in a report? Describe the different ways in which you can limit the number of records.

Accepted Answer

Sometimes you need to limit the data tha

Question 14

What type of column could be used to display the average grade for a class?

Accepted Answer

A) summary 
B) formula 
C) calculation 
D) average 
A) summary 
B) formula 
C) calculation 
D) average

Question 15

The ____________________ is a window that displays properties and associated values for report objects,and is similar to the Forms Builder Property Palette.

Accepted Answer

The answer of The ____________________ is a window that displays...

Question 16

When you specify a report SQL query that contains master-detail relationships,the Report Wizard displays the ____________________ page,which allows you to define the master and detail groups.

Accepted Answer

The answer of When you specify a report SQL query...

Question 17

What is the best way to navigate to frames that are hidden under other frames?

Accepted Answer

A) using tab key 
B) using arrow key 
C) using Select Parent Frame button 
D) using Select Frame menu option 
A) using tab key 
B) using arrow key 
C) using Select Parent Frame button 
D) using Select Frame menu option

Question 18

How does Reports Builder prevent the developer from moving an object out of its enclosing frame?

Accepted Answer

A) If confine mode is enabled it is impossible 
B) It is never possible 
C) A red arrow appears 
D) A beep sounds 
A) If confine mode is enabled it is impossible 
B) It is never possible 
C) A red arrow appears 
D) A beep sounds

Question 19

The ____ tool is used to set background color.

Accepted Answer

A) background color 
B) color 
C) fill color 
D) set color 
A) background color 
B) color 
C) fill color 
D) set color

Question 20

If you modify the report in the Paper Design window,then open the Report Wizard in reentrant mode and change the report properties,you lose the changes you made in the Paper Design window.

Accepted Answer

A) True 
 B)False

What type of parameter allows the user to select values that specify the data that the report displays?

A field must have the same horizontal and vertical elasticity.

When previewing a form as a web page using the Run Web Layout button,all formatting changes made in the Paper Design window will be displayed.

What is the extension for report builder design files?

Where in the Report Wizard are summary columns created?

The ____________________ file is a text file that specifies configuration information for a specific user for most of the Developer utilities,including Forms Builder and Reports Builder.

Field ____ determines whether it expands and contracts depending on its data value.

What is the name of the user preferences file used by Reports Builder?

What type of column displays data calculated by a PL/SQL function?

Describe the different options for viewing a Reports Builder report as a Web page.

A frame can be used to set properties for a group of objects at the same time.

How can you modify a report's query?

How can you limit the number of records that appear in a report? Describe the different ways in which you can limit the number of records.

What type of column could be used to display the average grade for a class?

The ____________________ is a window that displays properties and associated values for report objects,and is similar to the Forms Builder Property Palette.

When you specify a report SQL query that contains master-detail relationships,the Report Wizard displays the ____________________ page,which allows you to define the master and detail groups.

What is the best way to navigate to frames that are hidden under other frames?

How does Reports Builder prevent the developer from moving an object out of its enclosing frame?

The ____ tool is used to set background color.

If you modify the report in the Paper Design window,then open the Report Wizard in reentrant mode and change the report properties,you lose the changes you made in the Paper Design window.

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 an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters

Exam 7: Creating Database Reports

What type of parameter allows the user to select values that specify the data that the report displays?

A field must have the same horizontal and vertical elasticity.

When previewing a form as a web page using the Run Web Layout button,all formatting changes made in the Paper Design window will be displayed.

What is the extension for report builder design files?

Where in the Report Wizard are summary columns created?

The ____________________ file is a text file that specifies configuration information for a specific user for most of the Developer utilities,including Forms Builder and Reports Builder.

Field ____ determines whether it expands and contracts depending on its data value.

What is the name of the user preferences file used by Reports Builder?

What type of column displays data calculated by a PL/SQL function?

Describe the different options for viewing a Reports Builder report as a Web page.

A frame can be used to set properties for a group of objects at the same time.

How can you modify a report's query?

How can you limit the number of records that appear in a report? Describe the different ways in which you can limit the number of records.

What type of column could be used to display the average grade for a class?

The ____________________ is a window that displays properties and associated values for report objects,and is similar to the Forms Builder Property Palette.

When you specify a report SQL query that contains master-detail relationships,the Report Wizard displays the ____________________ page,which allows you to define the master and detail groups.

What is the best way to navigate to frames that are hidden under other frames?

How does Reports Builder prevent the developer from moving an object out of its enclosing frame?

The ____ tool is used to set background color.

If you modify the report in the Paper Design window,then open the Report Wizard in reentrant mode and change the report properties,you lose the changes you made in the Paper Design window.

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 an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters