DB Development Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Development Interview Questions

Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 28794

What are the disadvantages of cursors? How can you avoid cursors?

2 10942

Explain the general syntax for a SELECT statements covering all the options.

3 8139

What is a join and explain different types of joins?

2 5741

Can you have a nested transaction?

1 3500

What is an extended stored procedure?

1 5680

Can you instantiate a COM object by using T-SQL?

1 4348

What is the system function to get the current user's user id?

4 8024

What are triggers? How many triggers you can have on a table?

Ramco,

2 8498

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2411

What is a self join? Explain it with an example?

TCS,

16 61107

Given an employee table, how would you find out the second highest salary?

9 14501

What is normalization? Explain different levels of normalization?

CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

8 63053

What is denormalization and when would you go for it?

NBP,

9 39313

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Flextronics, Hexaware, SQL Star,

1 9960

Post New DB Development Questions

Un-Answered Questions { DB Development }

fact table and dimension table containg one to many relationship or many to one relastionship

2490

Explain about relational database management systems?

958

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2154

Explain about the hierarchical model of the database?

1106

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2022

How to customize error conditions.

2139

What is the physical representation for a many-to-many relationship?

1065

How you can make a parameterized view?

1002

What is the maximum length of an extended property?

980

What is dbms and its application?

996

What is the database development process?

1209

What is normalization? Explain different levels of normalization?

63053

What is data modeling with example?

978

I have a few records all are same structures data, I want to store data in multiple targets how

2641

What are the three types of database design?

1019

For More Un-Answered { DB Development } Questions Click Here