Oracle Interview Questions !
1) What is a relational database management system?
2) What do you know about normalization? Explain in detail?
3) Explain the difference between a procedure and a function? What do you understand by those terms?
4) Explain about functional dependency and its relation with table design?
5) Explain the different normalization forms?
Remember how you answer shortens your technical interview you are trying to convince the interviewer that you are a suitable candidate for the job.
6) What are the different types of trigger and explain its various uses and functions?
7) Are truncate and delete commands same? If so why?
8) Compare and contrast between SQL and SQL server and explain its various functions?
9) What is a query and state the different types of queries and their uses?
10) Explain about your project and its relation the current job position you are applying to?
11) How different is MS Access and Oracle?
12) What is a cluster and non cluster index?
13) State the difference between a primary key and foreign key?
14) State all possible different index configurations a table can possibly have?
15) What is a cursor and what are the steps need to be taken?
If possible while answering this question try to explain him the various steps in an order.
16) Why do you use stored procedures and state some of its disadvantages?
17) State the various uses of DBCC command?
18) What is a collation and state the different types of collation sensitivity?
19) What are the uses of linked server and explain it in detail?
20) State and explain about the different types of data models?
21) State and explain about oracle instance?