a) What are views and what is their significance? How views are manag…
Previous year question for RDBMS.
Question
a) What are views and what is their significance? How views are managed in SQL, explain using an example? (10)
b) Explain hash join and complex join with a suitable example? (10)
- Year: 2018
- Subject: RDBMS
Related pages
More PYQs on Normalization Using Join Dependencies
- (A) Give a typical example for the 4th Normal Form and explain the importance of fourth normal form. (12) (B) Explain Join dependencies and the fifth normal fo…
- (A) What is multi-valued dependency? Discuss with example normalization with multi-valued dependency. (10) (B) Explain Hash join and complex join. (10)
- a) What is Merge Join? Discuss its implementation with a suitable example? (10) b) Explain query optimization? How it is implemented? (10)