a. Can be used in a number of places without restrictions as compared to stored procedures.
b. Code can be made less complex and easier to write.
c. Parameters can be passed to the function.
d. They can be used to create joins and also be sued in a select, where or case statement.
e. Simpler to invoke.
What are cursors? Explain different types of cursors? What are the disadvantages of cursors? How to avoid cursors?
What is the system function to get current user's user id?
What is a join and explain different types of joins?
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 inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are constraints? Explain different types of constraints?
What is a self join? Explain it with an example.?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What type of Index will get created after executing the above statement?
What is a transaction and what are ACID properties?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
