Question 1

How are format masks used in Reports Builder? To which data types can they be applied and how are they applied?

Accepted Answer

In Reports Builder,you can specify forma

Question 2

A(n)____________________ is a structure that uses some criteria to limit the number of records that a report query retrieves.

Accepted Answer

The answer of A(n)____________________ is a structure that uses some...

Question 3

Data from only one database table can be used in a report.

Accepted Answer

A) True 
 B)False

Question 4

A header is required for all reports.

Accepted Answer

A) True 
 B)False

Question 5

When is it best to use flex mode?

Accepted Answer

A) To make a frame longer 
B) To make a frame wider 
C) When confine mode is off 
D) When confine mode is on 
A) To make a frame longer 
B) To make a frame wider 
C) When confine mode is off 
D) When confine mode is on

Question 6

A report query can be specified manually in the Data Model window.

Accepted Answer

A) True 
 B)False

Question 7

How do you verify which frame is selected?

Accepted Answer

A) view frame name in Property Inspector 
B) view status line for name 
C) view ToolTip for frame name 
D) view Frame Property menu option 
A) view frame name in Property Inspector 
B) view status line for name 
C) view ToolTip for frame name 
D) view Frame Property menu option

Question 8

A ____ is a series of Java commands that retrieve and format data values in one of the report styles that can appear in a browser window.

Accepted Answer

A) report command 
B) report block 
C) report script 
D) report wizard 
A) report command 
B) report block 
C) report script 
D) report wizard

Question 9

Boilerplate text and images are stored in the report ____.

Accepted Answer

A) body 
B) header 
C) margin 
D) main section 
A) body 
B) header 
C) margin 
D) main section

Question 10

A simple tabular report has a single record group,and a master-detail report has multiple record groups.

Accepted Answer

A) True 
 B)False

Question 11

Repeating frames will shrink or stretch depending on the data they contain.

Accepted Answer

A) True 
 B)False

Question 12

Which system property indicates the type of device to which to send the report output,such as screen,file,e-mail,or printer?

Accepted Answer

A) COPIES 
B) DESMODE 
C) DESNAME 
D) DESTYPE 
A) COPIES 
B) DESMODE 
C) DESNAME 
D) DESTYPE

Question 13

Which property in the user parameter Property Inspector is used to configure the list of parameter choices?

Accepted Answer

A) Parameter List 
B) Parameter Value 
C) List of Values 
D) Parameter Choices 
A) Parameter List 
B) Parameter Value 
C) List of Values 
D) Parameter Choices

Question 14

How is a custom template registered as a predefined template?

Accepted Answer

A) using the Options menu in Reports Builder 
B) using the user preferences file 
C) using the Set Template button on the Reports Builder toolbar 
D) by selecting the Save as Predefined template menu option 
A) using the Options menu in Reports Builder 
B) using the user preferences file 
C) using the Set Template button on the Reports Builder toolbar 
D) by selecting the Save as Predefined template menu option

Question 15

The ____________________ process queries the database when the user requests the report,and generates a dynamic Web page that displays the current database data.

Accepted Answer

The answer of The ____________________ process queries the database when...

Question 16

In a master-detail report,the master side is also known as the child.

Accepted Answer

A) True 
 B)False

Question 17

How is a repeating frame indicated visually in Paper Layout view?

Accepted Answer

A) with a * 
B) with a >> 
C) with a down-arrow 
D) with an up-arrow 
A) with a * 
B) with a >> 
C) with a down-arrow 
D) with an up-arrow

Question 18

The only way to apply a custom template to a report is to use the Template file specification button on the Report Wizard Template page.

Accepted Answer

A) True 
 B)False

Question 19

A(n)____________________ defines the font sizes and styles for a reports title,column headings,and data values.

Accepted Answer

custom tem

Question 20

What report style can only be printed on paper,not displayed on the web?

Accepted Answer

A) tabular 
B) group above 
C) matrix 
D) form 
A) tabular 
B) group above 
C) matrix 
D) form

How are format masks used in Reports Builder? To which data types can they be applied and how are they applied?

A(n)____________________ is a structure that uses some criteria to limit the number of records that a report query retrieves.

Data from only one database table can be used in a report.

A header is required for all reports.

When is it best to use flex mode?

A report query can be specified manually in the Data Model window.

How do you verify which frame is selected?

A ____ is a series of Java commands that retrieve and format data values in one of the report styles that can appear in a browser window.

Boilerplate text and images are stored in the report ____.

A simple tabular report has a single record group,and a master-detail report has multiple record groups.

Repeating frames will shrink or stretch depending on the data they contain.

Which system property indicates the type of device to which to send the report output,such as screen,file,e-mail,or printer?

Which property in the user parameter Property Inspector is used to configure the list of parameter choices?

How is a custom template registered as a predefined template?

The ____________________ process queries the database when the user requests the report,and generates a dynamic Web page that displays the current database data.

In a master-detail report,the master side is also known as the child.

How is a repeating frame indicated visually in Paper Layout view?

The only way to apply a custom template to a report is to use the Template file specification button on the Report Wizard Template page.

A(n)____________________ defines the font sizes and styles for a reports title,column headings,and data values.

What report style can only be printed on paper,not displayed on the web?

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

How are format masks used in Reports Builder? To which data types can they be applied and how are they applied?

A(n)____________________ is a structure that uses some criteria to limit the number of records that a report query retrieves.

Data from only one database table can be used in a report.

A header is required for all reports.

When is it best to use flex mode?

A report query can be specified manually in the Data Model window.

How do you verify which frame is selected?

A ____ is a series of Java commands that retrieve and format data values in one of the report styles that can appear in a browser window.

Boilerplate text and images are stored in the report ____.

A simple tabular report has a single record group,and a master-detail report has multiple record groups.

Repeating frames will shrink or stretch depending on the data they contain.

Which system property indicates the type of device to which to send the report output,such as screen,file,e-mail,or printer?

Which property in the user parameter Property Inspector is used to configure the list of parameter choices?

How is a custom template registered as a predefined template?

The ____________________ process queries the database when the user requests the report,and generates a dynamic Web page that displays the current database data.

In a master-detail report,the master side is also known as the child.

How is a repeating frame indicated visually in Paper Layout view?

The only way to apply a custom template to a report is to use the Template file specification button on the Report Wizard Template page.

A(n)____________________ defines the font sizes and styles for a reports title,column headings,and data values.

What report style can only be printed on paper,not displayed on the web?

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