MISM3403: Data MGMT in EnterpriseExam 2 with Correct Questions & Verified Answers 2024

MISM3403: Data MGMT in Enterprise-
Exam 2 with Correct Questions & Verified
Answers 2024
1) Which of the following is a read operation?

A) Entering new data in the relation
B) Retrieving data from the relation
C) Removing data from the relation
D) Changing the existing data in the relation - ANS✔✔--B

2) Which of the following is a modify operation?
A) Entering new data in the relation
B) Retrieving data from the relation
C) Removing data from the relation
D) Changing the existing data in the relation - ANS✔✔--D

3) Every relation contains:
A) Equivalent functional dependency
B) Augmented functional dependency
C) Trivial functional dependency
D) All of the above - ANS✔✔--C

4) Every relation contains:
A) Full key functional dependency
B) Partial functional dependency
C) Transitive functional dependency
D) All of the above - ANS✔✔--A

5) If A --> B is an existing functional dependency, which of the following is an
augmented functional dependency?
A) A, B --> C
B) A, C --> B
C) A --> C
D) B --> A - ANS✔✔--B

6) If A --> B and B --> A are existing functional dependencies, which of the following are
NOT equivalent functional dependencies?
A) A --> B and B --> A
B) A --> B, X and B --> A, X
C) X --> A and A --> B
D) X, A --> B, X and X, B --> A, X - ANS✔✔--C

, ENROLLMENT
Observe the table ENROLLMENT:

ENROLLMENT
StudentID StudentName ClassID ClassName
111 Joe E1 English1
222 Bob E1 English1
333 Lisa H1 History1

This table will be used for the following questions citing table ENROLLMENT.

7) Which of the following (regarding the relation ENROLLMENT) represents the
insertion anomaly?
A) Inability to insert a student without adding a class
B) Inability to insert a class without adding a student
C) Inability to insert a class name without a class ID
D) Inability to insert a student name without a student ID - ANS✔✔--B

ENROLLMENT
Observe the table ENROLLMENT:

ENROLLMENT
StudentID StudentName ClassID ClassName
111 Joe E1 English1
222 Bob E1 English1
333 Lisa H1 History1



Which of the following (regarding the relation ENROLLMENT) represents the deletion
anomaly?
A) Deleting a student ID may delete a student name
B) Deleting a class ID may delete the class name
C) Deleting a class may delete all information about a student
D) Deleting a student may delete all information about a class - ANS✔✔--D

ENROLLMENT
Observe the table ENROLLMENT:

ENROLLMENT
StudentID StudentName ClassID ClassName
111 Joe E1 English1
222 Bob E1 English1
333 Lisa H1 History1