Deck 7: Creating Database Reports

Question 1

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

Answer 1

False

Question 2

The Data Model in a master-detail report is more complex than the Data Model for a single-table report.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

The format mask property allows you to choose from a list of predefined format masks,or enter a customized format mask.

Question 8

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

Question 9

A report query can only be specified using the Report Wizard.

Question 10

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

Question 11

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.

Question 12

A header is required for all reports.

Question 13

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

Question 14

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.

Question 15

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.

Question 16

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

Question 17

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

Question 18

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

Question 19

Reports Builder can be used to create a form letter.

Question 20

The area of a form on which report data appears is called the margin.

Question 21

The Page Break property is used to make report page breaks appear as desired.

Question 22

In the user preferences file,what item is used to set the file name of a custom template for tabular reports?

A)Reports.Tabular_Template_File
B)Reports.Template_File_Name
C)Reports.Tabular_File_Name
D)Reports.File_Template_Tabular

Question 23

How is a custom template registered as a predefined template?

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 24

In which area of a report does the title appear?

A)margin
B)header
C)body
D)footer

Question 25

A field must have the same horizontal and vertical elasticity.

Question 26

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

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

Question 27

The ____ tool is used to set background color.

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

Question 28

The DECIMAL parameter is an example of a user parameter.

Question 29

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

Question 30

To select frames in a master-detail report it is easiest to use the Select Parent Frame button.

Question 31

What is the extension for report builder design files?

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

Question 32

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

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

Question 33

Flex mode is enabled by default.

Question 34

A summary column can only be added manually on the Paper Design window.

Question 35

A(n)____ column can be formatted using a format mask.

A)INTERVAL
B)CHAR
C)VARCHAR2
D)NUMBER

Question 36

Reports can only display images from the file system.

Question 37

A data link can be created in the Data Model window.

Question 38

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

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

Question 39

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

Question 40

Boilerplate text and images are stored in the report ____.

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

Question 41

What is the term for a field with different horizontal and vertical elasticity?

A)mixed
B)variable
C)expand
D)shared

Question 42

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

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

Question 43

The ____ allows the user to specify values for system and user parameters.

A)parameter menu
B)parameter toolbar button
C)parameter form
D)parameter list

Question 44

How do you verify which frame is selected?

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 45

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

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

Question 46

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

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

Question 47

Repeating frames have ____,which means that they shrink or stretch vertically depending on how many data records appear in the report.

A)elasticity
B)flex
C)constraint
D)variable sizing

Question 48

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

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

Question 49

How can you modify a report's query?

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 50

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

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

Question 51

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

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

Question 52

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

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

Question 53

When is it best to use flex mode?

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 54

What type of Column Type does a value retrieved from the database have?

A)Database - Scalar
B)Formula
C)Summary
D)Direct

Question 55

What is used to group related objects on a report?

A)group
B)frame
C)level
D)box

Question 56

How do you create a thumbnail image for a template to appear in the Predefined templates list?

A)place a screen-shot .bmp file in the templates directory,thumbnail subdirectory
B)save the template as a thumbnail using the File menu
C)after creating the template,use the Reports Builder Capture Thumbnail tool to create
D)create the thumbnail as a bmp file and store in the templates directory

Question 57

Within the painting region,the Paper Layout window displays ____ that correspond to the record group columns in the report Data Model.

A)layout fields
B)group frames
C)group items
D)objects

Question 58

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

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

Question 59

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

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

Question 60

The ____ specifies how Reports Builder internally references the parameter.

A)parameter object name
B)system name
C)query key
D)parameter value

Question 61

How are images to be used in reports stored in the database?

A)the image name is stored,image is on the file system
B)in a LOB field
C)a pointer to the image
D)operating system name for image is stored

Question 62

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

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

Question 63

The ____________________ window is the default editing environment and provides an environment for refining the appearance of reports,and shows how the report will appear on paper.

Question 64

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

Question 65

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.

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

Question 66

How would you reference the column named credits in a formula function?

A)credits
B)credits
C):credits
D)#credits

Question 67

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

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

Question 68

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

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

Question 69

How do you create a master-detail relationship manually?

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 70

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.

Question 71

The ____________________ report style is used to display a master-detail relationship with the master records above the detail records.

Question 72

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

Question 73

The ____________________ report style displays field headings across the top and down the left side of the page.

Question 74

In a Reports Builder report,the ____________________ is the area where boilerplate images and text can be placed.

Question 75

Use a(n)____________________ format to preview a report as a formatted web page (including formatting changes made in Paper Design).

Question 76

To modify the report SQL query,use the Report Wizard in ____________________ mode.

Question 77

What type of data link do you create if the primary key in the parent record is a foreign key in the child record?

A)Column to Column
B)Key to Key
C)Query to Query
D)Group to Group

Question 78

Where in the Report Wizard are summary columns created?

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

Question 79

The ____________________ page of the Report Wizard is used to specify the SQL query that retrieves the report data.

Question 80

What is the standard prefix for the name of a formula column?

A)F
B)CF
C)FF
D)FC