ORACLE Interview Questions and Answers
Part:
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
(Continued from previous part...)
371. Can we create two blocks with the same name in form 3.0 ?
No
372. What is Post-Block is a. ???
a. Navigational Trigger.
b. Key trigger
c. Transaction Trigger.
373. What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
374. Name the two files that are created when you generate the form give the filex extension ?
INP (Source File)
FRM (Executable File)
375. What package procedure used for invoke sql *plus from sql *forms ?
Host (E.g. Host (sqlplus))
376. What is the significance of PAGE 0 in forms 3.0 ?
Hide the fields for internal calculation.
377. What are the different types of key triggers ?
Function Key
Key-function
Key-others
Key-startup
378. What is the difference between a Function Key Trigger and Key Function Trigger ?
Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.
379. Committed block sometimes refer to a BASE TABLE ?
False
380. Error_Code is a package proecdure ?
a. True b. false
False
(Continued on next part...)
Part:
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
|