DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 26142

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

2 9639

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

3 6560

What is a join and explain different types of joins?

2 4570

Can you have a nested transaction?

1 2447

What is an extended stored procedure?

1 4582

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

1 3375

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

4 5873

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

Ramco,

2 7192

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?

1968

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

TCS,

16 56341

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

9 11500

What is normalization? Explain different levels of normalization?

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

8 59618

What is denormalization and when would you go for it?

NBP,

9 36293

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

Flextronics, Hexaware, SQL Star,

1 9118


Post New DB Development Questions

Un-Answered Questions { DB Development }

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

557


Who are naive users?

577


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

557


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?

1968


Who are end users in dbms?

522






Explain about the hierarchical model of the database?

554


Explain about the storage and physical database design?

506


How is data stored in dbms?

499


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3346


What are the three basic rules which are to be followed for the relational model of the database?

533


I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2387


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

2025


What are the 18 schemas?

584


Explain about normal forms?

571


How to customize error conditions.

1675