Answer / s

Data types are DATE,TIME,TIMESTAMP

A few of the functions are
DATE
HOUR
MONTH
SECOND
TIME
TIMESTAMP

B37 abend during spufi?

1 Answers   IBM,

---

What is the size of a data page?

2 Answers   IBM,

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

Can we insert update delete in view?

1 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

What is the use of runstats in db2?

1 Answers  

---

Which component is responsible for db2 startup and shutdown?

1 Answers  

---