Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 24536

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

2 8884

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

3 5436

What is a join and explain different types of joins?

2 3870

Can you have a nested transaction?

1 1928

What is an extended stored procedure?

1 3899

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

1 2772

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

3 4431

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

Ramco,

2 6440

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?

1678

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

TCS,

16 53064

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

9 9733

What is normalization? Explain different levels of normalization?

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

8 57305

What is denormalization and when would you go for it?

NBP,

9 34136

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

Flextronics, Hexaware, SQL Star,

1 8363


Post New DB Development Questions






Un-Answered Questions { DB Development }

What are the types of database model?

231


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

1366


Explain about a primary key?

266


How to combine two function together?

1364


How is data stored in dbms?

223






Explain about xml databases?

283


Explain about the storage and physical database design?

238


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1402


Explain the process of the user request and data generating?

278


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?

271


Explain about normal forms?

281


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

254


State the acid rules?

294


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

255


What is DB Development software?

1304