«
»

CapitalIQ Interview questions

1. How are databases stored internally ?

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.

Tags: ,

This entry was posted on Monday, May 11th, 2009 at 7:27 pm and is filed under Articles. You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.

Did You Enjoy This Post?

Subscribe to our blog through our RSS feed or email to receive updates on more posts like this.post on your favourite social networking or media site to let others know about this post. Help us generate more buzz by submitting/voting for this post with the following buttons.

Leave a Reply











request new questions/article: send email to freequestionbank at gmail dot com