munotes®

B.Sc. (Computer Science) Sem 1 Fundamentals of Database Systems Nov 2024 Question Paper - Mumbai University | munotes

Fundamentals Of Database Systems Question Paper, Nov 2024.pdf
SEM 1 · 26 KB · 16 Oct 2026

Loading PDF...

Questions asked in this paper

Solved paper All 12 questions answered in full Exam-ready answers, the reasoning behind each one, and what the examiner is looking for. Open the solutions

SECTION I - Q.1 (Attempt any TWO) 10 Marks

  1. A) List and explain the functions of DBA.
    Read the model answer
  2. B) What is Data Model? Explain various types of data models.
    Read the model answer
  3. C) Explain the term Aggregation in EER.
    Read the model answer
  4. D) Explain CREATE and DROP command with suitable example.
    Read the model answer

SECTION II - Q.2 (Attempt any TWO) 10 Marks

  1. A) Write a note on Cartesian product.
    Read the model answer
  2. B) Explain various Math functions in MySQL.
    Read the model answer
  3. C) Write a note on BCNF.
    Read the model answer
  4. D) Explain COMMIT and ROLLBACK command in detail.
    Read the model answer

SECTION III - Q.3 (Attempt any TWO) 10 Marks

  1. A) What is key? What are the different types off keys available in DBMS explain?
    Read the model answer
  2. B) Explain the terms (i) Stored attribute (ii) Derived attribute (iii) Key attribute.
    Read the model answer
  3. C) Explain Outer JOIN in detail.
    Read the model answer
  4. D) Explain BACKUP and RESTORE in database.
    Read the model answer

Read from the scan above, so a character or two may differ. The scan is the original.

Issue

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Something wrong with this paper? Report it.

Done!
Done!