DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 22616

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

2 8139

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

3 4495




What is a join and explain different types of joins?

2 3191

Can you have a nested transaction?

1 1374

What is an extended stored procedure?

1 3192

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

1 2204

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

3 3502




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

Ramco,

2 5727

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?

1274

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

TCS,

16 49217

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

9 8228

What is normalization? Explain different levels of normalization?

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

8 54042

What is denormalization and when would you go for it?

NBP,

9 31193

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

SQL Star,

1 7581


Post New DB Development Questions






Un-Answered Questions { DB Development }

How to replace not in with not exist?

773


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

1348


How to customize error conditions.

1070


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

1467


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).

1066






How to use timestamp datatypes

881


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?

1274


How to generate OIDS

974


explain detail about ftp in datastage?

1082


In which table collections errors are stored.

1172


How to combine two function together?

1047


Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

1257


Write short notes on manual refreshes.

1697


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1115


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

1427