WB JECA MCA Database Management Systems Previous Year Questions (PYQs) – Page 1 of 2
Study Stuff for MCA Examinations
Solution
A Candidate Key is derived from a Super Key, and then one candidate key is chosen as the Primary Key.
Solution
Relational Algebra is a procedural query language because it specifies the operations to obtain the result.
Solution
For union compatibility, two relations must have the same set of attributes and domains.
Solution
ALTER TABLE can ADD, MODIFY, and DROP columns, but DELETE is a DML operation, not part of ALTER.
Solution
3NF eliminates transitive dependencies.
Solution
Metadata organization is not a query processing step.
Solution
Transaction states are Active, Partially committed, Failed, Aborted, Terminated. There is no "Updated" state.
Solution
2NF removes partial dependency.
Solution
- Relational Algebra is procedural (it specifies how to obtain the result).
- Relational Calculus is non-procedural (it specifies what to obtain, not how).
Solution
- 3NF (Third Normal Form) removes transitive dependency.
- Hence, it should not have transitive dependency.
Answer = (C) Third normal form
WB JECA MCA
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
WB JECA MCA
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
