What are cursors? Explain different types of cursors?6 23625
What are the disadvantages of cursors? How can you avoid cursors?2 8455
Explain the general syntax for a SELECT statements covering all the options.3 4916
What is a join and explain different types of joins?2 3474
Can you have a nested transaction?1 1596
What is an extended stored procedure?1 3467
Can you instantiate a COM object by using T-SQL?1 2446
What is the system function to get the current user's user id?3 3880
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?1469
Given an employee table, how would you find out the second highest salary?9 8816
What is normalization? Explain different levels of normalization?8 55891
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?1 7962
Explain the rollup operator?
Explain about the relational database?
What are the key features of dbms?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Which four data types cannot be used as a return type from a user-defined function?
What is the maximum length of an extended property?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about the database management systems.
Explain about a primary key?
How can I detect whether a given connection is blocked?
Explain about xml databases?
How would you design a database for an online site, which would average a million hits a day?
What is an application role and explain a scenario when you would use one?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What is dbms and its application?