Quiz-summary
0 of 204 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
Information
- You are about to start viewing set of Oracle Forms and Reports – Practice Questions.
- These are practice questions useful for learning and exam preparation purpose.
- The answers of the questions are displayed immediately once you click on Check button to check the answer.
- This quiz is completely free.
- Please provide your feedback/suggestions in the comments at the end of the quiz(after last question).
- We wish you happy learning…!!
- Click HERE if you wish to attempt Mock Test on the same topic to test your knowledge.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
Time has elapsed
Categories
- Not categorized 0%
- Oracle Forms and Reports 0%
- Oracle Reports 0%
-
Congratulations!!! You have completed all the questions.Click Here to attempt Mock Test.
Click Restart Quiz button to view the questions again.
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
- Answered
- Review
-
Question 1 of 204
1. Question
What is the difference between Per-Query and Post Query?
Correct
Incorrect
-
Question 2 of 204
2. Question
Select the Sequence of triggers that fire for a Text Item1) When-New-Item2) When-Validate3) Key-Next4) Pre-Text
Correct
Incorrect
-
Question 3 of 204
3. Question
A query fetched 10 records How many times does a POST-QUERY Trigger
Correct
Incorrect
-
Question 4 of 204
4. Question
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Correct
Incorrect
-
Question 5 of 204
5. Question
Can we use GO-BLOCK package in a pre-field trigger
Correct
Incorrect
-
Question 6 of 204
6. Question
What is Post-Block?
Correct
Incorrect
-
Question 7 of 204
7. Question
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
Correct
Incorrect
-
Question 8 of 204
8. Question
EXIT_FORM is a restricted package procedure ?
Correct
Incorrect
-
Question 9 of 204
9. Question
The value recorded in system.last_record variable is of type
Correct
Incorrect
-
Question 10 of 204
10. Question
Can you change the default value of the radio button group at run time?
Correct
Incorrect
-
Question 11 of 204
11. Question
What is not the type of windows?
Correct
Incorrect
-
Question 12 of 204
12. Question
What are the different types of Delete details we can establish in Master-Details?
Correct
Incorrect
-
Question 13 of 204
13. Question
Use the ADD_GROUP_ROW procedure to add a row to a static record group
Correct
Incorrect
-
Question 14 of 204
14. Question
How do you pass values from one form to another form?
Correct
Incorrect
-
Question 15 of 204
15. Question
What is a RADIO GROUP?
Correct
Incorrect
-
Question 16 of 204
16. Question
How many no of columns can a RECORD GROUP have?
Correct
Incorrect
-
Question 17 of 204
17. Question
In Oracle Forms, Data blocks can be created from _______ and Stored Procedure
Correct
Incorrect
-
Question 18 of 204
18. Question
In Oracle Forms, The triggers that must fire when all the records are newly inserted and a commit is done are Pre-Insert, On-Insert and _____.
Correct
Incorrect
-
Question 19 of 204
19. Question
In Oracle Forms, The triggers that must fire when all the records are newly inserted and a commit is done are _______, On-Insert and Post-Insert.
Correct
Incorrect
-
Question 20 of 204
20. Question
In Oracle Forms, the Database item property is set to ‘no’ if the item is not associated with a base table column
Correct
Incorrect
-
Question 21 of 204
21. Question
Which text item data properties can restrict whether a user can insert new data?
Correct
Incorrect
-
Question 22 of 204
22. Question
In Oracle forms, the block to which form builder should first navigate is set with ________ property of the form module.
Correct
Incorrect
-
Question 23 of 204
23. Question
In Oracle forms, Stacked and Tab canvasses are always built over a content canvas.
Correct
Incorrect
-
Question 24 of 204
24. Question
In Oracle forms, the _______ block property can be used to sort the records queried from the database
Correct
Incorrect
-
Question 25 of 204
25. Question
In Oracle forms, which block property can be set programmatically?
Correct
Incorrect
-
Question 26 of 204
26. Question
In Oracle forms, A global variable is active and accessible within a _______
Correct
Incorrect
-
Question 27 of 204
27. Question
In Oracle Forms, If the not null constraint is defined, the _________ property is set to true.
Correct
Incorrect
-
Question 28 of 204
28. Question
In Oracle forms, which information can’t be passed from one form to another form?
Correct
Incorrect
-
Question 29 of 204
29. Question
In Oracle forms, Name_in is a function which writes values into a field
Correct
Incorrect
-
Question 30 of 204
30. Question
In Oracle forms, if you have a Post-query trigger which populates a non-base table field, what will be record status after querying?
Correct
Incorrect
-
Question 31 of 204
31. Question
Can a Block be associated to multiple objects like a Table, View or Synonym?
Correct
Incorrect
-
Question 32 of 204
32. Question
When-Validate-Item trigger can have navigational built-ins in them.
Correct
Incorrect
-
Question 33 of 204
33. Question
If the same property is defined in both Property Class and the Visual Attributes then property value defined in which takes precedence over the other
Correct
Incorrect
-
Question 34 of 204
34. Question
Field variables and form System variables can be referenced in the library by
Correct
Incorrect
-
Question 35 of 204
35. Question
Which of the following property determines the type of an item.
Correct
Incorrect
-
Question 36 of 204
36. Question
Which of the following function is used to check if a Parameter List is created or not.
Correct
Incorrect
-
Question 37 of 204
37. Question
Global variables are defined with __________ data type and ________ size.
Correct
Incorrect
-
Question 38 of 204
38. Question
Pick the correct sequence in which the trigger fires when a form loads.1) Post-Logon2) Pre-Form3) When-New-Record-Instance4) Pre-Record
Correct
Incorrect
-
Question 39 of 204
39. Question
A Data block can be associated with.
Correct
Incorrect
-
Question 40 of 204
40. Question
What is SECURE property?
Correct
Incorrect
-
Question 41 of 204
41. Question
If you have property class attached to an item and you have same trigger written for the item. Which will fire first?
Correct
Incorrect
-
Question 42 of 204
42. Question
Object group have a block
Correct
Incorrect
-
Question 43 of 204
43. Question
CALL_FORM can calls the other form by which the parent form will be inactive
Correct
Incorrect
-
Question 44 of 204
44. Question
What is an LOV?
Correct
Incorrect
-
Question 45 of 204
45. Question
A control block is not associated with the database
Correct
Incorrect
-
Question 46 of 204
46. Question
While specifying master/detail relationship between two blocks specifying the join condition is a must ?
Correct
Incorrect
-
Question 47 of 204
47. Question
Committed block sometimes refer to a BASE TABLE ?
Correct
Incorrect
-
Question 48 of 204
48. Question
A query fetched 10 records How many times does a PRE-QUERY Trigger
Correct
Incorrect
-
Question 49 of 204
49. Question
Key next item trigger is common in form level, block level and item level
Correct
Incorrect
-
Question 50 of 204
50. Question
Custom library allows extension of Oracle Applications forms without modification of Oracle applications code
Correct
Incorrect
-
Question 51 of 204
51. Question
Name the directory having the FORMS source codes ( FMB files ) ?
Correct
Incorrect
-
Question 52 of 204
52. Question
What is template form?
Correct
Incorrect
-
Question 53 of 204
53. Question
Why we have to maintain the file names in Capital Letter? ( Library/FMB)
Correct
Incorrect
-
Question 54 of 204
54. Question
Which one is not the standard libraries available in template form?
Correct
Incorrect
-
Question 55 of 204
55. Question
What is use of custom library?
Correct
Incorrect
-
Question 56 of 204
56. Question
How can you change the default menu bar action?
Correct
Incorrect
-
Question 57 of 204
57. Question
By using APPDAYPK library you can display calendar window in date field LOV
Correct
Incorrect
-
Question 58 of 204
58. Question
Which library we can use to change the profile value?
Correct
Incorrect
-
Question 59 of 204
59. Question
How can I modify screen without modifying the underlying executable?
Correct
Incorrect
-
Question 60 of 204
60. Question
In Oracle Reports, What are the ways by which data can be generated for any parameter’s list of values?
Correct
Incorrect
-
Question 61 of 204
61. Question
In Oracle Reports, a bind parameter is used to replace a single value.
Correct
Incorrect
-
Question 62 of 204
62. Question
In Oracle Reports, What type of columns will be used as an empty container to be populated from another object?
Correct
Incorrect
-
Question 63 of 204
63. Question
Which of the following is not a system variable in Oracle Reports?
Correct
Incorrect
-
Question 64 of 204
64. Question
In Oracle Reports, the between pages trigger fires for which of the following events?
Correct
Incorrect
-
Question 65 of 204
65. Question
Which of the following is not an Oracle Reports built-in package?
Correct
Incorrect
-
Question 66 of 204
66. Question
Which of the following is not a Oracle Reports layout object?
Correct
Incorrect
-
Question 67 of 204
67. Question
Which of the following is not a system parameter in Oracle Reports.
Correct
Incorrect
-
Question 68 of 204
68. Question
In oracle report, what type of columns will be used for doing mathematical calculations?
Correct
Incorrect
-
Question 69 of 204
69. Question
In oracle report, If there are 10 pages in the report, then how many times the between pages trigger would fire?
Correct
Incorrect
-
Question 70 of 204
70. Question
In Oracle Reports, Queries in are created in
Correct
Incorrect
-
Question 71 of 204
71. Question
In Oracle Reports, The Report layout is created or modified in ______
Correct
Incorrect
-
Question 72 of 204
72. Question
Report Designer has file extension as _______.
Correct
Incorrect
-
Question 73 of 204
73. Question
In Oracle Reports, _____ determines the hierarchy of the data appearing in a report, and are used primarily to create breaks
Correct
Incorrect
-
Question 74 of 204
74. Question
In Oracle Reports, ______ are variables for your report that enable you to change the selection criteria at runtime.
Correct
Incorrect
-
Question 75 of 204
75. Question
In Oracle Reports, _____ are used to establish parent-child relationships between queries and groups via column-matching
Correct
Incorrect
-
Question 76 of 204
76. Question
In Oracle Reports, Developers can create 2 types of parameters viz: bind and
Correct
Incorrect
-
Question 77 of 204
77. Question
In Oracle Reports, Developers can create 2 types of parameters viz: ____ and lexical parameters
Correct
Incorrect
-
Question 78 of 204
78. Question
In Oracle Reports, Use a ____ parameter, when you want the parameter to substitute any part of the select statement at runtime.
Correct
Incorrect
-
Question 79 of 204
79. Question
In Oracle Reports, Precede a bind parameter with a ______ while accessing the parameter in any code
Correct
Incorrect
-
Question 80 of 204
80. Question
In Oracle Reports, Report Totals at various groups can be created using _______.
Correct
Incorrect
-
Question 81 of 204
81. Question
In Oracle reports, A frame prints once for each record retrieved.
Correct
Incorrect
-
Question 82 of 204
82. Question
In Oracle reports, The print direction of a repeating frame can’t be _______
Correct
Incorrect
-
Question 83 of 204
83. Question
In Oracle reports, If you want to display or hide the contents of a Frame conditionally, then _________
Correct
Incorrect
-
Question 84 of 204
84. Question
Which is the report trigger will fire first?
Correct
Incorrect
-
Question 85 of 204
85. Question
How many group required for matrix report?
Correct
Incorrect
-
Question 86 of 204
86. Question
Is it possible calling a report from a report?
Correct
Incorrect
-
Question 87 of 204
87. Question
Is it possible to call a form from report?
Correct
Incorrect
-
Question 88 of 204
88. Question
Is it possible to change the table name of report query at run time?
Correct
Incorrect
-
Question 89 of 204
89. Question
How many report triggers are there in a Report?
Correct
Incorrect
-
Question 90 of 204
90. Question
Can we write format trigger in a repeating frame?
Correct
Incorrect
-
Question 91 of 204
91. Question
How can you change the select statement of a query at run time?
Correct
Incorrect
-
Question 92 of 204
92. Question
How many layout triggers are there in a report?
Correct
Incorrect
-
Question 93 of 204
93. Question
What is the fire sequence of between page trigger?
Correct
Incorrect
-
Question 94 of 204
94. Question
How many layout can have a report?
Correct
Incorrect
-
Question 95 of 204
95. Question
What is Flex?
Correct
Incorrect
-
Question 96 of 204
96. Question
What is fnd.srwinit ?
Correct
Incorrect
-
Question 97 of 204
97. Question
What is fnd.srwexit ?
Correct
Incorrect
-
Question 98 of 204
98. Question
After parameter form trigger will fire before the parameter form
Correct
Incorrect
-
Question 99 of 204
99. Question
Before report trigger will fire before the query will parse
Correct
Incorrect
-
Question 100 of 204
100. Question
which of them are valid report triggers
Correct
Incorrect
-
Question 101 of 204
101. Question
which of them are valid forms triggers
Correct
Incorrect
-
Question 102 of 204
102. Question
Which of the following is true about a property class in oracle forms
Correct
Incorrect
-
Question 103 of 204
103. Question
Can a record group be created dynamically in Oracle Forms
Correct
Incorrect
-
Question 104 of 204
104. Question
Can a LOV created in Oracle Forms dynamically
Correct
Incorrect
-
Question 105 of 204
105. Question
How many basetable blocks can a form have?
Correct
Incorrect
-
Question 106 of 204
106. Question
How many triggers can a form have?
Correct
Incorrect
-
Question 107 of 204
107. Question
Which is the first trigger fired when a form is opened
Correct
Incorrect
-
Question 108 of 204
108. Question
How many content canvases can a form have
Correct
Incorrect
-
Question 109 of 204
109. Question
How many stacked canvases can a forms have?
Correct
Incorrect
-
Question 110 of 204
110. Question
How many items can a form have?
Correct
Incorrect
-
Question 111 of 204
111. Question
How to hide an item from displayed?
Correct
Incorrect
-
Question 112 of 204
112. Question
What type of canvases are available in Oracle Forms
Correct
Incorrect
-
Question 113 of 204
113. Question
Which built-in is used to change item property at run time
Correct
Incorrect
-
Question 114 of 204
114. Question
In Oracle forms can you check whether an object exists or not
Correct
Incorrect
-
Question 115 of 204
115. Question
Can you attach a library to more than one form
Correct
Incorrect
-
Question 116 of 204
116. Question
Valid layoutts of the block in Oracle forms are
Correct
Incorrect
-
Question 117 of 204
117. Question
In Oracle forms which of the following items can be used as input items
Correct
Incorrect
-
Question 118 of 204
118. Question
Is the statement true ‘No of records displayed property of block can be set programatically in Oracle forms’?
Correct
Incorrect
-
Question 119 of 204
119. Question
Which of the following are valid extension in Oracle Forms
Correct
Incorrect
-
Question 120 of 204
120. Question
Can a block be created in oracle forms without a base table?
Correct
Incorrect
-
Question 121 of 204
121. Question
Which of the following are valid styles of alert in Oracle forms?
Correct
Incorrect
-
Question 122 of 204
122. Question
How to invoke a alter in oracle forms?
Correct
Incorrect
-
Question 123 of 204
123. Question
Which of the following is not a valid oracle forms object?
Correct
Incorrect
-
Question 124 of 204
124. Question
In Oracle forms a block can be based on the following objects?
Correct
Incorrect
-
Question 125 of 204
125. Question
Valid file extenstion in Oracle reports are?
Correct
Incorrect
-
Question 126 of 204
126. Question
How is relative positioning in Oracle reports achieved?
Correct
Incorrect
-
Question 127 of 204
127. Question
Which of the following are valid layout formats in Oracle reprots
Correct
Incorrect
-
Question 128 of 204
128. Question
How to change the format of frame or item programatically in oracle reprots
Correct
Incorrect
-
Question 129 of 204
129. Question
Valid printing direction in Oracle reports are?
Correct
Incorrect
-
Question 130 of 204
130. Question
which of the following is not a valid oracle reports object?
Correct
Incorrect
-
Question 131 of 204
131. Question
What are the valid file extension Oracle libraries?
Correct
Incorrect
-
Question 132 of 204
132. Question
Number of records dispalyed in a block can be set at runtime in Oracle forms?
Correct
Incorrect
-
Question 133 of 204
133. Question
In Oracle Forms, how many buttons are created on an alert?
Correct
Incorrect
-
Question 134 of 204
134. Question
Which sub-routine is used to invoke alter in oracle forms
Correct
Incorrect
-
Question 135 of 204
135. Question
Which of the following is not a valid sub-function in oracle forms?
Correct
Incorrect
-
Question 136 of 204
136. Question
How many times a pre-query trigger executed for a block of 10 records in oracle forms?
Correct
Incorrect
-
Question 137 of 204
137. Question
How to display message to user at runtime in Oracle Forms?
Correct
Incorrect
-
Question 138 of 204
138. Question
How is debugging message displayed in oracle reports
Correct
Incorrect
-
Question 139 of 204
139. Question
Can window property be changed at runtime in Oracle forms?
Correct
Incorrect
-
Question 140 of 204
140. Question
What are valid program units in Oracle Forms?
Correct
Incorrect
-
Question 141 of 204
141. Question
what are valid program units in Oracle Reports?
Correct
Incorrect
-
Question 142 of 204
142. Question
How are the font, colour are set for an object in oracle forms?
Correct
Incorrect
-
Question 143 of 204
143. Question
How to query data in a block at runtime in oracle forsm
Correct
Incorrect
-
Question 144 of 204
144. Question
Can you have more item then the columns of a table in a base table block
Correct
Incorrect
-
Question 145 of 204
145. Question
can you query data in a control block
Correct
Incorrect
-
Question 146 of 204
146. Question
How do you group objects to copy to another module?
Correct
Incorrect
-
Question 147 of 204
147. Question
which of the following are valid object in oracle forms
Correct
Incorrect
-
Question 148 of 204
148. Question
How to display a hint when cursor is moved from one item to another
Correct
Incorrect
-
Question 149 of 204
149. Question
How to display a message in the status bar when the cursor moved to the items
Correct
Incorrect
-
Question 150 of 204
150. Question
How to enfore the user to enter value in text item in oracle forms?
Correct
Incorrect
-
Question 151 of 204
151. Question
How is value defaulted in a text item in Oracle forms?
Correct
Incorrect
-
Question 152 of 204
152. Question
Can text item value be defaulted in oracle forns
Correct
Incorrect
-
Question 153 of 204
153. Question
Toolbar is not a valid canvas type in oracle forms?
Correct
Incorrect
-
Question 154 of 204
154. Question
A tab canvas can contain more than one page?
Correct
Incorrect
-
Question 155 of 204
155. Question
Can a PL/SQL library be attached to a form as well as report?
Correct
Incorrect
-
Question 156 of 204
156. Question
Can you call a database procedure from trigger in Oracle forms?
Correct
Incorrect
-
Question 157 of 204
157. Question
Can you call a database procedure from trigger in Oracle reports?
Correct
Incorrect
-
Question 158 of 204
158. Question
Can you call a Oracle form from an Oracle reports?
Correct
Incorrect
-
Question 159 of 204
159. Question
Can you call a Oracle report from an Oracle form?
Correct
Incorrect
-
Question 160 of 204
160. Question
Can a tabbed canvas be placed on a stacked canvas?
Correct
Incorrect
-
Question 161 of 204
161. Question
Can a content canvas be placed on a stacked canvas?
Correct
Incorrect
-
Question 162 of 204
162. Question
Can you call a stored procedure from a formula column in oracle reports?
Correct
Incorrect
-
Question 163 of 204
163. Question
How to run DDL statements from Oracle reprots
Correct
Incorrect
-
Question 164 of 204
164. Question
What are the mandatory parameters when we write concurrent program using stored procedures?
Correct
Incorrect
-
Question 165 of 204
165. Question
What is a collection of requests, request sets and concurrent programs