|
Question |
Rating |
View Answer |
|
What are the isolation levels possible ? |
|
View Answer |
|
27) What happens when you say OPEN CURSOR? |
|
View Answer |
|
What is the index ,types of index ?
|
|
View Answer |
|
What is FREEPAGE and PCTFREE in TABLESPACE creation? |
|
View Answer |
|
69) How would you print the output of an SQL statement from SPUFI? � |
|
View Answer |
|
What are the advantages of using a PACKAGE? |
|
View Answer |
|
Is DECLARE TABLE in DCLGEN necessary? Why it used? |
|
View Answer |
|
12) What is the restriction on using UNION in embedded SQL? |
|
View Answer |
|
18) What do you accomplish by GROUP BY ... HAVING clause? � |
|
View Answer |
|
What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made.
|
|
View Answer |
|
What is a DB2 access path?
|
|
View Answer |
|
Can you display the index?
|
|
View Answer |
|
What is a DBRM, PLAN ? |
|
View Answer |
|
When can an insert of a new primary key value threaten referential integrity?
|
|
View Answer |
|
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 |
|
86) What is COPY PENDING status? |
|
View Answer |
|
93) What is sqlcode -811? |
|
View Answer |
|
What are Dedicated and Pool Threads?
|
|
View Answer |
|
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
|
|
View Answer |
|
What is data dictionary in DB2? and how is it handled?
|
|
View Answer |