WB JECA MCA Database Management Systems Previous Year Questions (PYQs) – Page 1 of 3

A Candidate Key is derived from a Super Key, and then one candidate key is chosen as the Primary Key.

Relational Algebra is a procedural query language because it specifies the operations to obtain the result.

For union compatibility, two relations must have the same set of attributes and domains.

ALTER TABLE can ADD, MODIFY, and DROP columns, but DELETE is a DML operation, not part of ALTER.

3NF eliminates transitive dependencies.

Metadata organization is not a query processing step.

Transaction states are Active, Partially committed, Failed, Aborted, Terminated. There is no "Updated" state.

2NF removes partial dependency.