db2 questions

karthi_ind · Posted: Tue Jul 27, 2004 7:19 pm

hi to all

1) if NOT NULL WITH DEFAULT is specified for Date, Time and Timestamp
field, what will be the default value if we left blank ?

2) Give 2 tables T1 and T2

T1 T2
A 1
B 2
3
u make a query
SELECT * FROM T1,T2
what is the no. of rows that are fetched from this query ?

3) Who is the database manager of db2?

4) Runtime supervisor, buffer manager (function)

bye

karth G.

superk · Posted: Tue Jul 27, 2004 7:39 pm

Are you writing a book or something?

You seem to ask an awful lot of questions and yet never seem to provide answers.

ashwinjeerigi · New User Joined: 20 Jun 2004 Posts: 12 Location: BANGALORE

2. 6 rows are displayed. It is a cartesian product.

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

Kevin,

If this guy spent as much time to become a good pgmr as he does trying to pass an interview, he'd pass an interview.

Regards, Jack.

karthi_ind · Posted: Wed Jul 28, 2004 4:31 pm

hi

plz answer my questions. i need it for intv.

bye

RamKumar · New User Joined: 11 Aug 2004 Posts: 3

1) ans : insertion date and time information

muthukumar · New User Joined: 24 Mar 2004 Posts: 29

Hi Karthi,

1) if not null with Default is specified for Date time and timestampt the DATE and Time at the time of LOAD or INSERT or Update will be updated

2) for Select * from T1,T2
if T1 has 3 rows and T2 has 2 rows the query will result in 6 rows

thunder · New User Joined: 03 Sep 2004 Posts: 3