|
Question |
Rating |
View Answer |
|
What are some characteristics of columns that benefit from indexes?
|
|
View Answer |
|
70) How do you pull up a query which was previously saved in QMF ? � |
|
View Answer |
|
What is a composite index and how does it differ from a multiple index?
|
|
View Answer |
|
62) What is ACQUIRE/RELEASE in BIND? |
|
View Answer |
|
9. Can the OCCURS clause be at the 01 level? |
|
View Answer |
|
What techniques are used to retrieve data from more than one table in a single SQL statement?
|
|
View Answer |
|
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do? |
|
View Answer |
|
Can you use MAX on a CHAR column? |
|
View Answer |
|
Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement |
|
View Answer |
|
65) What are PACKAGES ? � |
|
View Answer |
|
What is a cursor? why should it be used? |
|
View Answer |
|
What is ALTER ? |
|
View Answer |
|
How to load data to a table?
|
|
View Answer |
|
What are the 4 environments which can access DB2 ? |
|
View Answer |
|
Will precompile of an DB2-COBOL program bomb, if DB2 is down? |
|
View Answer |
|
64) What happens to the PLAN if index used by it is dropped? |
|
View Answer |
|
There are two programs say A&B,A is only cobol program,B iscobol-db2 program, how to compile both programs?
|
|
View Answer |
|
How is the SUBSTR keyword used in sql?
|
|
View Answer |
|
6) What are aggregate functions? |
|
View Answer |
|
What is a clustered index?
|
|
View Answer |