UNIT – 3
GRAPHICS AND MENUS
1 Mark Questions
1) ____B___ is developer 2000 product used for representing data in the tables in the form graphics.
a)Oracle Report Builder b)Oracle Graphics c)Oracle Charts d)None
2) Each Menu contains one or more ___B______.
a)Menu bar b)Menu Items c)Tool bar d)None
3) __C_____ is the command to load graphics builder.
a) Start – Programs – oracle – Graphics Builder
b) Start – Programs – Accessories – Graphics Builder
c) Start – Programs – Developer 2000 – Graphics Builder
d) None
4) ___C__ is an executable file for graphics builder.
a)G33DES33.EXE b)G32DES32.EXE c)G30DES32.EXE d)None
5) Graphics Builder file is available in ___B____ folder.
a) c:\orawin95\ G30DES32.EXE b)c:\orawin95\bin\ G30DES32.EXE
b) c:\windows\orawin95\ G30DES32.EXE d)None
6) ___A____ is the command to connect to the database.
a) File – Connect b)Edit – Connect c)Format – Connect d)None
7) __B______ is the valid number format.
a) 999999123 b)99999990 c)99999998 d)None
8) ___B______ is the file extension of Graphics file.
a) .RPT b).OGD c).GRA d)None
9) Each node in the Navigator has a small box to the left of it. If the ‘ + ‘ is displayed inside the box, then that node can be ___A____
a)Expanded b)not expanded c)hidden d)None
10) ___C___ is the command to restart oracle graphics and connect to the database.
a) FILE - > DISPLAY b)EDIT - > DISPLAY c)*FILE – NEW – DISPLAY d)None
11) ____A__ type of graph is used to show vertical changes for a specific set of data.
a)Line Chart b)Column Chart c)Bar chart d)None
12) ___D___ type of graph is used to compare ratios or percentages of parts of whole.
a)Line Chart b)Column Chart c)Bar chart d)pie chart
13) ____B__ are used to compare sets of data ranges veritically.
a)Line Chart b)Column Chart c)Bar chart d)pie chart
14) ___C___ are used to compare sets of data ranges horizontally.
a)Line Chart b)Column Chart c)Bar chart d)pie chart
15) ___D___ chart type is used to show data in a table format.
a)Line Chart b)Column Chart c)Bar chart d)table chart
16) ___A_______ chart type is used to show data along two values axes.
a)scatter chat b)mixed chart c)high low chart d)None
17) ____B___ this type of chart is used to combine multiple plot types such as column and line.
a) scatter chat b)mixed chart c)high low chart d)None
18) ____C_______ type of chart is used to show fields that correspond to high, low and close .
a) mixed chat b)high , low, close chart c)high low chart d)None
19) ___D_____ type is used to show sets of project data over a given amount of time.
a) scatter chat b)mixed chart c)high low chart d)Gantt Chart
20) A ______A____ is used to change the visual appearance of a chart element to draw attention.
a) Format trigger b)Database Trigger c)Application trigger d)None
21) The new program unit is named ____B_____ by default
a) OGFORMATTING1 b)OGFORMATTRIG0 c)OGFORMATTRIG2 d)None
22) A ____A____ type of trigger is used to change the visual appearance of a chart element to draw attention.
a)Format trigger b)database Trigger c)application trigger d)None
23) The _____B___ default function is an Oracle Graphics built-in function that returns a single item of data to be evaluated.
a)OG_PUT_NUMCELL b)OG_GET_NUMCELL c)OG_GRA_NUMCELL d)None
24) A ____A____ type of trigger is used to update the chart.
a)Format trigger b)database Trigger c)application trigger d)None
25) ___B_ is the command to update the chart.
a)View – Update b)Chart – Update c)Edit – Update d)None
26) Default parameter name is _____A___ in graphics Builder.
a)PARAM0 b)PARAMETER0 c) PARA1 d)None
27) Field Template command is under __A______ menu.
a)Chart b)Format c) Edit d)None
28) Menu is display by default in ___C______ position.
a)bottom b) left side c) top d) None
29) The default menu module is available in the file ___A__.
a)menudef.mmb b)menu.mmb c)menudefinition.mmb d)None
30) The __B___ function is used to do some action on the menu item.
a)MENU_ITEM() b)DO_KEY() c) MENU() d)None
31) _____A____ is used to execute the query.
a)EXECUTE_QUERY b)RUN_QUERY c)QUERY_EXECUTE d)None
32) __B___ is used to exit from the form.
a)EXIT b)EXIT_FORM c) FORM_EXIT d)None
33) ___A_____ is used to count number of rows by using query.
a)COUNT_QUERY b)QUERY_COUNT c)COUNT d)None
34) The ___C_____ is used to move the pointer to the next record.
a)MOVE_NEXT b)NEXT_ROW c)NEXT_RECORD d)None
35) ______A____ is the command to add the new record.
a)INSERT_RECORD b)NEW_RECORD c)ADD_NEW d)None
36) The _____B____ is used to delete the record.
a)DROP_RECORD b)DELETE_RECORD c)RECORD_DELETE d)None
37) The ____C_____ command is used to clear the block.
a)BLOCK_CLEAR b)CLEAR c)CLEAR_BLOCK d)None
38) The ___A____ is the command to create a menu editior.
a)Tools – Menu Editor b)Format – Menu Editor c)Edit – Menu Editor d)None
39) Menu file extension is ____A_______.
a).MMB b).MBM c).MMM d) None
40) _____B____ is the function to call the form from menu item.
a)FORM_CALL() b)CALL_FORM() c)RUN_FORM() d)None
41) _______A____ is the file extension of form before execution.
a) .FMB b).FMX c) . FRM d) None
42) _______B____ is the file extension of form after execution.
a) .FMB b) . FMX c) . FRM d) None
43) By default , form builder will ____A_____ the calling form before drawing the called form.
a) Hide b) Unhide c)Both d) None
44) ___C____ command to invoke one of the supported oracle tools products and specifies the name of the document or module to be run.
a)CALL_FORM() b)EXECUTE_FORM() c)RUN_PRODUCT() d)None
45) __B_____ menu item have two states. On or off which is displayed in the box.
a)radio b)check c)separator d) None
46) __A___ menu item is a part of group from which only one item can be selected at a time.
a)radio b)check c)separator d) None
47) ___C____ is a line, which is used to separate the different menu item.
a)radio b)check c)separator d) None
2 mark questions
1) __A_ and __A___ is the file extension of form and executable form .
a) * .FMB and .FMX b).FMM and .FME c).FRM and .FRX d)None
4 mark questions
1) Form builder will run the indicated form in normal mode , allowing the end user to perform ____A____, _A___, __A___ from within the called form.
a)Insert, updates, deletes b)Select , drop, alter c)Create, delete, commit d)None
2) A chart object consist of three main components . They are _A____, ___A__ and ___A__.
a a) Query , Chart region and Chart templates b)SQL, SQL Plus, Pro *C
b c)Pro * COBOL, Pro * Pascal , Sql * Net d)None
3) There are three types of menu objects. They are _B__ and _B__.
a)procedure, function , trigger. B) Modules, Menus, Items c)Sql, sql/plus, procedure d)None
4) Match the following :
Type of Chart Explanation
1)Column Chart a) is used to show vertical changes for a specific set of data.
2) Bar chart b) is used to compare ratios or percentages of parts of whole.
3) Pie chart c) is used to compare sets of data ranges horizontally.
4)Line chart d) are used to compare sets of data ranges vertically.
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)None
Answers
One mark
1.b 2.b 3.c 4. C 5.b 6.a 7.b 8.b 9.a 10.c 11.a 12.d 13.b 14.c 15.d 16.a17.b 18.c 19.d 20.a 21.b 22.a 23.b 24.a 25.b 26.a 27.a 28.c 29.a 30.b 31.a 32.b 33.a 34.c 35.a 36.b 37.c 38.a 39.a 40.b 41.a 42.b 43.a 44.c 45.b 46.a 47.c
2 marks
1. a
4 mark
1. a 2.a 3.b 4.c
