Question 91
In relational model, what is a Domain?
A domain is the pool of permissible atomic values defined for a specific attribute (column).
In relational model, what is a Domain?
A domain is the pool of permissible atomic values defined for a specific attribute (column).
What does Atomicity mean in 1st Normal Form (1NF)?
1NF requires that attribute domain values are atomic (single indivisible values) and that tables contain no multi-valued attributes or repeating groups.
Which protocol guarantees serializability by ordering transaction execution based on system clock values or logical counters?
Timestamp Ordering assigns a unique monotonically increasing timestamp TS(T) to each transaction, ensuring conflicting operations execute in timestamp order.
In Validation-Based Concurrency Control (Optimistic Concurrency Control), what are the three phases executed by a transaction?
Optimistic concurrency control executes transactions in three phases: Read phase (local writes), Validation phase (conflict check), and Write phase (commit to database).
Which NoSQL database category is MongoDB classified under?
MongoDB is a leading document-oriented NoSQL database that stores data as JSON-like BSON documents with dynamic schemas.