Question 1

When you enable ____________________,an enclosing frame automatically becomes larger when you move an enclosed object beyond the enclosing frame's boundary.

Accepted Answer

flex mode

Question 2

When creating a master-detail report you must use either group left,or group above as the style.

Accepted Answer

A) True 
 B)False  True

Question 3

You can create ____________________,which display values that PL/SQL functions calculate using report data field values as input parameters.

Accepted Answer

formula columns

Question 4

A report ____________________ is a set of records that represent the data fields that a query retrieves.

Accepted Answer

The answer of A report ____________________ is a set of...

Question 5

What report style is used to display a master-detail report?

Accepted Answer

A) mailing label 
B) form letter 
C) form 
D) group above 
A) mailing label 
B) form letter 
C) form 
D) group above

Question 6

The report footer section appears at the end of the report.

Accepted Answer

A) True 
 B)False

Question 7

In the Object Navigator,click the ____________________ button to generate and display the report as a Web page without any formatting modifications.

Accepted Answer

The answer of In the Object Navigator,click the ____________________ button...

Question 8

The Column to Column link type links two identical columns that do not necessarily have a foreign key relationship

Accepted Answer

A) True 
 B)False

Question 9

A custom template can define text and background colors,and boilerplate objects,such as graphic images.

Accepted Answer

A) True 
 B)False

Question 10

What is the preface for all web report tags generated by the Oracle Reports Server?

Accepted Answer

A) wr: 
B) rw: 
C) web: 
D) report: 
A) wr: 
B) rw: 
C) web: 
D) report:

Question 11

How many record groups does a master-detail report with three levels have?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4 
A) 1 
B) 2 
C) 3 
D) 4

Question 12

The DECIMAL parameter is an example of a user parameter.

Accepted Answer

A) True 
 B)False

Question 13

When creating a master-detail report it is possible for all fields to belong to the Level 1 group.

Accepted Answer

A) True 
 B)False

Question 14

If a record group is named G_LOC_ID what is the default name for its group frame?

Accepted Answer

A) G_LOV_ID_FRG 
B) M_G_LOC_ID_GRPFR 
C) M_LOC_ID_GPFR 
D) M_LOC_ID_GRP_FR 
A) G_LOV_ID_FRG 
B) M_G_LOC_ID_GRPFR 
C) M_LOC_ID_GPFR 
D) M_LOC_ID_GRP_FR

Question 15

The form,form letter,and mailing label report styles can only print on paper.

Accepted Answer

A) True 
 B)False

Question 16

A(n)____________________ frame encloses all of the column headings for a record group.

Accepted Answer

The answer of A(n)____________________ frame encloses all of the column...

Question 17

The ____________________ report section usually has multiple pages,and contains the report data and computations.

Accepted Answer

The answer of The ____________________ report section usually has multiple...

Question 18

How do you create a master-detail relationship manually?

Accepted Answer

A) using the SQL query 
B) using a data link 
C) using the Master-Detail toolbar button 
D) using the Create Level menu option 
A) using the SQL query 
B) using a data link 
C) using the Master-Detail toolbar button 
D) using the Create Level menu option

Question 19

Reports created with Reports Builder can be saved as Word documents (.doc).

Accepted Answer

A) True 
 B)False

Question 20

____________________ perform summary functions (such as SUM,AVG,or MAX)on report data fields.

Accepted Answer

The answer of ____________________ perform summary functions (such as SUM,AVG,or...

When you enable ____________________,an enclosing frame automatically becomes larger when you move an enclosed object beyond the enclosing frame's boundary.

When creating a master-detail report you must use either group left,or group above as the style.

You can create ____________________,which display values that PL/SQL functions calculate using report data field values as input parameters.

A report ____________________ is a set of records that represent the data fields that a query retrieves.

What report style is used to display a master-detail report?

The report footer section appears at the end of the report.

In the Object Navigator,click the ____________________ button to generate and display the report as a Web page without any formatting modifications.

The Column to Column link type links two identical columns that do not necessarily have a foreign key relationship

A custom template can define text and background colors,and boilerplate objects,such as graphic images.

What is the preface for all web report tags generated by the Oracle Reports Server?

How many record groups does a master-detail report with three levels have?

The DECIMAL parameter is an example of a user parameter.

When creating a master-detail report it is possible for all fields to belong to the Level 1 group.

If a record group is named G_LOC_ID what is the default name for its group frame?

The form,form letter,and mailing label report styles can only print on paper.

A(n)____________________ frame encloses all of the column headings for a record group.

The ____________________ report section usually has multiple pages,and contains the report data and computations.

How do you create a master-detail relationship manually?

Reports created with Reports Builder can be saved as Word documents (.doc).

____________________ perform summary functions (such as SUM,AVG,or MAX)on report data fields.

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

When you enable ____________________,an enclosing frame automatically becomes larger when you move an enclosed object beyond the enclosing frame's boundary.

When creating a master-detail report you must use either group left,or group above as the style.

You can create ____________________,which display values that PL/SQL functions calculate using report data field values as input parameters.

A report ____________________ is a set of records that represent the data fields that a query retrieves.

What report style is used to display a master-detail report?

The report footer section appears at the end of the report.

In the Object Navigator,click the ____________________ button to generate and display the report as a Web page without any formatting modifications.

The Column to Column link type links two identical columns that do not necessarily have a foreign key relationship

A custom template can define text and background colors,and boilerplate objects,such as graphic images.

What is the preface for all web report tags generated by the Oracle Reports Server?

How many record groups does a master-detail report with three levels have?

The DECIMAL parameter is an example of a user parameter.

When creating a master-detail report it is possible for all fields to belong to the Level 1 group.

If a record group is named G_LOC_ID what is the default name for its group frame?

The form,form letter,and mailing label report styles can only print on paper.

A(n)____________________ frame encloses all of the column headings for a record group.

The ____________________ report section usually has multiple pages,and contains the report data and computations.

How do you create a master-detail relationship manually?

Reports created with Reports Builder can be saved as Word documents (.doc).

____________________ perform summary functions (such as SUM,AVG,or MAX)on report data fields.

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