dbms Questions bank

dbms Questions bank - QUESTION BANK OF SUBJECT: DATABASE...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
QUESTION BANK OF SUBJECT: DATABASE SYSTEM Computer Engineering Class:S.E Div:A Prepared by:Anand Khandare 1. What is a clustered index? 2. What is the difference between @@identity and SCOPE_IDENTITY()? 3. what is the uses of indexes?explain about it? 4. what is the difference between oracle,sql and sql server 5. Difference between Store Procedure and Trigger 6. What is the advantage to use trigger in your PL? 7. how to find second maximum value from a table? 8. How to display duplicate rows in a table? 9. WHAT OPERATOR PERFORMS PATTERN MATCHING? 10 .Difference between a equijoin and a union 11 What is database? 12. Difference between VARCHAR and VARCHAR2? 13. What is difference between DBMS and RDBMS? 14. What is the advantage to use trigger in your PL? 15. What is Materialized View? 16.Explain the structure of DBMS 17. Explain insertion in B+ tree 18. Explain validation based protocol 19Explain following terms a.Division b.Projection c.Rename d.Join 20.Explain view in database 21.Draw E-R diagram for Banking enterprise
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Page1 / 3

dbms Questions bank - QUESTION BANK OF SUBJECT: DATABASE...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online