Oracle SQL Interview Questions
These are some of the questions based on databases. These questions cover oracle and SQL questions. Preparing for the interview has to be much planned approach and we hope that you get benefited by some of the questions described here: -
1) What is a relational database management system?
When answering these types of questions you need to answer them in a very detailed manner because everyone in your group can answer them without any difficulty. There should be difference between your approach and the other candidates. Interview candidate should try to present all the information he has in a very detailed and step by step manner. A professional approach should be present.
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?
22) Explain about achiever in SQL?
23) What are the different Pseudo commands? Explain in general?
24) State some uses of redo log files?
These are some of the most important questions and there are chances of it being asked in an interview which is: -
1) Explain what you understand of a primary key and a unique key and explain the differences between them?
2) Explain about the commands Truncate and Delete?
3) Which operating system you are comfortable to use for databases?
4) Do you like command language or GUI?
5) State and explain some of the properties of Sub-Query?
6) What are the different types of user defined functions you can create?
7) What do you understand by log shipping explain the process?
8) State and explain the different types of replication?
9) Explain the cases or situations where you use de-normalization?
No comments:
Post a Comment