UNIT – 3
GRAPHICS AND MENUS
1 Mark Questions
1) _______ 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 _________.
a)Menu bar b)Menu Items c)Tool bar d)None
3) _______ 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) _____ 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 _______ folder.
a) c:\orawin95\ G30DES32.EXE b)c:\orawin95\bin\ G30DES32.EXE
c) c:\windows\orawin95\ G30DES32.EXE d)None
6) _______ is the command to connect to the database.
a) File – Connect b)Edit – Connect c)Format – Connect d)None
7) ________ is the valid number format.
a) 999999123 b)99999990 c)99999998 d)None
8) _________ 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)Expanded b)not expanded c)hidden d)None
10) ______ 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) ______ 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) ______ 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) ______ are used to compare sets of data ranges veritically.
a)Line Chart b)Column Chart c)Bar chart d)pie chart
14) ______ are used to compare sets of data ranges horizontally.
a)Line Chart b)Column Chart c)Bar chart d)pie chart
15) ______ chart type is used to show data in a table format.
a)Line Chart b)Column Chart c)Bar chart d)table chart
16) __________ chart type is used to show data along two values axes.
a)scatter chat b)mixed chart c)high low chart d)None
17) _______ 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) ___________ 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) ________ 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 __________ 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 _________ by default
a) OGFORMATTING1 b)OGFORMATTRIG0 c)OGFORMATTRIG2 d)None
22) 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 ________ 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 ________ type of trigger is used to update the chart.
a)Format trigger b)database Trigger c)application trigger d)None
25) ____ is the command to update the chart.
a)View – Update b)Chart – Update c)Edit – Update d)None
26) Default parameter name is ________ in graphics Builder.
a)PARAM0 b)PARAMETER0 c) PARA1 d)None
27) Field Template command is under ________ menu.
a)Chart b)Format c) Edit d)None
28) Menu is display by default in _________ position.
a)bottom b) left side c) top d) None
29) The default menu module is available in the file _____.
a)menudef.mmb b)menu.mmb c)menudefinition.mmb d)None
30) The _____ function is used to do some action on the menu item.
a)MENU_ITEM() b)DO_KEY() c) MENU() d)None
31) _________ is used to execute the query.
a)EXECUTE_QUERY b)RUN_QUERY c)QUERY_EXECUTE d)None
32) _____ is used to exit from the form.
a)EXIT b)EXIT_FORM c) FORM_EXIT d)None
33) ________ is used to count number of rows by using query.
a)COUNT_QUERY b)QUERY_COUNT c)COUNT d)None
34) The ________ is used to move the pointer to the next record.
a)MOVE_NEXT b)NEXT_ROW c)NEXT_RECORD d)None
35) __________ is the command to add the new record.
a)INSERT_RECORD b)NEW_RECORD c)ADD_NEW d)None
36) The _________ is used to delete the record.
a)DROP_RECORD b)DELETE_RECORD c)RECORD_DELETE d)None
37) The _________ command is used to clear the block.
a)BLOCK_CLEAR b)CLEAR c)CLEAR_BLOCK d)None
38) The _______ 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).MMB b).MBM c).MMM d) None
40) _________ is the function to call the form from menu item.
a)FORM_CALL() b)CALL_FORM() c)RUN_FORM() d)None
41) ___________ is the file extension of form before execution.
a) .FMB b).FMX c) . FRM d) None
42) ___________ is the file extension of form after execution.
a) .FMB b) . FMX c) . FRM d) None
43) By default , form builder will _________ the calling form before drawing the called form.
a) Hide b) Unhide c)Both d) None
44) _______ 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) _______ menu item have two states. On or off which is displayed in the box.
a)radio b)check c)separator d) None
46) _____ 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) _______ is a line, which is used to separate the different menu item.
a)radio b)check c)separator d) None
2 mark questions
1) ___ and _____ 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 ________, _____, _____ 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 _____, _____ and _____.
a) Query , Chart region and Chart templates b)SQL, SQL Plus, Pro *C
c)Pro * COBOL, Pro * Pascal , Sql * Net d)None
3) There are three types of menu objects. They are _, __ and ___.
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
