CGI sybase devlopment question.

Hi All,

Interview was taken by Samantha and Mr. Amit both round were face to face on 7th Oct 2013

1st round of technical interview...


1)how to delete duplicate row from a tables
2)what is transaction log
3)what are locks
4)if there are two procedure trying to modify same set of table which causes deadlocks?how will you stop that?
5)what is difference between 12.5 and 15.0
6)what are identity and identity gap.
7)what is rollback trigger and rollback transaction

second round technical interview

1)--I want to create one junk file of 1 gb or 100 mb how will i create ?
#!/bin/ksh
size=$1
>file
while [[ `du -sm file` < "$size" ]]
do
echo "abc">>file
done
2)--what is dev null and dev 0

3)question were based on below table.

assumption- this is mutual fund table. when quantity is in -ve that means client has sold that many quantity of corresponding security type.

•        find out all clients which only sold out the fund.
• find all clients which sell as well as bought the fund.
• find total sales security wise before 13th