| Other DB Development Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 2 |
| What is the system function to get the current user's user
id? | | 2 |
| what is Normalization? | TCS | 6 |
| how will I find the duplicate rows count from employees
tablein oracle. | | 1 |
| What is a self join? Explain it with an example? | TCS | 6 |
| What is the difference between a primary index and a
secondary index? What is a duplicate data entry in an index?
Can a primary index contain duplicates? | IBM | 1 |
| What are the disadvantages of cursors? How can you avoid
cursors? | | 1 |
| Explain the general syntax for a SELECT statements covering
all the options. | | 2 |
| What is an extended stored procedure? | | 1 |
| What is a join and explain different types of joins? | | 1 |
| Given an employee table, how would you find out the second
highest salary? | | 4 |
| What is denormalization and when would you go for it? | NBP | 4 |
| What are cursors? Explain different types of cursors? | | 3 |
| How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables? | SQL-Star | 1 |
| Define candidate key, alternate key, composite key?
| IBM | 15 |
| What are defaults? Is there a column to which a default
can't be bound? | | 1 |
| What is normalization? Explain different levels of
normalization? | IBM | 3 |
| |
| For more DB Development Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
