|
Question |
Rating |
View Answer |
|
Can u see s9(4)comp3 data?
|
|
View Answer |
|
What are the various locking levels available? |
|
View Answer |
|
15) What is 'LIKE' used for in WHERE clause? What are the wildcard characters? � |
|
View Answer |
|
50) What are the isolation levels possible ? � |
|
View Answer |
|
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.) |
|
View Answer |
|
Can anyone tell me when do we need a COLLECTION? I know the concept of PLAN and PACKAGE, but unable to understand about COLLECTION.
|
|
View Answer |
|
Is DECLARE CURSOR executable? |
|
View Answer |
|
How do you insert a record with a nullable column? |
|
View Answer |
|
How does Db2 use multiple table indexes?
|
|
View Answer |
|
75) How does DB2 store NULL physically? |
|
View Answer |
|
24) How would you retrieve rows from a DB2 table in embedded SQL? � |
|
View Answer |
|
How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name? |
|
View Answer |
|
What happens to the PLAN if index used by it is dropped? |
|
View Answer |
|
What are PACKAGES ? ? |
|
View Answer |
|
What is low values and high values?
|
|
View Answer |
|
110) What is auditing? |
|
View Answer |
|
What are the disadvantages of PAGE level lock? |
|
View Answer |
|
7. What does the IS NUMERIC clause establish ? |
|
View Answer |
|
What is IMAGECOPY ? |
|
View Answer |
|
66) What are the advantages of using a PACKAGE? |
|
View Answer |