SAMPLE IT PAPERS

DEV 2000
UNIT-1 (FORMS)
I. Each Question Carries 1 Mark.

1. Oracle form is a ____C_____
a)Language b)Package c) Tool d)None

2. In Forms, data can be ___D____
a)Selected b)Edited c)Deleted d)All

3. _C___ is used to display data from two tables , which has a common column name.
a)Table b)View c)Master-Detail d)None

4. Forms can be made more user-friendly by using the controls like ___D_____
a)List of Values b)List Item c)Radio Group d)All

5. .FMB stands for ___A______
a)Form Module Binary b)Form Meta Binary c)Form Module Based d)None

6. .FMT stands for _____C______
a)Form Module Template b)Form Meta Text c)Form Module Text d)None

7. .FMX stands for ______B________
a)Form Module Extended b)Form Module Executable c)Form Meta executable d)None

8. A form is more than a single window . (True / False)

9. In the form, we can create two types of Blocks. They are ___A___ and _A___.
a)Base Table Block & Control Block b)Data Wizard Block& Record Block c)Form Block&Manual Block d)None

10. To create an application , use the Oracle ___B______.
a)Report Builder b)Form Builder c)Graphics Builder d)None

11. An ____A____ application can also incorporate modules from other tools, such as Oracle Reports and Oracle Graphics.
a)Oracle Form b)Sql Plus c)Sql * Report d)None

12. ___B______ is extends the SQL Language by adding block-structured procedural constructs combined with SQL’s non-procedural capabilities.
a)SQL*PLUS b)PL/SQL c)SQL*REPORT d)None

13. Oracle Form can be used to perform the ___D_____ activities.
a)Retrieving data from tables b)Changing data in the tables. c)Saving changes to the tables d)All

14. Basically , Oracle Form using ___D____ components to do all activities.
a)Builder b)Generate c)Run Form d)All

15. Application developers use the ___A___ to create an application.
a)Builder b)Generate c)Run Form d)None

16. The _C_ presents a hierarchical view of an entire Oracle Forms design session.
a)Properties Window b)Layout Editor c)Object Navigator d)None

17. The ___B______ display your form graphically.
a)Properties Window b)Layout Editor c)Object Navigator d)None

18. The ______A___ displays the properties of the objects you select in the Navigator.
a)Properties Window b)Layout Editor c)Object Navigator d)None

19. Form operators use ___D______ to run the generated application .
a)Builder b)Generate c)Run Form d)All

20. A___A____ block contains items from a single database Table.
a)Base Table Data Block b)Control Data Block c)Form Block d)None

21. ___B____ block contains items not related to database table .
a)Base Table Data Block b)Control Data Block c)Form Block d)None

22. A record in a data block displays a _B____ from the database.
a)Column b)Row c)Table d)None

23. An ___A_____ is an interface object that displays data from a column in the database to operators.
a)Item b)Row c)Table d)none

24. A rectangle with a text lable or an icon graphic inside. This interface is ____C____
a)Check box b)List Item c)Button d)None

25. A text label with a graphic state indicator that displays the current value as either checked or unchecked . This interface is __A____-
a)Check box b)List Item c)Button d)None

26. A read only text box whose value must be fetched or assigned programmatically. This interface is called ___C___
a)Check box b)List Item c)Display Item d)None

27. The __C__ interface to allow the user to load, record , edit , play and save sounds.
a)OLE Container b)Active X Control c)Sound Item d) None

28. ___B___ is a custom control that simplifies the building and enhancing of user interfaces.
a)OLE Container b)Active X Control c)Sound Item d) None

29. A group of choices displayed as either a pop list , a T-list or a Combo list. This interface is ___B__
a)Check box b)List Item c)Display Item d)None

30. A single or multi line box that supports a variety of data types, format masks and editing capabilities. This type of interface is _____B____
a)Check box b)Text Item c)Display Item d)None

31. A group of buttons , one of which is always selected. This interface is __C___.
a)Check Box b)List Item c)Radio Group d)None

32. A bordered rectangle of any size that can display a graphic representation generated by Graphic Builder . This type of interface is ___A_____.
a)Chart Item b)Image Item c)OLE Container d)None

33. An area that stores and display in the object that is created from an other server application . This type of interface is ______A____.
a)OLE Container b)Active X Control c)Sound Item d)None

34. Form Builder Executable file name is ____A_________.
a)F50DES32.EXE b)G30DES32.EXE c)R30DES32.EXE d)None

35. Form file extension is ___B____
a).FRM b).FMB c).FMR d)None

36. Form Layout style is well suited for a ____A____ block.
a)Single-Record b)Multiple Records c)No limit d)None

37. Tabular layout style is better suited for a data block that displays ____B__ records.
a)Single-Record b)Multiple Records c)No limit d)None

38. _____B____ are typically useful for multi-record block.
a)Tab Key b)Scroll Bar c)Space Bar d)None

39. In Form Wizard, last step is ____A________.
a)Congratulation Window b)Welcome Window c)Bye-Bye Window d)None

40. After saving the form, display the __B____ message in the status bar.
a)Module Save Successfully. b)Module built Successfully. c)Form Save Successfully d)None

41. ___C________ is the command to exit from RUNFORM window.
a)FILE – EXIT b)ACTION – QUIT c)ACTION – EXIT d)None

42. In the Runform, ___A_____ is the command to fetch the rows from the table.
a)Query – Execute b)Record – Fetch c)Query - Find d)None

43. In the Runform, ___C_____ is the command to insert the record in a table.
a)Record – Save b)Record – store c)Record – Insert d)None

44. In the Runform, ___A_____ is the command to delete a record from the table.
a)Record – Remove b)Record – erase c)Record – delete d)None

45. ____A____ is the command to leave from Runform and returns to the Designer.
a)Action – Exit b)Action – Quit c)Action - Leave d) None

46. ____D_____ is the command to display object navigator window.
a)Tools – Object Navigator b)Widow – Object Navigator c)Format – Object Navigator d)a & b

47. In Object Navigator, a box with __A___ symbol means the node contains objects and can be expanded.
a)Plus (+) b)Minus (-) c)Ampersand (&) d) None

48. In Object Navigator, when node is fully expanded , then __B___ symbol will appear inside the box.
a)Plus (+) b)Minus (-) c)Ampersand (&) d) None

49. When we move the mouse over the Tools Palette , Oracle Forms displays a ___B___ showing the name of each tool.
a)Help b)ToolTip c)Menu d)None

50. ___D_______ is the method to run the form .
a)Program – RunForm b)Run Form Icon tool c)Start – Developer 2000 – Forms Runtime d)ALL

51. ___A_____ means we can use the Data Block Wizard to modify an existing data block-even if the block was not originally created with the wizard.
a)Re-entrant b)Re-form wizard c)Recursion d)None

52. In the form , ____A____ is using to display the system date automatically when run the form.
a)$$DATE$$ b)$$SYSDATE$$ c)$DATE$ d)None

53. In the form , ___A_____ is using to display the system date automatically when run the form.
a)$$TIME$$ b)$$SYSTIME$$ c)$TIME$ d)None

54. In oracle forms , ____B______ mode allows an operator to retrieve records from the database and then change those records. i.e update, insert , delete and commit records.
a)Enter Query Mode b)Normal Mode c)Insert Mode d)None

55. ____A___ command to using to give the Query .
a)Query – Enter Query b)Query – Condition c)Insert – Query d)None

56. When we press Down arrow key after the last record in Query – Execute mode, Oracle Forms displays the _____C____ message.
a)FRM-5032 , Last Record of query retrieved b)FRM-4032 , Last Record of query retrieved
c)FRM-40352 , Last Record of query retrieved d)None

57. Oracle Forms assumes that want to insert a record and create a new record and Oracle Forms displays the ____A_____ message.
a)FRM-40102 : Record must be entered or deleted first b)FRM-40102 : Record must be entered or deleted first
c)FRM-40102 : Record must be entered or deleted first d)None

58. When we are using pattern String Matching, ___C__ symbol represents any single character.
a)$ b)& c)Under Score ( _ ) d)None

59. When we are using pattern String Matching, __B__ symbol represents any number of characters .
a)& b)% c)# d)None

60. Oracle Forms cancels the query and returns the form to Normal Mode. The status line displays __A__ message .
a)FRM – 40353 Query Cancelled b)FRM – 4353 Query Cancelled c)FRM – 4053 Query Cancelled d)None

61. To make modifications permanent in the database table , the operator must explicitly use the ___B__ command .
a)Action – Save b)Save tool c)Action - Commit d)a & b

62. Oracle Forms interacts with the database by using __A___ statements.
a)SQL Statement b)SQL*Plus c)PL/SQL d) None

63. Once a transaction has been save by using __B__ , the operator can no longer undo that transaction .
a)File – Save b)Action – Save c)Edit – Save d)None

64. The ____C_____ is the command to lock the record.
a)Action - Lock b)File – Record – Lock c) Record – Lock d)None

65. In a Form , validation is done by attaching a trigger to the item to be validated. This trigger name is ___B_______
a)WHEN BUTTON_PRESSED b)WHEN_VALIDATE_ITEM c)PRE_ITEM d)None

66. The __A______ exception is a predefined PL/SQL exception available only in oracle forms.
a)FORM_TRIGGER_FAILURE b)FORM_TRIGGER_RAISED c)FORM_TRIGGER_EXCEPTION d )None

67. ___B______ is used to display any message on the status line in Oracle Form Application .
a)DISLAY() b)MESSAGE() c)PRINT() d)None

68. If the code is error free , a ____C____ message is displayed at the bottom right corner .
a)CODE SUCCESSFULLY b)NO ERRORS & WARNINGS c)SUCCESSFULLY COMPILE d)None

69. The ____A_____ allows the user to revise the default layout by dragging the items according to the wish of the user.
a)Layout Editor b)Properties Window c)Object Navigator d) None

70. Each item’s property can be set by using _____B_____.
a)Layout Editor b)Properties Window c)Object Navigator d)None

71. Objects and nodes in the ___C___ are displayed with a ‘+’ or ‘-‘ symbol to indicate whether they are currently expanded or collapsed.
a)Layout Editor b)Properties Window c)Object Navigator d) None

72. In the ____A___ view, all form objects are visible and the display hierarchy corresponds to the Oracle Forms object ownership hierarchy.
a)Ownership View b)Visual View c)Layout View d)None

73. In the __B____ view , only windows , canvas-views and items are displayed .
a)Ownership View b)Visual View c)Layout View d)None

74. In oracle form , all items are assigned to __C___ views.
a)Ownership View b)Visual View c)Canvas View d)None

75. We cannot change the name of library modules in the Object Navigator. (True / False)

76. Objects can be copied from one module to another , but cannot be moved from one module to another module.
(true / False).

77. __A_____ modules contain only subprograms and packages.
a)Library b)Block c)Item d) None

78. The __A____ detects syntax errors, semantic errors, and references to non-existent objects, procedures and functions.
a)Compiler b)Runform c)Saving d)None

79. ___B__ message is displayed on the status bar, when we compile successfully.
a)

b) c) d)None

80. A ____A_____ is a modal window that displays a message notifying the user of some application condition .
a)Alert b)Error c)Message d)None

81. Oracle Forms has many built-in alerts that display ___C____ messages.
a)user b)customized c)Pre-defined d)None

82. In Alert , we can give the alert message , maximum __B_____ characters.
a)300 b)200 c)100 d)None

83. In Alert , Maximum number of button are ___A____.
a)3 b )4 c)No limit d)None

84. ____B_____ built-in function is using to display the alert that is created.
a)DISPLAY_ALERT() b)SHOW_ALERT() c)PRINT_ALERT() d)None

85. Show_alert() function returns __A____ data type.
a)Number b) String c)Boolean d)None

86. We can change the Alert message at runtime by executing the __A____ built-in procedure.
a)SET_ALERT_PROPERTY() b)SET_ALERT_MESSAGE() c)SET_ALERT_TEXT() d)None

87. The ____B______ function is to get the object ID for the alert.
a)SEARCH_ALERT() b)FIND_ALERT() c)SEEK_ALERT() d)None

88. A ____A____ display list of choices. Operator can only select one value at a time from a list
a)List Item b)Radio Group c)Check box d) LOV

89. _B__ is a group of two or more radio buttons, one of which is always selected.
a)List Item b)Radio Group c)Check box d) LOV

90. A ___C____ is a text label with an indicator that displays the current value as either checked or unchecked.
a)List Item b)Radio Group c)Check box d) LOV

91. ____D____ is creating using a SELECT statement and is a dynamic list of data , which already exists in a table.
a)List Item b)Radio Group c)Check box d) LOV

92. ____C_____ is the method to create a LOV.
a) Select LOV node in Object Navigator and Choose NAVIGATOR – CREATE
b) Select LOV node in Object Navigator and Choose ‘+’ in the object navigator
c) A & B
d) None

93. ___A____ script is using to exit from the Form.
a)EXIT_FORM b)QUIT_FORM c)REMOVE_FORM d)None

94. The _____A____function is using to move the control from one block to another Block.
a)GO_BLOCK() b)MOVE_BLOCK() c)GO_ITEM() d)None

95. At run time , the form is displayed in a window with a name ___B______.
a)WINDOW1 b)WINDOW0 c)NEW_WINDOW d)None

96. The _____A_____ feature is used to display data from two tables provided the tables are related to each other on a common key field.
a)MASTER-DETAIL b)Relation c)Link d)None

97. In Master-Detail relationship , if Auto Join Block is checked, then wizard automatically interprets the ____B___ relationship between the data block table , display it in the join condition field and display the name of the master block in the Master Data Block field.
a)Primary Key b)Foreign Key c)Candidate Key d)None

98. PRE-QUERY trigger , we can write in ___C_____ level.
a)Block level b)Item level c)Form Level d)None

99. ____A_________ function is using to any image can be incorporated into a form .
a)READ_IMAGE_FILE() b)WRITE_IMAGE_FILE() c)FETCH_IMAGE_FILE() d)None

100. _____A____ function is using to dynamically write an image to a file.
a)WRITE_IMAGE_FILE() b)WRITE_IMG_FILE() c)WRITE_IMAGE_FILE_LOCATION() d)None

II Each Question Carries 2 MarKs

1. There are Two types of Data Blocks. They are ___A__ and ____A___.
a)Base Table Data Block and Control Data Block b)Form Block and Manual Block
c)Table and View d)None

2. ___A____ block is associated with table . ___A____ block is not associated with table.
a)Base Table Block, Control Block b)Control Block, Base Table Block
c)Form Block, Manual Block d)None

3. Layout style for the frame are ___A___ and ____A______.
a)Form & Tabular b)Group Above & Group Left c)Master-Detail & Matrix d)None

4. ____A____ is the command to insert the record and ___A____ is the command to delete the record from the table in the Run Form.
a)Record – Insert & Record – Remove b)Record – Save & Record – Delete
c) Record – store & Record – Erase d)None

5. Oracle Forms has two modes of operations . They are ___B____ and ____B___.
a)Special Mode & Normal Mode b)Normal Mode & Enter Query Mode
c) Insert Mode & Delete Mode d)None

6. When we are using pattern String Matching, __A___ symbol represents any single character and __A__ symbol represents any number of characters .
a) Under Score( _ ) , Percentage ( % )
b) Dollar ( $ ), Hash symbol ( # )
c) Exclamatory Mark (!) and Ampersand(&)
d) None





7. When we create the form , oracle save the form as __A____ type of extension. After Compilation , automatically generate ___A___ type file extension .
a) .FMB , .FMX b).FMX , .FMB c).FMT , .FMB d)None

8. The Navigator can display modules in ___A___ and ___A____ views.
a)Ownership , Visual b)Manual , Automatic c)Form level, Block level d)None

9. The default alert having two buttons . They are__B___ and __B______.
a)Button 1 & Button 2 b)OK and CANCEL c)Exit & Save d)None

10. In Oracle Form , Code objects are ___A_____ and ____A_______.
a)Triggers and Program Units b)Forms and Blocks c)Blocks and Items. d)None

III. Each Question carries 4 Marks
1 Oracle Forms can be used to perform the ___A______, __A____ and _____A___ activities.
a) Retrieving Data from tables
b) Changing Data in the Tables
c) Saving Changes to the tables
d) Operating System
e) SQL Plus
A) a, b, c B) c , d, e C) a , b e D) None

2 Basically the oracle form using _A_, _A_ and _A__ components to do all activities.
a) Builder, Generate, Runform
b) SQL, PL/SQL, SQL*PLUS
c) MS-Word, MS-Excel, MS-Access
d) None

3 In Oracle Builder window focus is on ____A___, _____A___ and ___A___ Builder tools.
a) Object Navigator, Layout Editor, Properties Window
b) Builder, Generate, Run form
c) MS-Word, MS-Excel, MS-Access
d) None

4 Oracle Forms applications are composed __B__, __B___, _B__ and _B__ objects.
a) Triggers, Functions, Procedures, Programs
b) Form, Data Block, Record, Item
c) Chart Item, Image Item, Radio Group, OLE Container
d) None

5 Form Builder supports ___B___, ______B___ , _B_______ and __B_______ types of interface items that we can use to build application’s interface.
a) Check box, Block , Record , Column
b) Display Item, Sound Item, OLE Container, Radio Group
c) Form, Block, Record, Item
d) None

6 MATCH THE FOLLOWING :
Interface Purpose
1 1) Button a) A single or multi line box that supports a variety of data types,
2 format masks and editing capabilities.
3 2) List Item b) A group of choices displayed as either a poplist , a T-list or
4 a Combo list.
3) Display Item c) A rectangle with a text label or an icon graphic inside.
4) Text Item d) A read only text box whose value must be fetched or assigned
programmatically.
a)1-c 2-b 3-d 4-a b)1-a 2-b 3- c 4-d c)1-d 2-a 3-b 4-c d)None

7 Match the following :
Interface Explanation
1)Chart Item a) A text label with a graphic state indicator that displays the current
value as either checked or unchecked .
5 2)OLE Container b) It is a custom control that simplifies the building and enhancing of
6 user interfaces.
3)ActiveX control c) A bordered rectangle of any size that can display a graphic
representation generated by Graphic Builder .
4)Check Box d) An area that stores and display in the object that is created from an
other server application .
a)1-a 2-b 3-c 4-d b)1-b 2-a 3-d 4-c c)1-c 2-d 3-b 4-a d)None




8 The Data Block Wizard provides __A____, ____A__ , __A_- and ___A_____ buttons to help you navigate your way through its pages.
a) Cancel, Back, Next, Apply b) Top, Bottom, Next, Previous
c) New, Close, Exit, Save d) None

9 In the RUNFORM, the user can do ____A__, ____A__ , ____A__ & __A___ data.
a) QUERY, INSERT, DELETE, UPDATE
b) Retrieve, Save, Change, Exit
c) Save into another table, View data, Change Data, Erase the table
d) None

10 When we are using Query in the Form , __A___ , _____A___ and ___A___ are important.
a) Enter Query, Execute Query, Cancel Query
b) Insert Query, Run Query, Delete Query
c) Input Query, Run Query, Erase Query
d) None

11 Oracle Form maintains an object hierarchy . They are ___C__, _C__ & __C__.
a) FORM – ITEM – DATA BLOCK b) ITEM – DATA BLOCK – FORM
c) FORM – DATABLOCK – ITEM d) None

12 Oracle Form Builder Tools are ___A_____ , _____A____ and ____A________.
a) Layout editor, Properties Window , Object Navigator
b) Form, Data Block, Item
c) Menu edit, Report Builder , Graphics Builder
d) None

13 Certain tools are provided while working in the Layout Editor , which help the user to create different interfaces like ___D_____, ___D______ , ____D____ & ____D________.
a) Windows, Text Items, Display Item, check Boxes
b) Radio Buttons, List Items, List of Values, OLE control
c) Line, Arc , Free Hand, Chart Item
d) ALL

14 We can perform the ___C____, ____C____ & __C______ operations in the Object Navigator.
a) Expand & Collapse entries, Select Objects, Create and Delete Objects
b) Copy and move objects, Switch between views , Locate objects quickly
c) A & B
d) None

15 Triggers can be attach to __A____, ____A____ & _____A____.
a) Form , Block & Item
b) Insert, Delete, Update
c) Create, Alter, Drop
d) None

16 There are three styles of alerts. They are __A___, ___A__ & ___A______.
a) Stop, Caution , Note b) Error, Bug and Mistake
c) Form level, Block level, item level d) None

17 Image file extensions are ____A___, ____A_____ , __A_______ and _____A_____.
a) TIFF, BMP, PCX, GIF , PICT b) .XLS, .DOC, .C, .CPP c).IMG, .IMAGE, .IG, .PIC d) None























Answers – Unit I

1 MARK BITS
1 C 2 D 3 C 4 D 5 A
6 C 7 B 8 True 9 A 10 B
11 A 12 B 13 D 14 D 15 A
16 C 17 B 18 A 19 D 20 A
21 B 22 B 23 A 24 C 25 A
26 C 27 C 28 B 29 B 30 B
31 C 32 A 33 A 34 A 35 B
36 A 37 B 38 B 39 A 40 B
41 C 42 A 43 C 44 A 45 A
46 D 47 A 48 B 49 B 50 D
51 A 52 A 53 A 54 B 55 A
56 C 57 A 58 C 59 B 60 A
61 D 62 A 63 B 64 C 65 B
66 A 67 B 68 C 69 A 70 B
71 C 72 A 73 B 74 C 75 True
76 True 77 A 78 A 79 B 80 A
81 C 82 B 83 A 84 B 85 A
86 A 87 B 88 A 89 B 90 C
91 D 92 C 93 A 94 A 95 B
96 A 97 B 98 C 99 A 100 A
2 MARK BITS
1 A 2 A 3 A 4 A 5 B
6 A 7 A 8 A 9 B 10 A
4 MARKS BITS

1 A 2 A 3 A 4 B 5 B
6 A 7 C 8 A 9 A 10 A
11 C 12 A 13 D 14 C 15 A
16 A 17 A