CS8071 Advanced Topics on Databases MCQ for Anna University Online Exams


Download MCQ for CS8071 Advanced Topics on Databases


SANFOUNDRY REFERENCE: 

UNIT I PARALLEL AND DISTRIBUTED DATABASES

1.1 Database System Architectures: Centralized and Client-Server Architectures 

https://www.sanfoundry.com/software-engg-mcqs-application-architectures/

1.2  Server System Architectures 

https://www.sanfoundry.com/software-engg-mcqs-application-architectures/

1.3  Parallel Systems- Distributed Systems 

https://www.sanfoundry.com/operating-system-questions-answers-distributed-operating-system/

1.4  Parallel Databases: I/O Parallelism 

1.5  Inter and Intra Query Parallelism 

https://www.sanfoundry.com/computer-fundamentals-problems/

1.6  Inter and Intra operation Parallelism 

https://www.exploredatabase.com/2020/04/mcq-on-distributed-and-parallel-database-concepts.html

1.7  Design of Parallel SystemsDistributed Database Concepts - Distributed Data Storage 

1.8  Distributed Transactions 

1.9  Commit Protocols 

https://www.sanfoundry.com/database-mcqs-transactions/

1.10  Concurrency Control 

https://www.sanfoundry.com/rdbms-questions-answers-lock-based-protocols/

1.11  Distributed Query Processing 

https://www.sanfoundry.com/database-mcqs-query-processing/

UNIT II OBJECT AND OBJECT RELATIONAL DATABASES

2.1 Concepts for Object Databases: Object Identity 

https://www.sanfoundry.com/object-oriented-programming-questions-answers-mcqs/

2.2  Object structure 

2.3  Type Constructors 

https://www.sanfoundry.com/object-oriented-programming-questions-answers-constructors/

2.4  Encapsulation of Operations 

https://www.sanfoundry.com/object-oriented-programming-questions-answers-encapsulation/

2.5  Methods 

2.6  Persistence 

https://www.sanfoundry.com/spring-questions-answers-orm-frameworks/

2.7  Type and Class Hierarchies 

https://www.sanfoundry.com/c-plus-plus-programming-questions-answers-class-hierarchies/

2.8  Inheritance 

https://www.sanfoundry.com/java-mcqs-inheritance/

2.9  Complex Objects 

2.10  Object Database Standards, Languages and Design: ODMG Model 

https://www.sanfoundry.com/object-oriented-system-design-mcqs-object-model-foundation/

2.11  ODL

2.12  OQL 

https://www.sanfoundry.com/oracle-sql-mcqs-structured-query-language/

2.13  Object Relational and Extended 

https://www.sanfoundry.com/object-oriented-system-design-mcqs-object-model-foundation/

2.14  Relational Systems: Object Relational features in SQL/Oracle 

https://www.sanfoundry.com/rdbms-multiple-choice-questions-answers/

2.15  Case Studies.

https://www.sanfoundry.com/software-engg-mcqs-using-case-tools/

UNIT III INTELLIGENT DATABASES

3.1 Active Databases: Syntax and Semantics (Starburst, Oracle, DB2)- Taxonomy- Applications-Design Principles for Active Rules

3.2 Temporal Databases: Overview of Temporal Databases- TSQL2

https://www.sanfoundry.com/database-mcqs-query-processing/

3.3 Deductive Databases: Logic of Query Languages 

https://www.sanfoundry.com/database-mcqs-query-processing/

3.4 Datalog- Recursive Rules-Syntax and Semantics of Datalog Languages

https://www.sanfoundry.com/c-questions-answers-recursion/

3.5 Implementation of Rules and Recursion- Recursive Queries in SQL

https://www.sanfoundry.com/data-structure-questions-answers-recursion/

3.6 Spatial Databases- Spatial Data Types- Spatial Relationships

3.7 Spatial Data Structures-Spatial Access Methods

3.8 Spatial DB Implementation.

https://www.sanfoundry.com/mysql-questions-answers-spatial-data-types/

UNIT IV ADVANCED DATA MODELS

4.1 Mobile Databases: Location and Handoff Management - Effect of Mobility on Data Management - Location Dependent Data Distribution

https://www.sanfoundry.com/wireless-mobile-communications-questions-answers-handoff-strategies/

4.2 Mobile Transaction Models -Concurrency Control - Transaction Commit Protocols- Multimedia Databases

https://www.sanfoundry.com/iot-questions-answers-open-iot-architecture/

4.3 Information Retrieval- Data WarehousingData Mining- Text Mining.

https://www.sanfoundry.com/sqlserver-mcqs-management-data-warehouse/

UNIT V EMERGING TECHNOLOGIES

5.1 XML Databases: XML-Related Technologies-XML Schema

https://www.sanfoundry.com/sqlserver-mcqs-working-with-xml-data-1/

5.2 XML Query Languages

https://www.sanfoundry.com/sqlserver-mcqs-xquery/

5.3 Storing XML in Databases-XML and SQL- Native XML Databases

https://www.sanfoundry.com/sqlserver-mcqs-working-with-xml-data-1/

5.4 Web Databases- Geographic Information Systems- Biological Data Management

https://www.sanfoundry.com/surveying-questions-answers-components-gis/

5.5 Cloud Based Databases: Data Storage Systems on the Cloud

https://www.sanfoundry.com/1000-cloud-computing-questions-answers/

5.6 Cloud Storage Architectures-Cloud Data Models- Query Language

https://www.sanfoundry.com/cloud-computing-questions-answers-cloud-storage-digital-universe/

5.7 Introduction to Big DataStorage-Analysis

https://www.sanfoundry.com/bigdata-questions-answers/


Post a Comment