|
Related Questions |
View Answer |
|
71) Lot of updates have been done on a table due to which indexes have gone haywire. What do you do? �
|
View Answer
|
|
70) How do you pull up a query which was previously saved in QMF ? �
|
View Answer
|
|
69) How would you print the output of an SQL statement from SPUFI? �
|
View Answer
|
|
68) What are the 2 sqlcodes that are returned? �
|
View Answer
|
|
67) What is a collection?
|
View Answer
|
|
66) What are the advantages of using a PACKAGE?
|
View Answer
|
|
65) What are PACKAGES ? �
|
View Answer
|
|
64) What happens to the PLAN if index used by it is dropped?
|
View Answer
|
|
63) What else is there in the PLAN apart from the access path? �
|
View Answer
|
|
62) What is ACQUIRE/RELEASE in BIND?
|
View Answer
|
|
61) What is a DBRM, PLAN ?
|
View Answer
|
|
60) What is ALTER ? �
|
View Answer
|
|
59) Can I use LOCK TABLE on a view?
|
View Answer
|
|
59) Can I use LOCK TABLE on a view?
|
View Answer
|
|
58) What are the various locks available?
|
View Answer
|
|
57) What is lock escalation?
|
View Answer
|
|
56) What are the disadvantages of PAGE level lock? - RAMESH www.geocities.com/srcsinc
|
View Answer
|
|
55) How does DB2 determine what lock-size to use?
|
View Answer
|
|
54) What are the various locking levels available?
|
View Answer
|
|
53) When do you specify the isolation level? How?
|
View Answer
|