|
Related Questions |
View Answer |
|
How do you retrieve the data from a nullable column? ?
|
View Answer
|
|
How does DB2 store NULL physically?
|
View Answer
|
|
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?
|
View Answer
|
|
When is the access path determined for dynamic SQL?
|
View Answer
|
|
What is dynamic SQL?
|
View Answer
|
|
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
|
View Answer
|
|
How would you print the output of an SQL statement from SPUFI? ?
|
View Answer
|
|
What are the 2 sqlcodes that are returned? ?
|
View Answer
|
|
What is a collection?
|
View Answer
|
|
What are the advantages of using a PACKAGE?
|
View Answer
|
|
What are PACKAGES ? ?
|
View Answer
|
|
What happens to the PLAN if index used by it is dropped?
|
View Answer
|
|
What else is there in the PLAN apart from the access path? ?
|
View Answer
|
|
What is ACQUIRE/RELEASE in BIND?
|
View Answer
|
|
What is a DBRM, PLAN ?
|
View Answer
|
|
What is ALTER ?
|
View Answer
|
|
Can I use LOCK TABLE on a view?
|
View Answer
|
|
What are the various locks available?
|
View Answer
|
|
What is lock escalation?
|
View Answer
|
|
What are the disadvantages of PAGE level lock?
|
View Answer
|