|
Question |
Rating |
View Answer |
|
What is DCLGEN?
|
|
View Answer |
|
What is DCLGEN ? |
|
View Answer |
|
What are the three DB2 date and time data types and their associated functions?
|
|
View Answer |
|
When do you use a LIKE statement? |
|
View Answer |
|
83) What is REORG? When is it used? |
|
View Answer |
|
What is sqlcode -811? |
|
View Answer |
|
Commenly facing errors?
|
|
View Answer |
|
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP? |
|
View Answer |
|
59) Can I use LOCK TABLE on a view? |
|
View Answer |
|
47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? � |
|
View Answer |
|
How many columns maximum can be created in a table of a inner table of the subquerry
|
|
View Answer |
|
What is a precompiler?
|
|
View Answer |
|
How is a typical DB2 batch pgm executed ? |
|
View Answer |
|
What is the difference between IN subselects and EXISTS subselect?
|
|
View Answer |
|
100) What are simple, segmented and partitioned table spaces ? |
|
View Answer |
|
What is a packed decimal..?
|
|
View Answer |
|
What are foreign keys?
|
|
View Answer |
|
22) What are the issues related with correlated subqueries? �
??? |
|
View Answer |
|
57) What is lock escalation? |
|
View Answer |
|
72) What is dynamic SQL ? � |
|
View Answer |