IGNOU MCS 43 course is all about Advanced Database Management System. Here we have listed out the most important questions related to IGNOU MCS 043 course.

Book 1 - Unit 1 Relational Database Design

Following topics are important which are related to MCS 43 course of IGNOU:-

1) Multivalued Dependencies

2) Fourth Normal Form (4NF)

3) Join Dependency & Trivial Join Dependency

4) EER Diagram

5) Referential Integrity Constraint

BOOK 1 - UNIT 2 DATABASE IMPLEMENTATION & TOOLS

In Database Implementation Tools chapter of IGNOU MCS 43, the following topics must be studied in order to pass the exam with ease.

1) LOGICAL DB
2) PHYSICAL DB
3) DIFFERENCES BETWEEN LOGICAL & PHYSICAL DB

BOOK 1 - UNIT 3 ADVANCED SQL

Here are the important topics related to IGNOU MCS 43 Advanced SQL chapter:-

1) VIEWS (Page – 49)

2) Significance of creating views

3) How View is created

4) Strategies of implementing Views

5) Cursors in Embedded SQL & their Significance (Page – 54)

6) Triggers (Page – 55)

7) Utility of TRIGGERS

8) SQL Code for Triggers
9) Stored Procedures

10) SQL J (Page – 57)

11) Requirements | Working | Differences Between SQLJ and Dynamic SQL

BOOK 1 - UNIT 4 - DATABASE SYSTEM CATALOGUE

1) DATA DICTIONARY (Page – 68)

2) FEATURES | BENEFITS | DISADVANTAGES

3) Various Approaches to implementing Distributed DB Catalogue

4) What is SYSTEM CATALOGUE? (Page – 75)

5) What information stored in Catalogue of RDBMS?

BOOK 2 – UNIT 1 - QUERY PROCESSING & EVALUATION

1) Query Optimization (Page – 7)
2) Technique of Query Opt with Example

3) HASH-JOIN (Page – 15)
4) How HASH-JOIN of two relations computed?

5) Cost Calculation of simple HASH-JOIN

BOOK 2 - UNIT 2 - TRANSACTION MANAGEMENT & RECOVERY

Here are frequently asked MCS 43 MCA Advanced Data Base Management System questions.

1) OLTP (Online Transaction Processing) (Page – 30)

2) Time-stamp Ordering (Page – 36)

3) Timestamp based protocol for serialized schedule

4) Deadlocks – How they are detected (Page – 43)

5) SHADOW PAGING (Page – 50)

6) Advantages & Disadvantages of Shadow Paging

BOOK 2 - UNIT 3 | DATABASE SECURITY & ADMINISTRATION

1) AUDIT TRAIL (Page – 69)

BOOK 2 – UNIT 4 DISTRIBUTED DATABASES

1) DISTRIBUTED DATABASE MGMT SYSTEM (Page – 74)

2) Reference Architecture

3) 2-Phase Commit (Page – 88)

4) 3-Phase Commit
4A) Differences between 2-phase & 3-phase Commit

BOOK 3 - UNIT 2 DATABASE AND XML

1) Semi-structured Data (Page – 28)

2) XML (Page – 29)

2A) What is XML?

2B) Difference between XML & HTML

3) Advantages of XML

4) Create XML Schema (Eg. Student records)

5) Document Type Declaration (DTD) for XML

6) Difference between Well Formed XML document and Valid XML Document

BOOK 3 - UNIT 3 | INTRODUCTION TO DATA WAREHOUSING

1) What is Data Warehousing? (Page – 60)

1A) Difference between DBMS & Data Warehouse

1B) Process of ELT for Data Warehouse (Page – 65)

1C) Characteristics

2) Online Analytical Processing (OLAP) (Page – 72)

2A) Differences between OLAP & OLAP

3) Data Mart (Page – 75)

3A) Significance

BOOK 3 – UNIT 4 | INTRODUCTION TO DATA MINING

1) Explain Data Mining (Page – 82)

1A) Difference between DB Queries and Data Mining Query

1B) Knowledge Discovery in Database

1C) Clustering Techniques for Data Mining

2) Clustering Techniques for Data Mining (Page – 94)

2A) K means Clustering

2B) Neighbour Clustering & Differences between K Means and Neighbouring

3) Association Rule Mining (Page – 97)

BOOK 4 – UNIT 1 - EMERGING DB MODELS, TECHNOLOGIES & APPLICATIONS - I

1) Multimedia Database (Page – 6)

1A) Features and Challenges

2) Semantic Databases (Page – 18)

2A) Features

2B) Process of Searching Knowledge in Semantic DBs

BOOK 4 - UNIT 2 - EMERGING DB MODELS, TECHNOLOGIES & APPLICATIONS - I

1) Mobile Database (Page – 22)

1A) Characteristics | Challenges | Application

2) ODBC (Page – 28)

2A) Components required for implementing ODBC

3) JDBC (Page – 29)

4) Compare ODBC & JDBC

5) Data Grid (Page – 33)

BOOK 4 - UNIT 3 - PostgreSQL

1) PostgreSQL (Page – 45)

1A) Perform storage & indexing

2) Types of Indexed involved in PostgreSQL with examples

3) B-Tree and R-Tree Indexes & Differences Between Them (Page – 47)
 

So here were the frequently asked and most important questions of IGNOU MCS 43 course. Apart from IGNOU MCS 43, the above-listed topics are very important for aspiring software engineers who are about to appear for interviews to become Database Management Developer and DBA.