devp2000part1

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

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

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

3. ____ 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 ________
a)List of Values b)List Item c)Radio Group d)All

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

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

7. .FMX stands for ______________
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 ______ and ____.
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 _________.
a)Report Builder b)Form Builder c)Graphics Builder d)None

11. An ________ 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. _________ 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 ________ 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 _______ components to do all activities.
a)Builder b)Generate c)Run Form d)All

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

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

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

18. The _________ 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 _________ to run the generated application .
a)Builder b)Generate c)Run Form d)All

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

21. _______ 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 _____ from the database.
a)Column b)Row c)Table d)None



23. An ________ 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 ________
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)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 ______
a)Check box b)List Item c)Display Item d)None

27. The ____ 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. ______ 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 _____
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 _________
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 _____.
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)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)OLE Container b)Active X Control c)Sound Item d)None

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

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

36. Form Layout style is well suited for 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 ______ records.
a)Single-Record b)Multiple Records c)No limit d)None

38. _________ 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)Congratulation Window b)Welcome Window c)Bye-Bye Window d)None

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

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

42. In the Runform, ________ 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, ________ 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, ________ is the command to delete a record from the table.
a)Record – Remove b)Record – erase c)Record – delete d)None

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

46. _________ 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 _____ 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 _____ 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 ______ showing the name of each tool.
a)Help b)ToolTip c)Menu d)None

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

51. ________ 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 , ________ is using to display the system date automatically when run the form.
a)$$DATE$$ b)$$SYSDATE$$ c)$DATE$ d)None

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

54. In oracle forms , __________ 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. _______ 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 _________ 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 _________ 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, _____ symbol represents any single character.
a)$ b)& c)Under Score ( _ ) d)None

59. When we are using pattern String Matching, ____ 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 ____ 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 _____ command .
a)Action – Save b)Save tool c)Action - Commit d)a & b

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

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

64. The _________ 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 __________
a)WHEN BUTTON_PRESSED b)WHEN_VALIDATE_ITEM c)PRE_ITEM d)None

66. The ________ 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. _________ 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 ________ message is displayed at the bottom right corner .
a)CODE SUCCESSFULLY b)NO ERRORS & WARNINGS c)SUCCESSFULLY COMPILE d)None

69. The _________ 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 __________.
a)Layout Editor b)Properties Window c)Object Navigator d)None

71. Objects and nodes in the ______ 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 _______ 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 ______ 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 _____ 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. _______ modules contain only subprograms and packages.
a)Library b)Block c)Item d) None

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

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

b) c) d)None

80. 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 _______ messages.
a)user b)customized c)Pre-defined d)None

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

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

84. _________ 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 ______ data type.
a)Number b) String c)Boolean d)None

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

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

88. 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. ___ 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 _______ 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. ________ 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. _________ 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. _______ script is using to exit from the Form.
a)EXIT_FORM b)QUIT_FORM c)REMOVE_FORM d)None

94. The _________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 _________.
a)WINDOW1 b)WINDOW0 c)NEW_WINDOW d)None

96. The __________ 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 _______ 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 ________ level.
a)Block level b)Item level c)Form Level d)None

99. _____________ 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. _________ 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 _____ and _______.
a)Base Table Data Block and Control Data Block b)Form Block and Manual Block
c)Table and View d)None

2. _______ block is associated with table . _______ 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 ______ and __________.
a)Form & Tabular b)Group Above & Group Left c)Master-Detail & Matrix d)None

4. ________ is the command to insert the record and _______ 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 _______ and _______.
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, _____ symbol represents any single character and ____ 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 ______ type of extension. After Compilation , automatically generate ______ type file extension .
a) .FMB , .FMX b).FMX , .FMB c).FMT , .FMB d)None

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

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

10. In Oracle Form , Code objects are ________ and ___________.
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 _________, ______ and ________ 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 __, __ and ___ 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 _______, ________ and ______ 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 ____, _____, ___ and ___ 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 ______, _________ , ________ and _________ 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) Button a) A single or multi line box that supports a variety of data types,
format masks and editing capabilities.
2) List Item b) A group of choices displayed as either a poplist , a T-list or
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 .
2)OLE Container b) It is a custom control that simplifies the building and enhancing of
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 ______, ______ , ___- and ________ 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 ______, ______ , ______ & _____ 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 , _____ , ________ and ______ 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 _____, ___ & ____.
a) FORM – ITEM – DATA BLOCK b) ITEM – DATA BLOCK – FORM
c) FORM – DATABLOCK – ITEM d) None

12 Oracle Form Builder Tools are ________ , _________ and ____________.
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 ________, _________ , ________ & ____________.
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 _______, ________ & ________ 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) Form , Block & Item
b) Insert, Delete, Update
c) Create, Alter, Drop
d) None

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

17 Image file extensions are _______, _________ , _________ and __________.
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