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 28536

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

2 10806

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

3 7982

What is a join and explain different types of joins?

2 5633

Can you have a nested transaction?

1 3406

What is an extended stored procedure?

1 5576

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

1 4262

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

4 7792

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

Ramco,

2 8383

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 60534

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

9 14222

What is normalization? Explain different levels of normalization?

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

8 62712

What is denormalization and when would you go for it?

NBP,

9 39000

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

Flextronics, Hexaware, SQL Star,

1 9867

Post New DB Development Questions

Un-Answered Questions { DB Development }

How to use timestamp datatypes

1968

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

954

Explain the rollup operator?

997

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

964

How to read and create .LDC data files which are used by linguatic dictionary.

2476

explain detail about ftp in datastage?

2187

What are the constraints on severity level in raiseerror?

934

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

2588

Explain what a database is?

981

What is a database development?

906

Where is dbms used?

1014

What is dbms and its application?

944

What is an application role and explain a scenario when you would use one?

955

What are data modelling techniques?

899

What is dbms explain in brief?

956

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