Notes/fundamentals
1
0
Fork 0
mirror of https://github.com/robindhole/fundamentals.git synced 2025-03-15 20:00:15 +00:00
Code Issues Packages Projects Releases Wiki Activity
fundamentals/database/mcqs/03-normalisation-acid.md
Tanmay 7f3252f436 Adds MCQs.
2022-07-18 12:57:23 +01:00

1.1 KiB
Raw Permalink Blame History

Questions

  1. Joe Bloggs is creating a social media today. However, Joe has kept user and group information in the same table. Now whenever Joe removes a user, the group information is also gone. Which type of anomaly is this?

    A. Insertion
    B. Updation
    C. Deletion

  1. A user has an ID, name, email and group ID. One user can only have one email and it is unique. Which of the following dependencies is not correct?

    A. ID -> NAME
    B. EMAIL -> NAME
    C. EMAIL -> GROUP ID
    D. NAME -> GROUP ID

  1. Joe has created a table for group members where the columns are Group ID, User ID, Rating, Group Name. The primary key here is Group ID, User ID. Which type of functional dependency exists?

    A. No functional dependency
    B. Transitive
    C. Partial

  1. Joe has identified that one of his tables does not satisfy 1NF constraints. Which of the following types of ERD attributes are allowed under 1NF?

    A. Composite
    B. Multivalued
    C. Derived
    D. Index

Answers

  1. A. Deletion
  2. D NAME -> GROUP ID
  3. C Partial
  4. C Derived