Oracle Developer Interview Questions

 
1.
When can Hash Cluster used?
2.
Explain Database Link?
3.
What are the types of Database Links?
4.
What is Private Database Link?
5.
What is Public Database Link?
6.
What is Network Database link?
7.
What is Data Block?
8.
How to define Data Block size?
9.
What are the components of Physical database structure of Oracle Database?
10.
What are the components of Logical database structure of ORACLE database?
11.
What is Tablespace?
12.
What is SYSTEM tablespace and When is it Created?
13.
Explain the relationship among Database, Tablespace and Data file?
14.
What is schema?
15.
What are Schema Objects?
16.
Can a Tablespace hold objects from different Schemes?
17.
Explain Table?
18.
Explain View?
19.
Explain Can a View based on another View?
20.
Explain Do View contain Data?
21.
Explain What are the advantages of Views?
22.
What is Sequence?
23.
Explain a Synonym?
24.
Explain What are the type of Synonyms?
25.
Explain a Private Synonyms?
26.
What is a Public Synonyms?
27.
Explain What are synonyms used for?
28.
Explain an Index?
29.
Explain How are Indexes Update?
30.
Explain What are Clusters?
31.
What is cluster Key?
32.
What is Index Cluster?
33.
What is Hash Cluster?
34.
What is the maximum number of CHECK constraints that can be defined on a column?
35.
What are the Limitations of a CHECK Constraint?
36.
What is self-referential integrity constraint?
37.
What is Row Chaining?
38.
Explain an Extent?
39.
Explain a Segment?
40.
Explain What are the different type of Segments?
41.
Explain a Data Segment?
42.
Explain an Index Segment?
43.
What is Rollback Segment?
44.
Explain What are the uses of Rollback Segment?
45.
What is a Temporary Segment?
46.
What is Data File?
47.
Explain What are the Characteristics of Data Files?
48.
What is Redo Log?
49.
What is the function of Redo Log?
50.
What is the use of Redo Log Information?
51.
Explain What does a Control file Contain?
52.
Explain the use of Control File?
53.
What is a Data Dictionary?
54.
Explain an Integrity Constrains?
55.
What constitute an ORACLE Instance?
56.
What are the components of SGA?
57.
What do Database Buffers contain?
58.
When can Hash Cluster used?
59.
Explain Database Link?
60.
What are the types of Database Links?
61.
What is Private Database Link?
62.
What is Public Database Link?
63.
What is Network Database link?
64.
What is Data Block?
65.
How to define Data Block size?
66.
What are the components of Physical database structure of Oracle Database?
67.
What are the components of Logical database structure of ORACLE database?
68.
What is Tablespace?
69.
What is SYSTEM tablespace and When is it Created?
70.
Explain the relationship among Database, Tablespace and Data file?
71.
What is schema?
72.
What are Schema Objects?
73.
Can a Tablespace hold objects from different Schemes?
74.
Explain Table?
75.
Explain View?
76.
Explain Can a View based on another View?
77.
Explain Do View contain Data?
78.
Explain What are the advantages of Views?
79.
What is Sequence?
80.
Explain a Synonym?
81.
Explain What are the type of Synonyms?
82.
Explain a Private Synonyms?
83.
What is a Public Synonyms?
84.
Explain What are synonyms used for?
85.
Explain an Index?
86.
Explain How are Indexes Update?
87.
Explain What are Clusters?
88.
What is cluster Key?
89.
What is Index Cluster?
90.
What is Hash Cluster?
91.
What is the maximum number of CHECK constraints that can be defined on a column?
92.
What are the Limitations of a CHECK Constraint?
93.
What is self-referential integrity constraint?
94.
What is Row Chaining?
95.
Explain an Extent?
96.
Explain a Segment?
97.
Explain What are the different type of Segments?
98.
Explain a Data Segment?
99.
Explain an Index Segment?
100.
What is Rollback Segment?
101.
Explain What are the uses of Rollback Segment?
102.
What is a Temporary Segment?
103.
What is Data File?
104.
Explain What are the Characteristics of Data Files?
105.
What is Redo Log?
106.
What is the function of Redo Log?
107.
What is the use of Redo Log Information?
108.
Explain What does a Control file Contain?
109.
Explain the use of Control File?
110.
What is a Data Dictionary?
111.
Explain an Integrity Constrains?
112.
What constitute an ORACLE Instance?
113.
What is SGA?
114.
What are the components of SGA?
115.
What do Database Buffers contain?
116.
When can Hash Cluster used?
117.
Explain Database Link?
118.
What are the types of Database Links?
119.
What is Private Database Link?
120.
What is Public Database Link?
121.
What is Network Database link?
122.
What is Data Block?
123.
How to define Data Block size?
124.
What are the components of Physical database structure of Oracle Database?
125.
What are the components of Logical database structure of ORACLE database?
126.
What is Tablespace?
127.
What is SYSTEM tablespace and When is it Created?
128.
Explain the relationship among Database, Tablespace and Data file?
129.
What is schema?
130.
What are Schema Objects?
131.
Can a Tablespace hold objects from different Schemes?
132.
Explain Table?
133.
Explain View?
134.
Explain Can a View based on another View?
135.
Explain Do View contain Data?
136.
Explain What are the advantages of Views?
137.
What is Sequence?
138.
Explain a Synonym?
139.
Explain What are the type of Synonyms?
140.
Explain a Private Synonyms?
141.
What is a Public Synonyms?
142.
Explain What are synonyms used for?
143.
Explain an Index?
144.
Explain How are Indexes Update?
145.
Explain What are Clusters?
146.
What is cluster Key?
147.
What is Index Cluster?
148.
What is Hash Cluster?
149.
What is the maximum number of CHECK constraints that can be defined on a column?
150.
What are the Limitations of a CHECK Constraint?
151.
What is self-referential integrity constraint?
152.
What is Row Chaining?
153.
Explain an Extent?
154.
Explain a Segment?
155.
Explain What are the different type of Segments?
156.
Explain a Data Segment?
157.
Explain an Index Segment?
158.
What is Rollback Segment?
159.
Explain What are the uses of Rollback Segment?
160.
What is a Temporary Segment?
161.
What is Data File?
162.
Explain What are the Characteristics of Data Files?
163.
What is Redo Log?
164.
What is the function of Redo Log?
165.
What is the use of Redo Log Information?
166.
Explain What does a Control file Contain?
167.
Explain the use of Control File?
168.
What is a Data Dictionary?
169.
Explain an Integrity Constrains?
170.
What constitute an ORACLE Instance?
171.
What is SGA?
172.
What are the components of SGA?
173.
What do Database Buffers contain?
174.
When can Hash Cluster used?
175.
Explain Database Link?
176.
What are the types of Database Links?
177.
What is Private Database Link?
178.
What is Public Database Link?
179.
What is Network Database link?
180.
What is Data Block?
181.
How to define Data Block size?
182.
What are the components of Physical database structure of Oracle Database?
183.
What are the components of Logical database structure of ORACLE database?
184.
What is Tablespace?
185.
What is SYSTEM tablespace and When is it Created?
186.
Explain the relationship among Database, Tablespace and Data file?
187.
What is schema?
188.
What are Schema Objects?
189.
Can a Tablespace hold objects from different Schemes?
190.
Explain Table?
191.
Explain View?
192.
Explain Can a View based on another View?
193.
Explain Do View contain Data?
194.
Explain What are the advantages of Views?
195.
What is Sequence?
196.
Explain a Synonym?
197.
Explain What are the type of Synonyms?
198.
Explain a Private Synonyms?
199.
What is a Public Synonyms?
200.
Explain What are synonyms used for?
201.
Explain an Index?
202.
Explain How are Indexes Update?
203.
Explain What are Clusters?
204.
What is cluster Key?
205.
What is Index Cluster?
206.
What is Hash Cluster?
207.
What is the maximum number of CHECK constraints that can be defined on a column?
208.
What are the Limitations of a CHECK Constraint?
209.
What is self-referential integrity constraint?
210.
What is Row Chaining?
211.
Explain an Extent?
212.
Explain a Segment?
213.
Explain What are the different type of Segments?
214.
Explain a Data Segment?
215.
Explain an Index Segment?
216.
What is Rollback Segment?
217.
Explain What are the uses of Rollback Segment?
218.
What is a Temporary Segment?
219.
What is Data File?
220.
Explain What are the Characteristics of Data Files?
221.
What is Redo Log?
222.
What is the function of Redo Log?
223.
What is the use of Redo Log Information?
224.
Explain What does a Control file Contain?
225.
Explain the use of Control File?
226.
What is a Data Dictionary?
227.
Explain an Integrity Constrains?
228.
What constitute an ORACLE Instance?
229.
What is SGA?
230.
What are the components of SGA?
231.
What do Database Buffers contain?