|
Question |
Rating |
View Answer |
|
Where do you specify them ? |
|
View Answer |
|
42) Name some fields from SQLCA. |
|
View Answer |
|
How does DB2 store NULL physically? |
|
View Answer |
|
a user defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.
In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows. |
|
View Answer |
|
What do you need to do before you do EXPLAIN? |
|
View Answer |
|
51) What is the difference between CS and RR isolation levels? |
|
View Answer |
|
What are difference between version control and debugging tools? |
|
View Answer |
|
69) How would you print the output of an SQL statement from SPUFI? � |
|
View Answer |
|
What is lock escalation? |
|
View Answer |
|
What is REORG? When is it used? |
|
View Answer |
|
103) What is a synonym ? |
|
View Answer |
|
87) What is CHECK PENDING ? |
|
View Answer |
|
What is a NULL value? What are the pros and cons of using NULLS?
|
|
View Answer |
|
84) What is IMAGECOPY ? � |
|
View Answer |
|
109) How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL. |
|
View Answer |
|
What is the difference between static and dynamic sql?
|
|
View Answer |
|
70) How do you pull up a query which was previously saved in QMF ? �
|
|
View Answer |
|
What is dynamic SQL? |
|
View Answer |
|
5) How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ? |
|
View Answer |
|
108) What are the disadvantages of using VARCHAR? |
|
View Answer |