|
Question |
Rating |
View Answer |
|
What are the 2 sqlcodes that are returned? ? |
|
View Answer |
|
What is the difference between SYNONYM and ALIAS? |
|
View Answer |
|
68) What are the 2 sqlcodes that are returned? � |
|
View Answer |
|
54) What are the various locking levels available? |
|
View Answer |
|
40) Will precompile of an DB2-COBOL program bomb, if DB2 is down? |
|
View Answer |
|
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ? |
|
View Answer |
|
What are correlated subqueries? |
|
View Answer |
|
98) What is an inner join, and an outer join ? |
|
View Answer |
|
17) What is the meaning of underscore ( �_� ) in the LIKE statement? � |
|
View Answer |
|
What is isolation level?
|
|
View Answer |
|
107) When would you prefer to use VARCHAR? |
|
View Answer |
|
What is the diff bet plan,package,dbrm?
|
|
View Answer |
|
What is the SQL Communications Area and what are some of its key fields?
|
|
View Answer |
|
What do you accomplish by GROUP BY ... HAVING clause? ? |
|
View Answer |
|
When you COMMIT, is the cursor closed? |
|
View Answer |
|
Can I use LOCK TABLE on a view? |
|
View Answer |
|
31) How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only ) |
|
View Answer |
|
92) What is sqlcode -922 ? |
|
View Answer |
|
58) What are the various locks available? |
|
View Answer |
|
What is stored in tables under creator SYSIBM?
|
|
View Answer |