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 28554

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

2 10817

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

3 8001

What is a join and explain different types of joins?

2 5641

Can you have a nested transaction?

1 3411

What is an extended stored procedure?

1 5584

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

1 4269

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

4 7810

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

Ramco,

2 8392

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?

2364

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

TCS,

16 60604

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

9 14247

What is normalization? Explain different levels of normalization?

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

8 62748

What is denormalization and when would you go for it?

NBP,

9 39025

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

Flextronics, Hexaware, SQL Star,

1 9876

Post New DB Development Questions

Un-Answered Questions { DB Development }

What are the main phases of database development?

923

How would you design a database for an online site, which would average a million hits a day?

953

Explain about query and reporting.

2033

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

1021

Explain about relational operator join?

985

Which four data types cannot be used as a return type from a user-defined function?

971

What are the three types of database design?

965

In which table collections errors are stored.

2344

How you can make a parameterized view?

961

What are data modelling techniques?

903

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

2110

Explain the process of the user request and data generating?

1044

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

2596

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1011

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

1977

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