Question { IBM, 17843 }

What is SDSF?

Answer

SDSF is System Display and search facility.
Harish is right.

Thanks;
Amita.

Question { Wipro, 7910 }

4. A DB2 application is bound with uncommitted Read
isolation level.It issues a request that retrieves 20 rows
out of 200000 in the table.
Which of the following descrbes the rows that are locked
as a result of this request?
a. None of the rows are locked.
B.The retrieved rows are locked.
C.The last row of the result set is locked.
D.The rows not previously updated by another application
are locked.

Answer

a. none of the rows are locked.

Thanks;
Amita Sharma.

Question { TCS, 7693 }

What is the difference between Perform para and perform
asaection in cobol?

Answer

Performing a section will cause all the paragraphs in that
para to be executed.

While, performing a paragraph will cause only that
particular paragraph to be exe cuted.

Thanks;
Amita.

Question { TCS, 11330 }

db2 query

I have one table with the following details.

SNO SNAME DOJ
------ -------------------- ----------
10 KRISH 2007-03-19
20 REDDY 2007-05-19
30 RRRRR 2007-05-19
40 BBBBB 2008-05-19
50 CCCCC 2009-05-19
60 JJJJJ 2009-05-19
70 JJJJJ 2004-05-19
i want the output in the following format:( no of students
joined in each year(no nedd to consider about month and
date)

year count
--------- ----------
2004 1
2007 3
2008 1
2009 2

Answer

Hi,

You can write the query as below:

select year(doj) as year, count(*) as count from emp_join
group by year(doj);


Let: table name is: emp_join

For furthur clarifications or queries please ask.

Thanks;
Amita Sharma.

Output:

year count

2004 1
2007 3
2008 1
2009 2