|
Question |
Rating |
View Answer |
|
82) Give some example of statistics collected during RUNSTATS? |
|
View Answer |
|
3) How do you select a row using indexes in DB2? |
|
View Answer |
|
Give some example of statistics collected during RUNSTATS? |
|
View Answer |
|
96) If I have a view which is a join of two or more tables, can this view be updateable? � |
|
View Answer |
|
What is the purpose of the WHENEVER statement?
|
|
View Answer |
|
95) Are views updateable ? |
|
View Answer |
|
What is the use of VALUE function? |
|
View Answer |
|
1) How would you find out the total number of rows in a DB2 table? |
|
View Answer |
|
After retrieving the elements from production,how can do the testing before moving the changes to production. Whether we have to create the JCL for testing or it will automatically tested and compiled?
|
|
View Answer |
|
37) What are the contents of a DCLGEN? - |
|
View Answer |
|
106) What do you mean by NOT NULL? When will you use it? |
|
View Answer |
|
How many clustering indexes are pasing for a table?
|
|
View Answer |
|
What is diff b/w QMF & Spoofi?
|
|
View Answer |
|
What is the meaning of underscore ( ?_? ) in the LIKE statement? ? |
|
View Answer |
|
16) When do you use a LIKE statement? |
|
View Answer |
|
78) What does it mean if the null indicator has -1, 0, -2? � |
|
View Answer |
|
How do you select a row using indexes? ? |
|
View Answer |
|
What do you mean by NOT NULL WITH DEFAULT? When will you use it? |
|
View Answer |
|
When do you specify the isolation level? How? |
|
View Answer |
|
What are the various locks available? |
|
View Answer |