How would you design an object pool in java ?

1. http://stackoverflow.com/questions/1137118/does-this-basic-java-object-pool-work
2. http://www.javaworld.com/javaworld/jw-06-1998/jw-06-object-pool.html
3. http://sourcemaking.com/design_patterns/object_pool/java
4. The basic interface of the object pool should like this
5. public interface ObjectPool<T> {
       T borrowObject();
       void returnObject(T borrowed);
   }
   
6. http://commons.apache.org/pool/

DBMS Interview Questions

1. http://tuandao.info/html/career/SQL.pdf
2. http://www.techinterviews.com/sql-interview-questions-and-answers
3. create table branch
           (branch_name  char(15),
            branch_city  char(30) not null,
            assets  integer,
            primary key (branch_name))
4. insert into account
     values ('A-9732', 'Perryridge', 1200)
5. delete from account
6. select distinct branchname from loan
7. select all branchname from loan
8. Rename operation :
   select customer_name, borrower.loan_number as loan_id, amount
   from borrower, loan
   where borrower.loan_number = loan.loan_number
9. select distinct customer_name
     from    borrower, loan
     where borrower loan_number = loan.loan_number and
                 branch_name = 'Perryridge'
     order by customer_name
10. Aggregate functions 
11. select branch_name, count (distinct customer_name)
               from depositor, account
               where depositor.account_number = account.account_number
               group by branch_name
12. Attributes in select clause outside aggregate functions must appear in group by clause
13. Having clause
14. select branch_name, avg (balance)
               from account
               group by branch_name
               having avg (balance) > 1200
15. Predicates in the having clause are applied before forming groups and predicates in the where clause are applied before forming groups
16. sd
17. sd
18. as

• select avg (balance)
    from account  where branch_name = 'Perryridge'
• select count (distinct customer_name)
    from depositor

1. sd
   

Design Patterns

1. Decorator Pattern : This link contains all the reasons when to use and when not to use the decorator patterns and also comparisons with the GoF book.

SEDA Architecture

• http://sanjaydwivedi.blogspot.com/
• http://sanjaydwivedi.blogspot.com/2006/10/staged-event-driven-architecture-seda.html
• http://muratbuffalo.blogspot.com/2011/02/seda-architecture-for-well-conditioned.html
• http://www.codeproject.com/Articles/167917/Microsoft-Message-Queuing-A-Simple-Multithreaded-C
• http://www.ibm.com/developerworks/library/j-jtp0730/index.html

Tutorials to study

1. http://community.topcoder.com/tc?module=Static&d1=tutorials&d2=binarySearchRedBlack
2. http://letuskode.blogspot.in/

A comprehensive list of all array questions

1. http://www.geeksforgeeks.org/write-a-c-program-that-given-a-set-a-of-n-numbers-and-another-number-x-determines-whether-or-not-there-exist-two-elements-in-s-whose-sum-is-exactly-x/
2. http://www.geeksforgeeks.org/find-a-triplet-that-sum-to-a-given-value/
3. Also practice quicksort from any of the above links well.
4. http://www.geeksforgeeks.org/find-subarray-with-given-sum/
6. fg

Google Written Test in campus

http://www.geeksforgeeks.org/find-water-in-a-glass/ : solved this one
Question related to this is Pascal's triangle :
http://www.geeksforgeeks.org/pascal-triangle/ : try solving this one in leisure time