UNIT – 2
REPORT
1 MARK QUESTIONS
1. ___A____ 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 ___B__
a) R32DES32.EXE b)R30DES32.EXE c)REPORT.EXE d)None
3. In Report Builder , default designing is ___C____
a)Build a new report Manually b)Open a existing report c)Use the Report Wizard d)None
4. ____B___ is used to connect to the database.
a)database b)*connect c)installed d)None
5. In Query Builder, _D____ 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 ___C__ 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__
A)Corporate 1 B)Corporate 2 c)Confidential Heading d)None
10. In Layout Model of report builder, ___A__ is used for labeling the data.
a)Boiler Plate b)Fields c)Repeating Frames d)None
11. In Layout Model of report builder , __B___ is used for displaying data.
a)Boiler Plate b)Fields c)Repeating Frames d)None
12. In Layout Model of report builder, __C___ is used for controlling each record.
a)Boiler Plate b)Fields c)Repeating Frames d)None
13. In Layout Model of report builder, __B___ is used for grouping other layout objects.
a)Boiler Plate b)Frames c)Repeating Frames d)None
14. By default , report has __B__ inch top and bottom margins.
a)0.8 b)0.5 c)1.0 d)None
15. Report File extension is ___B______.
a).RFE b) .RDF c) .RPF d) None
16. RDF stands for ____B_____.
a) Report Document File b)Report Definition File c)Report Data File d)None
17. ____A___ 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 ____B____ 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 __C___.
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 ___B___ message.
a)No errors b)Successfully compiled c)No errors and no warnings d)None
21. _____A___ 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 _C__ number of different types of reports.
a)5 b)4 c)8 d) None
23. ____D_ 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. __A__ 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. ___C__ 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. __B__ 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. __B_____ 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. ____A__ 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. __C___ 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 ___D__ 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 ___A__ type of default report.
a)Tabular Report b)Form-Like Report c)Mailing label report d)Form letter Report
32. ___B___ 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. ___A____ consist of text and graphics that appear in the report when it is run.
a)Boilerplate b)ields c)Frames d)Anchors
34. ___C__ surround other layout objects, enabling you to control multiple objects simultaneously.
a)Boilerplate b)Fields c)*Frames d)Anchors
35. ___D__ 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. __A_____ 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. __B___ table having unique rows.
a)Details table b)Master table c)Reference table d)None
38. __A___ 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. __C____ are another useful feature compatible with oracle to generates reports.
a)Pro * C b)SQL Plus c) *Oracle *Report Writer d)None
41. A __C___ 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. ____A__ 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 ___A_,__A__,__A__ and __A______.
a)groups, formula, summary columns b) for , while, loop
a) cursors, triggers, DCL commands d)None
2. Report styles are __D___, ___D___, ___D___ and __D___.
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
