|
Question |
Rating |
View Answer |
|
How to see the status of the table?
|
|
View Answer |
|
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
|
|
View Answer |
|
How would you find out the total number of rows in a table? ? |
|
View Answer |
|
What is RUNSTATS? |
|
View Answer |
|
What is the picture clause of the null indicator variable? ? |
|
View Answer |
|
21) Why SELECT * is not preferred in embedded SQL programs? |
|
View Answer |
|
What is severity one error in production support?
|
|
View Answer |
|
What is a LIKE table and how is it created?
|
|
View Answer |
|
80) What is RUNSTATS? � |
|
View Answer |
|
20) What is the result of this query if no rows are selected: |
|
View Answer |
|
85) When do you use the IMAGECOPY? � |
|
View Answer |
|
What is EXPLAIN? ? |
|
View Answer |
|
In terms of DB2 indexing, what is the root page?
|
|
View Answer |
|
32) Give the COBOL definition of a VARCHAR field. |
|
View Answer |
|
In the WHERE clause what is BETWEEN and IN? |
|
View Answer |
|
After bind i how can we run a cobol-db2 program?
|
|
View Answer |
|
10) What is the use of VALUE function? |
|
View Answer |
|
What is COPY PENDING status? |
|
View Answer |
|
99) What is FREEPAGE and PCTFREE in TABLESPACE creation? |
|
View Answer |
|
What is the self-referencing constraint?
|
|
View Answer |