UNIT – 2
REPORT
1 MARK QUESTIONS
1. _______ is the command to start Report Builder.
a) Start – Programs - Developer 2000 R2.0 – Report Builder
b) Start – programs - Report Builder
c) My computer – programs – Report builder
d) None
2. Report Builder executable File name is _____
a) R32DES32.EXE b)R30DES32.EXE c)REPORT.EXE d)None
3. In Report Builder , default designing is _______
a)Build a new report Manually b)Open a existing report c)Use the Report Wizard d)None
4. _______ is used to connect to the database.
a)database b)*connect c)installed d)None
5. In Query Builder, _____ we have to select.
a) Table b)Synonyms c)View d)All
6. In “Select the fields you would like to display in your report screen “, we have to press ___ key to move one field move to right side.
a) > b)< c)# d) None
7. In “Select the fields you would like to display in your report screen “, we have to press _____ key move to all fields to right side.
a) > b)<< c)>> d) None
8. Which button we can press “In select the fields you would like to by choosing from the calculation below “ .
A)Average B)Count C)Minimum D)All
9. In Report Builder, default predefined template name is ____
A)Corporate 1 B)Corporate 2 c)Confidential Heading d)None
10. In Layout Model of report builder, _____ is used for labeling the data.
a)Boiler Plate b)Fields c)Repeating Frames d)None
11. In Layout Model of report builder , _____ is used for displaying data.
a)Boiler Plate b)Fields c)Repeating Frames d)None
12. In Layout Model of report builder, _____ is used for controlling each record.
a)Boiler Plate b)Fields c)Repeating Frames d)None
13. In Layout Model of report builder, _____ is used for grouping other layout objects.
a)Boiler Plate b)Frames c)Repeating Frames d)None
14. By default , report has ____ inch top and bottom margins.
a)0.8 b)0.5 c)1.0 d)None
15. Report File extension is _________.
a).RFE b) .RDF c) .RPF d) None
16. RDF stands for _________.
a) Report Document File b)Report Definition File c)Report Data File d)None
17. _______ is the command to run the report builder file.
a)FILE - RUN b)Select Live Previewer tool in Layout Model c)EDIT – RUN d)*A & B
18. A ________ is one, which groups the data such that certain repeating values appear only once at the top of the group.
a)Simple report b)Break report c)Confidential Report d)None
19. If the SELECT statement for the report is to be changed, in Data Model window, double click on _____.
a)Sub total name b)Group total name c)Query name d)None
20. If we typed the function program correctly , then compile display the ______ message.
a)No errors b)Successfully compiled c)No errors and no warnings d)None
21. ________ total is displayed at the end of the report.
a)Grand total b)Sub total c)Row total d)None
22. By default, oracle reports creates ___ number of different types of reports.
a)5 b)4 c)8 d) None
23. _____ type of report contains database values embedded in boiler text.
a)Tabular Report b)Form-Like Report c)Mailing label report d)Form letter Report
24. ____ type of report most basic type . Each column corresponds to a column selected from the database.
a)Tabular Report b)Form-Like Report c)Mailing label report d)Form letter Report
25. _____ type report prints labels in multiple columns on each page.
a)Tabular Report b)Form-Like Report c)Mailing label report d)Form letter Report
26. ____ type of Display one record per page ,inserting field values to the right of field labels.
a)Tabular Report b)Form-Like Report c)Mailing label report d)Form letter Report
27. _______ type of report contains two or more groups of data. For every value of the master group, the related values of the details group are fetched from the database.
a)Group left reports b)Group above reports c)Matrix report d)Matrix with group reports
28. ______ type of report divides the rows of a table into ‘ sets ‘ based on a common value in one of the columns.
a)Group left reports b)Group above reports c)Matrix report d)Matrix with group reports
29. _____ report contains one row of labels, one column of labels and information in a grid format that is related to the row and column labels.
a)Group left reports b)Group above reports c)*Matrix report d)Matrix with group reports
30. The _____ type of report is a group above report with a separate matrix for each value of the master group.
a)Group left reports b)Group above reports c)Matrix report d)*Matrix with group reports
31. The _____ type of default report.
a)Tabular Report b)Form-Like Report c)Mailing label report d)Form letter Report
32. ______ act as placeholders for groups and present rows of data retrieved from the database.
a)Boiler Plate b)Repeating Frames c)Matrix Report d)None
33. _______ consist of text and graphics that appear in the report when it is run.
a)Boilerplate b)ields c)Frames d)Anchors
34. _____ surround other layout objects, enabling you to control multiple objects simultaneously.
a)Boilerplate b)Fields c)*Frames d)Anchors
35. _____ fasten an edge of one object to an edge of another object , ensuring that they maintain their relative positions.
a)Boilerplate b)Fields c)Frames d)Anchors
36. _______ data model is created using two queries , each of which owns at least one group and a data link.
a)Master/Detail Report b)Form-Like Report c)Mailing label report d)Form letter Report
37. _____ table having unique rows.
a)Details table b)Master table c)Reference table d)None
38. _____ table having duplicate rows.
a)Details table b)Master table c)Reference table d)None
39. We can print the report along with pictures also. (True/False)
40. ______ are another useful feature compatible with oracle to generates reports.
a)Pro * C b)SQL Plus c) *Oracle *Report Writer d)None
41. A _____ report is a Cross tabulation of four sets of data.
a)Group left reports b)Group above reports c)Matrix report d)Matrix with group reports
42. ______ type of Reports is created using two queries where the information of both the tables are combined and printed.
a)Master/Detail Report b)Form-Like Report c)Mailing label report d)Form letter Report
2 or 4 MARK QUESTIONS
1. Reports can be used to build and use ___, ____ and ________.
a)groups, formula, summary columns b) for , while, loop
a) cursors, triggers, DCL commands d)None
2. Report styles are _____, ______, ______ and _____.
a)Tabular report, Form Like report, Group Left, Group Above
b) Matrix , Matrix with group, Form letter, Mailing Label.
c)Simple, maximum, minimum, average
d)*A & b
3. Match the following :
Type of report Explanation
1) Form Like Report a) It contains database values embedded in boiler text.
2) Mailing Label Report b) This report most basic type . Each column corresponds to a column
selected from the database.
3) Tabular Report c) This report prints labels in multiple columns on each page.
4) Form Letter Report d) Display one record per page ,inserting field values to the right of
field labels.
a)1-a 2- b 3- c 4 – d b)1- b 2- a 3 – c 4- d c)1- d 2 - c 3 – b 4- a d)1 – a 2- a 3 – b 4 – c
*-*-*-*-*-*
Answers:
One marks
1 a 2 b 3. C 4.b 5.d 6.a 7.c 8.d 9.a 10.a 11.b 12.c 13.b 14.b 15.b 16.b 17. A 18.b 19.c 20.b 21. A 22.c 23.d 24. A 25.c 26.b 27. B 28.a 29.c 30.d 31.a 32.b 33.a 34.c 35.d 36.a 37.b 38.a 39.true 40. C 41.c 42.a
2 or 4 marks
1. a 2.d 3.c
