Oracle Memory Management Interview Questions

 
1.
What is SGA?
2.
What is the significance of having storage clause?
3.
What is the functionality of SYSTEM table space?
4.
How does Space allocation table place within a block?
5.
What is the role of PCTFREE parameter is storage clause?
6.
What is the OPTIMAL parameter?
7.
What is a shared pool?
8.
What is mean by Program Global Area (PGA)?
9.
What is a data segment?
10.
What are the factors causing the reparsing of SQL statements in SGA?
11.
What is Database Buffers?
12.
What is dictionary cache?
13.
Which parameter in Storage clause will reduce number of rows per block?
14.
What is meant by free extent?
15.
How will you force database to use particular rollback segment?
16.
How can we organize the tablespaces in Oracle database to have maximum performance?
17.
How will you swap objects into a different table space for an existing database?
18.
What is redo log buffer?
19.
What is meant by recursive hints?
20.
How can we plan storage for very large tables?
21.
How will you estimate the space required by a non-clustered tables?
22.
It is possible to use raw devices as data files and what are the advantages over file system files?
23.
What is a Control file?
24.
How will you monitor rollback segment status?
25.
How will you monitor the space allocation?
26.
Why query fails sometimes?
27.
How the space utilization takes place within rollback segments?
28.
How will you create multiple rollback segments in a database?
29.
What is a rollback segment entry?
30.
What is hit ratio?
31.
What are disadvantages of having raw devices?
32.
What is use of rollback segments in Oracle database?
33.
What is advantage of having disk shadowing / mirroring?
34.
How redo logs can be achieved?
35.
What is redo log file mirroring?
36.
How to implement the multiple control files for an existing database?
37.
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
38.
What is a Shared SQL pool?
39.
What is mean by Program Global Area (PGA)?
40.
List the factors that can affect the accuracy of the estimations?
41.
What are the different kind of export backups?
42.
What is cold backup? What are the elements of it?
43.
What is a logical backup?
44.
What is hot backup and how it can be taken?
45.
What is the use of FILE option in EXP command?
46.
What is the use of GRANT option in EXP command?
47.
What is the use of INDEXES option in EXP command?
48.
What is the use of ROWS option in EXP command?
49.
What is the use of PARFILE option in EXP command?
50.
What is the use of ANALYSE ( Ver 7) option in EXP command?
51.
What is the use of FULL option in EXP command?
52.
What is the use of OWNER option in EXP command?
53.
What is the use of TABLES option in EXP command?
54.
What is the use of RECORD LENGTH option in EXP command?
55.
What is the use of INCTYPE option in EXP command?
56.
What is the use of RECORD option in EXP command?
57.
What is the use of ROWS option in IMP command?
58.
What is the use of INDEXES option in IMP command?
59.
What is the use of GRANT option in IMP command?
60.
What is the use of SHOW option in IMP command?
61.
What is the use of FILE option in IMP command?
62.
What is use of LOG (Ver 7) option in EXP command?
63.
What is the significance of having storage clause?
64.
What is the functionality of SYSTEM table space?
65.
How does Space allocation table place within a block?
66.
What is the role of PCTFREE parameter is storage clause?
67.
What is the OPTIMAL parameter?
68.
What is a shared pool?
69.
What is mean by Program Global Area (PGA)?
70.
What is a data segment?
71.
What are the factors causing the reparsing of SQL statements in SGA?
72.
What is Database Buffers?
73.
What is dictionary cache?
74.
Which parameter in Storage clause will reduce number of rows per block?
75.
What is meant by free extent?
76.
How will you force database to use particular rollback segment?
77.
How can we organize the tablespaces in Oracle database to have maximum performance?
78.
How will you swap objects into a different table space for an existing database?
79.
What is redo log buffer?
80.
What is meant by recursive hints?
81.
How can we plan storage for very large tables?
82.
How will you estimate the space required by a non-clustered tables?
83.
It is possible to use raw devices as data files and what are the advantages over file system files?
84.
What is a Control file?
85.
How will you monitor rollback segment status?
86.
How will you monitor the space allocation?
87.
Why query fails sometimes?
88.
How the space utilization takes place within rollback segments?
89.
How will you create multiple rollback segments in a database?
90.
What is a rollback segment entry?
91.
What is hit ratio?
92.
What are disadvantages of having raw devices?
93.
What is use of rollback segments in Oracle database?
94.
What is advantage of having disk shadowing / mirroring?
95.
How redo logs can be achieved?
96.
What is redo log file mirroring?
97.
How to implement the multiple control files for an existing database?
98.
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
99.
What is a Shared SQL pool?
100.
What is mean by Program Global Area (PGA)?
101.
List the factors that can affect the accuracy of the estimations?
102.
What are the different kind of export backups?
103.
What is cold backup? What are the elements of it?
104.
What is a logical backup?
105.
What is hot backup and how it can be taken?
106.
What is the use of FILE option in EXP command?
107.
What is the use of GRANT option in EXP command?
108.
What is the use of INDEXES option in EXP command?
109.
What is the use of ROWS option in EXP command?
110.
What is the use of PARFILE option in EXP command?
111.
What is the use of ANALYSE ( Ver 7) option in EXP command?
112.
What is the use of FULL option in EXP command?
113.
What is the use of OWNER option in EXP command?
114.
What is the use of TABLES option in EXP command?
115.
What is the use of RECORD LENGTH option in EXP command?
116.
What is the use of INCTYPE option in EXP command?
117.
What is the use of RECORD option in EXP command?
118.
What is the use of ROWS option in IMP command?
119.
What is the use of INDEXES option in IMP command?
120.
What is the use of GRANT option in IMP command?
121.
What is the use of SHOW option in IMP command?
122.
What is the use of FILE option in IMP command?
123.
What is use of LOG (Ver 7) option in EXP command?
124.
What is the significance of having storage clause?
125.
What is the functionality of SYSTEM table space?
126.
How does Space allocation table place within a block?
127.
What is the role of PCTFREE parameter is storage clause?
128.
What is the OPTIMAL parameter?
129.
What is a shared pool?
130.
What is mean by Program Global Area (PGA)?
131.
What is a data segment?
132.
What are the factors causing the reparsing of SQL statements in SGA?
133.
What is Database Buffers?
134.
What is dictionary cache?
135.
Which parameter in Storage clause will reduce number of rows per block?
136.
What is meant by free extent?
137.
How will you force database to use particular rollback segment?
138.
How can we organize the tablespaces in Oracle database to have maximum performance?
139.
How will you swap objects into a different table space for an existing database?
140.
What is redo log buffer?
141.
What is meant by recursive hints?
142.
How can we plan storage for very large tables?
143.
How will you estimate the space required by a non-clustered tables?
144.
It is possible to use raw devices as data files and what are the advantages over file system files?
145.
What is a Control file?
146.
How will you monitor rollback segment status?
147.
How will you monitor the space allocation?
148.
Why query fails sometimes?
149.
How the space utilization takes place within rollback segments?
150.
How will you create multiple rollback segments in a database?
151.
What is a rollback segment entry?
152.
What is hit ratio?
153.
What are disadvantages of having raw devices?
154.
What is use of rollback segments in Oracle database?
155.
What is advantage of having disk shadowing / mirroring?
156.
How redo logs can be achieved?
157.
What is redo log file mirroring?
158.
How to implement the multiple control files for an existing database?
159.
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
160.
What is a Shared SQL pool?
161.
What is mean by Program Global Area (PGA)?
162.
List the factors that can affect the accuracy of the estimations?
163.
What are the different kind of export backups?
164.
What is cold backup? What are the elements of it?
165.
What is a logical backup?
166.
What is hot backup and how it can be taken?
167.
What is the use of FILE option in EXP command?
168.
What is the use of GRANT option in EXP command?
169.
What is the use of INDEXES option in EXP command?
170.
What is the use of ROWS option in EXP command?
171.
What is the use of PARFILE option in EXP command?
172.
What is the use of ANALYSE ( Ver 7) option in EXP command?
173.
What is the use of FULL option in EXP command?
174.
What is the use of OWNER option in EXP command?
175.
What is the use of TABLES option in EXP command?
176.
What is the use of RECORD LENGTH option in EXP command?
177.
What is the use of INCTYPE option in EXP command?
178.
What is the use of RECORD option in EXP command?
179.
What is the use of ROWS option in IMP command?
180.
What is the use of INDEXES option in IMP command?
181.
What is the use of GRANT option in IMP command?
182.
What is the use of SHOW option in IMP command?
183.
What is the use of FILE option in IMP command?
184.
What is use of LOG (Ver 7) option in EXP command?
185.
What is the significance of having storage clause?
186.
What is the functionality of SYSTEM table space?
187.
How does Space allocation table place within a block?
188.
What is the role of PCTFREE parameter is storage clause?
189.
What is the OPTIMAL parameter?
190.
What is a shared pool?
191.
What is mean by Program Global Area (PGA)?
192.
What is a data segment?
193.
What are the factors causing the reparsing of SQL statements in SGA?
194.
What is Database Buffers?
195.
What is dictionary cache?
196.
Which parameter in Storage clause will reduce number of rows per block?
197.
What is meant by free extent?
198.
How will you force database to use particular rollback segment?
199.
How can we organize the tablespaces in Oracle database to have maximum performance?
200.
How will you swap objects into a different table space for an existing database?
201.
What is redo log buffer?
202.
What is meant by recursive hints?
203.
How can we plan storage for very large tables?
204.
How will you estimate the space required by a non-clustered tables?
205.
It is possible to use raw devices as data files and what are the advantages over file system files?
206.
What is a Control file?
207.
How will you monitor rollback segment status?
208.
How will you monitor the space allocation?
209.
Why query fails sometimes?
210.
How the space utilization takes place within rollback segments?
211.
How will you create multiple rollback segments in a database?
212.
What is a rollback segment entry?
213.
What is hit ratio?
214.
What are disadvantages of having raw devices?
215.
What is use of rollback segments in Oracle database?
216.
What is advantage of having disk shadowing / mirroring?
217.
How redo logs can be achieved?
218.
What is redo log file mirroring?
219.
How to implement the multiple control files for an existing database?
220.
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
221.
What is a Shared SQL pool?
222.
What is mean by Program Global Area (PGA)?
223.
List the factors that can affect the accuracy of the estimations?
224.
What are the different kind of export backups?
225.
What is cold backup? What are the elements of it?
226.
What is a logical backup?
227.
What is hot backup and how it can be taken?
228.
What is the use of FILE option in EXP command?
229.
What is the use of GRANT option in EXP command?
230.
What is the use of INDEXES option in EXP command?
231.
What is the use of ROWS option in EXP command?
232.
What is the use of PARFILE option in EXP command?
233.
What is the use of ANALYSE ( Ver 7) option in EXP command?
234.
What is the use of FULL option in EXP command?
235.
What is the use of OWNER option in EXP command?
236.
What is the use of TABLES option in EXP command?
237.
What is the use of RECORD LENGTH option in EXP command?
238.
What is the use of INCTYPE option in EXP command?
239.
What is the use of RECORD option in EXP command?
240.
What is the use of ROWS option in IMP command?
241.
What is the use of INDEXES option in IMP command?
242.
What is the use of GRANT option in IMP command?
243.
What is the use of SHOW option in IMP command?
244.
What is the use of FILE option in IMP command?
245.
What is use of LOG (Ver 7) option in EXP command?