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 | December, 2016 | |
| City, State | new delhi, |
Question Paper
What is a Data warehouse How is it different from a Database What are the characteristics of a Data warehouse?
What are multimedia databases Discuss the challenges in the designing of multimedia databases.
How does Distributed DBMS differ from Centralized DBMS? Explain the reference architecture of Distributed DBMS.
Discuss the term multilevel security in DBMS. What are the typical security levels?
Explain 3-phase commit protocol. Why do we need 3-phase commit protocol in Distributed DBMS?
What is meant by the term Discuss the transformations required during the ETL process.
Explain shadow paging recovery scheme, with the help of a diagram.
What is a Datagrid Elaborate the structure of a datagrid What are the application areas of a datagrid
What do you understand by the term 'Database Tuning' What are the goals of tuning a database What is the requirement of tuning the database queries?
What is multiversion concurrency control? How can multiversion concurrency control be achieved by using time stamp ordering?
How do you perform cost calculation for simple Hash-Join?
What are mobile databases Discuss the characteristics of mobile databases. Give an application of mobile databases.
Explain the following
PJNF
SQLJ
Audit Trail
Deductive Database
What do you understand by 'Transaction' in DBMS Discuss the properties of concurrent transactions performed in DBMS.
Differentiate between following:
XML arid HTML
JDBC and ODBC
Clustering and Classification
Serial schedule and Serializable schedule
Explain "log based" recovery using immediate database modification scheme. Give suitable example for explanation. 5
Discuss the concept of exclusive locks and shared locks. How are these two locks used in transaction management? Discuss with an example.
Define the term Data mining. How is data mining different from Knowledge Discovery in Databases Explain the steps of KDD with the help of an example.
How are object oriented databases different from relational databases Write an ODL syntax to create a class Employee that also references the Project class.
Explain the role of Query optimizer in Oracle.
What are web databases Discuss the steps required in creating a web database.
What are multimedia databases Discuss the challenges in the designing of multimedia databases.
How does Distributed DBMS differ from Centralized DBMS? Explain the reference architecture of Distributed DBMS.
Discuss the term multilevel security in DBMS. What are the typical security levels?
Explain 3-phase commit protocol. Why do we need 3-phase commit protocol in Distributed DBMS?
What is meant by the term Discuss the transformations required during the ETL process.
Explain shadow paging recovery scheme, with the help of a diagram.
What is a Datagrid Elaborate the structure of a datagrid What are the application areas of a datagrid
What do you understand by the term 'Database Tuning' What are the goals of tuning a database What is the requirement of tuning the database queries?
What is multiversion concurrency control? How can multiversion concurrency control be achieved by using time stamp ordering?
How do you perform cost calculation for simple Hash-Join?
What are mobile databases Discuss the characteristics of mobile databases. Give an application of mobile databases.
Explain the following
PJNF
SQLJ
Audit Trail
Deductive Database
What do you understand by 'Transaction' in DBMS Discuss the properties of concurrent transactions performed in DBMS.
Differentiate between following:
XML arid HTML
JDBC and ODBC
Clustering and Classification
Serial schedule and Serializable schedule
Explain "log based" recovery using immediate database modification scheme. Give suitable example for explanation. 5
Discuss the concept of exclusive locks and shared locks. How are these two locks used in transaction management? Discuss with an example.
Define the term Data mining. How is data mining different from Knowledge Discovery in Databases Explain the steps of KDD with the help of an example.
How are object oriented databases different from relational databases Write an ODL syntax to create a class Employee that also references the Project class.
Explain the role of Query optimizer in Oracle.
What are web databases Discuss the steps required in creating a web database.
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