BPSC TRE – DBMS | Full Length Mock Test 1

Since ID is unique, ID is a minimal super key (candidate key). Any superset of ID, such as {CITY, ID} or {ID, NAME, CITY}, is also a valid super key.

In relational model terminology, a Domain is the collection of all valid, atomic values that can be assigned to an attribute.

Database recovery algorithms (such as log-based undo/redo operations and checkpoints) restore the database to a consistent state following transaction or system crashes.

None of the above makes the updates of the current transaction permanent. COMMIT is the command that makes a transaction's changes permanent.

Natural JOIN (⋈) matches tuples from two relations based on equality of all common attributes and automatically projects out duplicate column copies.