Download PTU MCA 2020 March 2nd Sem 26053 Relational Database Management Systems Question Paper

FirstRanker.com
Firstranker's choice

Roll No. [ ] [ ] [ ] Total No. of Pages : 02

--- Content provided by​ FirstRanker.com ---

MCA (2014 Batch) (Sem.-2)
RELATIONAL DATABASE MANAGEMENT SYSTEMS
Subject Code : MCA-202
M.Code : 26053

--- Content provided by‍ FirstRanker.com ---

INSTRUCTIONS TO CANDIDATES :

1. SECTIONS-A, B, C & D contains TWO questions each carrying TWENTY marks each and students has to attempt any ONE question from each SECTION.
2. SECTION-E is COMPULSORY consisting of TEN questions carrying TWENTY marks in all.

SECTION-A

--- Content provided by​ FirstRanker.com ---

1. Define DBMS. Discuss the concepts of data independence and data abstraction.
2. Discuss the process of database design.

SECTION-B

1. What are the various types of Constraints? Explain each with an example.
2. What do you mean by database recovery? Discuss the various recovery mechanisms in detail.

--- Content provided by⁠ FirstRanker.com ---

SECTION-C

1. What are distributed database management systems? Discuss the advantages and disadvantages of DDBMS.
2. What are distributed database transactions? What are its features? Discuss transaction transparency in detail.

SECTION-D

1. What do you mean by DSS? What is the importance of DSS databases? Explain the DSS database requirements.

--- Content provided by‍ FirstRanker.com ---

2. Define OLAP. Elaborate OLAP architecture.

SECTION-E

1. Write briefly :
   1. What is Composite entity?
   2. Why do we need mappings between schema levels?
   3. Define Multi-Valued Dependency.

   --- Content provided by⁠ FirstRanker.com ---

   4. Define Object-oriented database.
   5. What is concurrency? What are its problems?
   6. What are shared and exclusive locks? Explain with the help of suitable example.
   7. Differentiate between centralized and decentralized database designs.
   8. Define and distinguish between SPSD and MPMD.

   --- Content provided by⁠ FirstRanker.com ---

   9. What is operational data? How is it different from decision support data?
   10. What is database administration?

NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any page of Answer Sheet will lead to UMC against the Student.

--- Content provided by FirstRanker.com ---