Oracle Database Administration Interview Questions

 
1.
Explain database clusters?
2.
Explain What is a lookup table in database? where can we use these type of table?
3.
Explain Different types of table join?
4.
Explain When can hash cluster used?
5.
Explain What is an Oracle sequence?
6.
Explain What is an extent?
7.
Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
8.
Explain What is hash cluster?
9.
Explain What is a tablespace?
10.
Explain What is index cluster?
11.
Tell us Do you need a commit after DDL statements?
12.
What is the difference between indexes,views,synonyms?
13.
Explain What are the basic element of base configuration of an Oracle database?
14.
Explain What is ORA-1555?
15.
Explain How do we handle exceptions / errors in stored procedures?
16.
Explain Do a view contain data?
17.
Explain What are the different types of segments?
18.
Explain What does a control file contains?
19.
Explain What is a deadlock?
20.
What is uses of rollback segment?
21.
Explain some built-in functions that can be used in SQL queries?
22.
What is Parallel Server in Oracle?
23.
What are the types of synonyms in Oracle?
24.
Explain What is a database instance?
25.
Explain Can we decrease the Datafile size?
26.
Explain database clusters?
27.
Explain What is a lookup table in database? where can we use these type of table?
28.
Explain Different types of table join?
29.
Explain When can hash cluster used?
30.
Explain What is an Oracle sequence?
31.
Explain What is an extent?
32.
Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
33.
Explain What is hash cluster?
34.
Explain What is a tablespace?
35.
Explain What is index cluster?
36.
Tell us Do you need a commit after DDL statements?
37.
What is the difference between indexes,views,synonyms?
38.
Explain What are the basic element of base configuration of an Oracle database?
39.
Explain What is ORA-1555?
40.
Explain How do we handle exceptions / errors in stored procedures?
41.
Explain Do a view contain data?
42.
Explain What are the different types of segments?
43.
Explain What does a control file contains?
44.
Explain What is a deadlock?
45.
What is uses of rollback segment?
46.
Explain some built-in functions that can be used in SQL queries?
47.
What is Parallel Server in Oracle?
48.
What are the types of synonyms in Oracle?
49.
Explain What is a database instance?
50.
Explain Can we decrease the Datafile size?
51.
Explain database clusters?
52.
Explain What is a lookup table in database? where can we use these type of table?
53.
Explain Different types of table join?
54.
Explain When can hash cluster used?
55.
Explain What is an Oracle sequence?
56.
Explain What is an extent?
57.
Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
58.
Explain What is hash cluster?
59.
Explain What is a tablespace?
60.
Explain What is index cluster?
61.
Tell us Do you need a commit after DDL statements?
62.
What is the difference between indexes,views,synonyms?
63.
Explain What are the basic element of base configuration of an Oracle database?
64.
Explain What is ORA-1555?
65.
Explain How do we handle exceptions / errors in stored procedures?
66.
Explain Do a view contain data?
67.
Explain What are the different types of segments?
68.
Explain What does a control file contains?
69.
Explain What is a deadlock?
70.
What is uses of rollback segment?
71.
Explain some built-in functions that can be used in SQL queries?
72.
What is Parallel Server in Oracle?
73.
What are the types of synonyms in Oracle?
74.
Explain What is a database instance?
75.
Explain Can we decrease the Datafile size?
76.
Explain database clusters?
77.
Explain What is a lookup table in database? where can we use these type of table?
78.
Explain Different types of table join?
79.
Explain When can hash cluster used?
80.
Explain What is an Oracle sequence?
81.
Explain What is an extent?
82.
Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
83.
Explain What is hash cluster?
84.
Explain What is a tablespace?
85.
Explain What is index cluster?
86.
Tell us Do you need a commit after DDL statements?
87.
What is the difference between indexes,views,synonyms?
88.
Explain What are the basic element of base configuration of an Oracle database?
89.
Explain What is ORA-1555?
90.
Explain How do we handle exceptions / errors in stored procedures?
91.
Explain Do a view contain data?
92.
Explain What are the different types of segments?
93.
Explain What does a control file contains?
94.
Explain What is a deadlock?
95.
What is uses of rollback segment?
96.
Explain some built-in functions that can be used in SQL queries?
97.
What is Parallel Server in Oracle?
98.
What are the types of synonyms in Oracle?
99.
Explain What is a database instance?
100.
Explain Can we decrease the Datafile size?