B.Sc. CSIT Old Question Collection: Advanced Database – 8th Semester
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2069
Attempt all the questions.
1.Explain the following terms:
- Data mining
- ECA model
- Spatial database
- Specialization and generalization in an ERR model
- XML and HTML
- GIS
2. How can you convert an ERR design to relational design? Discuss with suitable example.
3. What is OID? How persistent objects are maintained in OO Database?
4. Discuss the relative advantages of centralized and distributed database.
5. Describe different implementation issues with object relational database system.
6. Discuss the different techniques for executing equijoin of two files located at different sites. What main factors affect the cost of data transfer?
7. Differentiate between attributes and elements in XML? List some of the important attributes used in specifying elements in XML schema.
8. Distinguish object-oriented database and object relational databases.
9. What is a data warehouse? How does it differ from a database?
10. Explain mobile computing architecture with suitable diagram
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2071
1.Explain the following terms:
- Data Warehouse
- Distribution Transparency
- X Query
- Distribution transaction
- Knowledge base
- Classification and clustering
2.Distinguish multiple inheritance and selective inheritance in OO concepts.
3.Define state of an object. Distinguish between persistent and transient objects.
4.Discuss how time is represented in temporal databases and compare the different time dimensions.
5.What is the difference between structured and unstructured complex object? Differentiate identical versus equal objects with examples.
6.What are the advantages and disadvantages of OODBMS?
7.What are the differences and similarities between objects and literals in the ODMG object model?
8. Describe the main reasons for the potential advantage for distributed database. What additional functions does it have over centralized DBMS?
9. Describe the characteristics of mobile computing environment in detail.
10. Differentiate between XML schema and XML DTD with suitable example.
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2072
1.Explain the following terms:
- Database performance tuning
- UML
- Subclass vs Superclass
- X Query
- Calendars
- Active Database
2. What are query optimization techniques? Explain.
3. Differentiate between specialization and generalization with example.
4. How do single inheritance, multiple inheritance and selective inheritance differ?
5. What are the differences between structured and unstructured complex objects? Explain.
6. What are the object relational features that have been included in SQL-99?
7. Discuss how time is represented in temporal database and compare different time dimensions.
8. What are the difference and similarities between objects and literals in the ODMG Object Model?
9. Describe multimedia database and what are the different types of multimedia data that are available in current systems?
10. Explain XML schema and XML DTD.
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2073
Attempt any SIX questions:(6 x 10 = 60)
- Explain the OST model and its applications.
2. Explain the history of IPv and adressing of IPv.
3. Explain the ICMP error and also explain explain the information message types.
4. Explain the security techniques and QOS paradigms.
5. Explain the OSPF for IPv6.
6. Differentiate between automatic tunneling and configured tunneling.
7. What are the migration strategies from IPv4 to IPv6.
8.Explain the process of IPv6 Network configuration in Linux.
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2074
Attempt all the questions.
1. Explain the following terms:
- Data replication
- UMI
- SOL: 2003
- Xpath
- SOAP
- Clustering
2. What is mobile computing? Explain its architecture.
3. Explain the process of EER to relational mapping with example.
4. Discuss the concept of encapsulation, and tell how it is used to create abstract data types.
5. What are the differences between structured and unstructured complex objects ? Explain
6. What is temporal database? Explain the terms date, time, timestamp, interval and period.
7. What is data warehouse? Explain the architecture for the functionality of data warehouse.
8. What is multimedia database? What are the nature of multimedia database and applications?
9. What is data mining? Discuss association rule mining with example.
10. What is GIS? What are GIS data operations?
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2075
Attempt all questions. (10 x 60=60)
1. How do you increase performance of the database? Explain any one database performance tuning technique with example. (2+4)
2. What is query processing? How is it different from query optimization? Discuss heuristic query optimization.(1+2+3)
3. What are the benefits of using distributed databases? Discuss different types of distributed database systems. (3+3)
4. What are the benefits of using object oriented databases over relational databases? Discuss different type of constructors used in object oriented databases. (2+4)
5. Discuss different implementation issues related with object relational database. (6)
6. Define GIS. Discuss different data modeling and representation for GIS data. (1+5)
7. Define multimedia database. Discuss benefits of multimedia databases. How do you query image database? (1+2+3)
8. Discuss data warehouse and its functionality. Discuss association rule mining with example. (3+3)
9. What is web service? Discuss SOAP in detail. (2+4)
10. Write short notes on:(2×3)
- Integrity constraint
- Mobile database
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2076
Attempt all questions. (10×6=60)
1. What is query processing? How is it different from query optimization? Discuss cost estimation for relational algebra expressions.
2. What is data fragmentation? Discuss horizontal and vertical fragmentation in detail.
3. Why do we need extended ER modeling? Discuss class/subclass relationship with example.
4. How do object relational database support multi-valued and composite attributes? Discuss with example.
5. What are the uses of active database? Discuss active database with example.
6. Discuss mobile computing architecture. Discuss mobile data management in detail.
7. Why do we need temporal database? Discuss valid time, transaction time and bi-temporal relations.
8. Discuss benefits and applications of data mining. How is classification different from clustering?
9. What is web service? Discuss SOAP in detail.
10. Write short notes on: Deductive database ODMG.
B.Sc. CSIT 8th Semester Old Question Collection: Advanced Database 2077
Attempt all questions.(10 x 6 = 60)
1. Discuss query optimization with suitable example. What is the importance of query optimization in database? (4 + 2)
2.Discuss various type constructors used in object-oriented database. How are they used to create complex objects?(4+2)
3. What is complex object? What is the difference between structured and unstructured complex objects?(1+5)
4. Define object relational database. Discuss different types of knowledge discovered during data mining.(1+5)
5.What is active database ? Discuss generalized mode for active databases?(2+4)
6. Discuss how time is represented in temporal databases and compare the different time dimensions.(3+3)+
7. What is data warehouse ? How does it differ from a databases ?(2+4)
8. What is mobile database? Discuss mobile computing architecture in detail.(1+5)
9.How can you convert an EER design to a relational design? Discuss with suitable example.(6)
Model question of Advance database
1. Explain the following terms: a. Spatial database
- Spatial Database
- ECA model
- Federated DBMS
- Well-formed and valid XML document e. GIS
- Classification and clustering
2. How does a category differ from a regular shared subclass? What is a category used for? Illustrate your answer with suitable examples.
OR
Describe the steps of the algorithm for object database design by EER-to-OO mapping.
3. What is the difference between persistent and transient objects? How persistence is handled in typical OO database systems?
4. Describe different implementation issues with object relational database system.
5. Discuss the different technique for executing an equijoin of two files located at different sites. What main factors affect the cost of data transfer?
OR
What are the main difference between designing a relational database and an object database?
6. Differentiate between attributes and elements in XML? List some of the important attributes used in specifying elements in XML schema.
OR
What is the difference between structured and unstructured complex object? Differentiate identical versus equal objects with examples.
7. Explain mobile computing architecture with suitable diagram.
8. What are the difference and similarities between objects and literals in the ODMG Object Model?
9. What is a data warehouse? How does it differ from a database?
OR
Describe multimedia database and what are the different types of multimedia data that are available in current systems?
10. Describe the main reasons for and potential advantages for distributed database. What additional functions does it have over centralized DBMS?
