Answered Questions

  • Oct 02 2007
    07:47 PM
    2601
    4

    TCS Database Questions
    • sowjanya

    1. What are the different types of joins? 2. Explain normalization with examples. 3. What cursor type do you use to retrieve multiple record sets? 4. Difference between a "where" clause and a "having" clause 5. What is the difference between "procedure" and "function"? 6. How will you copy the structure of a table without copying the data? 7. How to find out the database name from SQL*PLUS command...

    arif_h_j

    • May 24th, 2008

    there are 5 ways to normalize the database in order to make complex data structure into simpler form. 1NF- removing duplicate groups and multivalued entries 2NF-removing functional dependencies a...

    arif_h_j

    • May 24th, 2008

    there are 5 ways to normalize the database in order to make complex data structure into simpler form. 1NF- removing duplicate groups and multivalued entries2NF-removing functional dependencies and cre...