MUTHAYAMMAL ENGINEERING COLLEGE
(An Autonomous Institution)
(Approved by AICTE, New Delhi, Accredited by NAAC & Affiliated to Anna University)
Rasipuram - 637 408, Namakkal Dist., Tamil Nadu.
Department of Master of Computer Applications
Question Bank - Academic Year (2020-21)
Course Code & Course Name
: 19CAB03 & Relational Database Management
Systems
Name of the Faculty
: Mrs.R.Pavithra
Year/Sem/Sec
: I / I / -
Unit-I: Introduction
Part-A (2 Marks)
1.
Define database management system.
2.
Who is a DBA? What are the responsibilities of a DBA?
3.
What is a data model? List the types of data model used.
4.
Define Schema.
5.
What is Attributes and it’s types?
6.
What are the components of storage manager?
7.
What is Structural Constraints?
8.
What is File Manager?
9.
Compare between weak and strong entity sets
10.
Define Participation Constraints.
Unit-II : Relational Model and Query Evaluation
Part-A (2 Marks)
1.
Define Relational Model
2.
What is SQL ?
3.
Define Relational Calculus
Part-B (16 Marks)
1.
Discuss in detail about DBMS Architecture with neat diagram. May 2012, May 2011,
May 2010
(16)
2.
Explain the detail about Data Model.
(16)
3.
Describe E-R model with neat diagram. May 2012
(16)
4.
Discuss the Data Modeling using Entity.
(16)
5.
Explain the detail about Relationship Model.
(16)
4.
What is DDL & DML?
5.
Give the general form of SQL query.
6.
List the use of Rename operation.
7.
What is Aggregate Function?
8.
What is Unary Operation?
9.
What is Functional Dependencies?
10.
Define Normalization.
Unit-III : Transaction Processing
Part-A (2 Marks)
1.
Define Transaction.
2.
Define Consistency.
3.
What is Atomicity?
4.
List out the Serializability.
5.
Define Growing Phase.
6.
What do you meant by Shadow Paging?
7.
Mention Three Importance Locking Techniques.
8.
What is Shared Lock?
9.
List out the Techniques of Database Security..
10.
What is Deadlock?
Part-B (16 Marks)
1.
Explain in detail about Relational Algebra.
(16)
2.
Briefly explain in detail about SQL.
(16)
3.
Explain in detail about Normalization. Nov 2010
(16)
4.
Briefly discuss about Functional Dependencies.
(16)
5.
Explain briefly about Relational Calculus.
(16)
Part-B (16 Marks)
1.
Write short notes on Concurrency Control.
(16)
2.
Discuss in detail about Serializability.
(16)
3.
Explain in detail about Organization development and its methods.
(16)
4.
Write short notes on Recovery.
(16)
5.
Discuss about Database Security.
(16)
Unit-IV : Files and Indexing
Part-A (2 Marks)
1.
Define File Organization.
2.
What is Fields and Records?
3.
Mention four importance File Organization Techniques.
4.
What is Fixed-Length Records?
5.
What do you meant by Indexing and its types?
6.
What is Grid Files.
7.
Define B+ tree.
8.
Define Hashing.
9.
List out the Hashing Technique.
10.
Difference between Indexing and Hashing,
Unit-V : Special-Based Databases
Part-A (2 Marks)
1.
What is Object-Based Databases?
2.
Define Context.
3.
Define Data Encapsulation.
4.
What is Object-Oriented Data model?
5.
What is XML?
6.
Define Temporal Databases.
7.
What is Mobile Databases?
8.
What is an Spatial Database?
9.
Define Persistent Programming Languages.
10.
What is Inheritance?
6.
Briefly discuss about Recovery Techniques.
(16)
Part-B (16 Marks)
1.
Explain in detail about File Operations.
(16)
2.
Discuss in detail about Indexing.
(16)
3.
Write short notes on B+ tree.
(16)
4.
Discuss in detail about Static Hashing.
(16)
5.
Explain about Hashing Techniques.
(16)
Part-B (16 Marks)
1.
Explain in detail about OO Data Model.
(16)
Course Faculty
HoD
2.
Write short notes on XML.
(16)
3.
Discuss about Temporal Database and Mobile Database
(16)
4.
Explain about Spatial Database.
(16)
5.
Discuss in detail about OO Languages..
(16)
