which SQL comment successfully removes uncommitted changes
from a DB2 database
A) rollback
B) delete
C) drop
D) decommit
Answers were Sorted based on User's Feedback
what is rebinding ?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Name some fields from SQLCA.
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
How to take backup of table in db2?
What is copy pending and check pending in db2?
What is the cascade rule and how does it relate to deletions made with a subselect?
Name some fields from SQLCA
what is the responsibility of the construction superintendent
How do you find the maximum value in a column in db2?
What is the use of runstats in db2?
How does a cursor work?