Exam Details
| Subject | Advanced Database Design | |
| Paper | ||
| Exam / Course | Post Graduate Diploma in Computer Application (PGDCA)/ Advance Diploma inComputer Applications (ADCA) / Masters in Computer Applications (MCA) | |
| Department | School of Computer and Information Sciences (SOCIS) | |
| Organization | indira gandhi national open university | |
| Position | ||
| Exam Date | June, 2016 | |
| City, State | new delhi, |
Question Paper
What are Triggers Explain the significance of triggers with the help of an example.
Explain the Log-Based recovery scheme, using deferred database modification approach. Give a suitable example in your explanation.
What are mobile databases List the characteristics of mobile databases.Discuss the challenges of implementing
mobile databases.
List the index implementation available in PostgreSQL. Explain each index available in PostgreSQL.
What is Data Dictionary? What is the significance of creating Data Dictionary in DBMS? Explain the statistics stored in the Data Dictionary.
What are Database Security features Discuss with example how Oracle manages database security.
What are web databases How do you create them? List the steps.
What are views What is the significance of views in DBMS How are views managed in SQL Explain with an
example.
How do Database Queries differ from Data Mining Queries Explain K-Means Clustering algorithm for Data Mining, with suitable example.
Explain any two of the following:
OLAP and its types
Spatial Databases
Dynamic SQL
Explain Data fragmentation in distributed DBMS, with the help of an example.
Discuss the term 'Association rule mining'. Write the Apriori algorithm for association rule mining. Illustrate it using an example.
Explain any two of the following with suitable examples:
Semantic Databases
Temporal Databases
Embedded SQL
Discuss 4NF with suitable example. Is 4NF decomposition dependency preserving Justify.
In PostgreSQL, explain how B-Tree Indexes are different from R-Tree Indexes.
Discuss any three of the following with suitable examples:
UML Class Diagram
Query Optimization
Assertion
Multiversioning
What are checkpoints How are checkpoints used in log-based. recovery Explain with the help of an example and a diagram.
What are control files in Oracle? What does a control file contain? What is the role of control file in starting an instance of Oracle Discuss the role of redo log file in starting an instance of Oracle.
Describe ID3 algorithm for classifying datasets, with suitable example.
Explain the Log-Based recovery scheme, using deferred database modification approach. Give a suitable example in your explanation.
What are mobile databases List the characteristics of mobile databases.Discuss the challenges of implementing
mobile databases.
List the index implementation available in PostgreSQL. Explain each index available in PostgreSQL.
What is Data Dictionary? What is the significance of creating Data Dictionary in DBMS? Explain the statistics stored in the Data Dictionary.
What are Database Security features Discuss with example how Oracle manages database security.
What are web databases How do you create them? List the steps.
What are views What is the significance of views in DBMS How are views managed in SQL Explain with an
example.
How do Database Queries differ from Data Mining Queries Explain K-Means Clustering algorithm for Data Mining, with suitable example.
Explain any two of the following:
OLAP and its types
Spatial Databases
Dynamic SQL
Explain Data fragmentation in distributed DBMS, with the help of an example.
Discuss the term 'Association rule mining'. Write the Apriori algorithm for association rule mining. Illustrate it using an example.
Explain any two of the following with suitable examples:
Semantic Databases
Temporal Databases
Embedded SQL
Discuss 4NF with suitable example. Is 4NF decomposition dependency preserving Justify.
In PostgreSQL, explain how B-Tree Indexes are different from R-Tree Indexes.
Discuss any three of the following with suitable examples:
UML Class Diagram
Query Optimization
Assertion
Multiversioning
What are checkpoints How are checkpoints used in log-based. recovery Explain with the help of an example and a diagram.
What are control files in Oracle? What does a control file contain? What is the role of control file in starting an instance of Oracle Discuss the role of redo log file in starting an instance of Oracle.
Describe ID3 algorithm for classifying datasets, with suitable example.
Other Question Papers
Departments
- Centre for Corporate Education, Training & Consultancy (CCETC)
- Centre for Corporate Education, Training & Consultancy (CCETC)
- National Centre for Disability Studies (NCDS)
- School of Agriculture (SOA)
- School of Computer and Information Sciences (SOCIS)
- School of Continuing Education (SOCE)
- School of Education (SOE)
- School of Engineering & Technology (SOET)
- School of Extension and Development Studies (SOEDS)
- School of Foreign Languages (SOFL)
- School of Gender Development Studies(SOGDS)
- School of Health Science (SOHS)
- School of Humanities (SOH)
- School of Interdisciplinary and Trans-Disciplinary Studies (SOITDS)
- School of Journalism and New Media Studies (SOJNMS)
- School of Law (SOL)
- School of Management Studies (SOMS)
- School of Performing Arts and Visual Arts (SOPVA)
- School of Performing Arts and Visual Arts(SOPVA)
- School of Sciences (SOS)
- School of Social Sciences (SOSS)
- School of Social Work (SOSW)
- School of Tourism & Hospitality Service Sectoral SOMS (SOTHSM)
- School of Tourism &Hospitality Service Sectoral SOMS (SOTHSSM)
- School of Translation Studies and Training (SOTST)
- School of Vocational Education and Training (SOVET)
- Staff Training & Research in Distance Education (STRIDE)
Subjects
- Accounting and Financial Management
- Advanced Database Design
- Advanced Discrete Mathematics
- Advanced Internet Technologies
- Artificial Intelligence and Knowledge Management
- Communication Skills
- Computer Graphics and Multimedia
- Computer Organisation & Assembly Language Programming
- Data and File Structure
- Data Communication and Computer Networks
- Database Management System
- Database Management Systems
- Design and Analysis of Algorithm
- Discrete Mathematics
- Elements of Systems Analysis & Design
- Numerical and Statistical Computing
- Object Oriented Analysis and Design
- Object Oriented Technologies and Java Programming
- Operating System Concepts and Networking Management
- Operating Systems
- Parallel Computing
- Principles of Management and Information Systems
- Problem Solving and Programming
- Software Engineering
- Systems Analysis and Design