|
Question |
Rating |
View Answer |
|
What is the result of this query if no rows are selected: |
|
View Answer |
|
What else is there in the PLAN apart from the access path? ? |
|
View Answer |
|
What is QUIESCE? |
|
View Answer |
|
How to know other person job status?
|
|
View Answer |
|
29) Can you have more than one cursor open at any one time in a program ? � |
|
View Answer |
|
77) What is the picture clause of the null indicator variable? � |
|
View Answer |
|
55) How does DB2 determine what lock-size to use? |
|
View Answer |
|
Where would you specify the DECLARE CURSOR statement? ? |
|
View Answer |
|
13) In the WHERE clause what is BETWEEN and IN? � |
|
View Answer |
|
Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project? |
|
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 |
|
How do you retrieve the data from a nullable column? ? |
|
View Answer |
|
23) What is a cursor? why should it be used? � |
|
View Answer |
|
What is an inner join, and an outer join ? |
|
View Answer |
|
What are delete-connected tables?
|
|
View Answer |
|
What is cursor stability?
|
|
View Answer |
|
File contains 5 records say D,E,F,C,A-I want to copy D and A records only by using file-aid?
|
|
View Answer |
|
How does DB2 determine what lock-size to use? |
|
View Answer |
|
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
|
|
View Answer |
|
How to Repair the table?
|
|
View Answer |