|
Question |
Rating |
View Answer |
|
90) How many clustering indexes can be defined for a table? |
|
View Answer |
|
What is CHECK PENDING ? |
|
View Answer |
|
7) Can you use MAX on a CHAR column? |
|
View Answer |
|
When do you use the IMAGECOPY? |
|
View Answer |
|
When do you use subroutines?
|
|
View Answer |
|
105) What do you mean by NOT NULL WITH DEFAULT? When will you use it? |
|
View Answer |
|
88) What is QUIESCE? |
|
View Answer |
|
If I have a view which is a join of two or more tables, can this view be updateable? |
|
View Answer |
|
34) What is the COBOL picture clause of the following DB2 data types: |
|
View Answer |
|
74) Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened? � |
|
View Answer |
|
What is auditing? |
|
View Answer |
|
Is it mandatory to use DCLGEN? If not, why would you use it at all? |
|
View Answer |
|
Give name some fields from SQLCA. |
|
View Answer |
|
What does the sqlcode of -818 pertain to? |
|
View Answer |
|
What is difference between Collection and Version?
|
|
View Answer |
|
What is deadlock?
|
|
View Answer |
|
What is normalization and what are the five normal forms?
|
|
View Answer |
|
30) When you COMMIT, is the cursor closed? - drona db2 interview questions |
|
View Answer |
|
61) What is a DBRM, PLAN ? |
|
View Answer |
|
101) What is filter factor? |
|
View Answer |