What action db2 takes when a program aborts in the middle of a transaction?
What is deadlock in db2?
What is pagespace?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What is alias in db2?
List down the types of triggers in the db2 database?
What is an asychronous write?
What will the FREE command do to a plan?
What is normalization and what are the five normal forms?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
Once you create a view, where would information about the view be stored?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
Explain db2.