|
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
|
|
a user defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.
In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.
|
View Answer
|
|
72) What is dynamic SQL ? �
|
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
|