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
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
Given an employee table, how would you find out the second highest salary?9 8228
What is normalization? Explain different levels of normalization?8 54042
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?1 7581
How to replace not in with not exist?
How to read and create .LDC data files which are used by linguatic dictionary.
How to customize error conditions.
I have a few records all are same structures data, I want to store data in multiple targets how
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).
How to use timestamp datatypes
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?
How to generate OIDS
explain detail about ftp in datastage?
In which table collections errors are stored.
How to combine two function together?
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?
Write short notes on manual refreshes.
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
fact table and dimension table containg one to many relationship or many to one relastionship