Answer / s

Skeleton cursor table contains the bound plan.

Answer / vat

Contains information about access paths and the internal
form of the SQL for an application plan. Entries in this
table are made when a plan is bound (BIND PLAN) and deleted
when a plan is freed (FREE PLAN). This table is also loaded
into memory at execution time

what is the responsibility of the construction superintendent

0 Answers   Almco,

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

---

Is schema the same as database?

0 Answers  

---

What is DCLGEN ?

2 Answers  

---

What is the maximum size of varchar data type in db2?

0 Answers  

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---