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.

3 comments:

  1. please do mention about the job profile applied for ..

    ReplyDelete
  2. Hi guys, Here is the simple website where you can find the latest interview

    questions and answer and also you can post there question for better

    solution.
    quizsolution.in
    question answer
    post question
    latest interveiw

    questions

    basic tutorials

    ReplyDelete
  3. Nice Site I love your Blog concept,Its creative .

    EmmyTechBlog

    ReplyDelete