Database Administration Interview Questions And Answers
Database Administration Frequently Asked Questions in various Database Administration Interviews asked by the interviewer. So learn Database Administration with the help of this Database Administration Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Database Administration Interview Question or answer by the comment feature available on the page.
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 What rule optimizations are possible in SQL query tuning?
16 ► Explain How do we handle exceptions / errors in stored procedures?
17 ► Explain Do a view contain data?
18 ► Explain What are the different types of segments?
19 ► Explain What does a control file contains?
20 ► Explain What is a deadlock?
21 ► What is uses of rollback segment?
22 ► Explain some built-in functions that can be used in SQL queries?
23 ► What is Parallel Server in Oracle?
24 ► What are the types of synonyms in Oracle?
25 ► Explain What is a database instance?
26 ► Explain Can we decrease the Datafile size?
- Ads By Google