RA Tech interview questions

1st interview -- 1 hour 15 minutes -- Software Engineer 1. Rate yourself in programming 1-10 2. Rate yourself in database 1-10 3. Swapping without third variable 4. Given an array with thousand of record example {1,9,5,3,9,2,78,23,2,75,23,78 …..} tell me which number occur how many times. 5. Given a list filled with complete dictionary – now suppose you have given a word newspaper, so it will return all possible combinations output will be like – new, news, paper, newspaper 6. Design database of given scenerio 7. Normalization 8. Normalize data on a given database - 3nf 9. What is candidate key? 10. What is primary Key? 11. 2nd highest and 3rd highest salary query? 12. Join query.