CapitalIQ : CapitalIQ Interview questions, Interview questions For CapitalIQ
2. Can you think of any improvements to the storage of databases
3. What is indexing in databases and how does it help ?
4. Differences between search engine index and database index ?
5. What is paging in operating system ?
6. Explain the difference in different types of pagings in different situations – Constraints on the implementation
7. How can you implement paging in databases ?
8. What happens when you search for a value in a database ?
9. What are the different types of cache available .. explained about L1 L2 and onchip offchip caches and their access times and cost
10. What is an RDBMS ? What are the differences or relation between RDBMS and DBMS ?
11. What are the different types of joins in a database. Explained every join[Natural,Inner outer etc ., ] with examples.
