Crowdly
Add to Chrome
DMBS.ig
Looking for DMBS.ig test answers and solutions? Browse our comprehensive collection of verified answers for DMBS.ig at moodle.cs.ubbcluj.ro.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
External sorting involves processing data that does not fit into the system's main memory.
100%
0%
View this question
Repeatable Read isolation level guarantees that if a row is read twice within the same transaction, the result will be different each time
0%
100%
View this question
PostgreSQL does not support table partitioning for better performance
0%
100%
View this question
In Replacement Selection, the algorithm will use the abandoned heap space to store records for the next run.
100%
0%
View this question
Two execution plans S and S' are visually conflicted when they contain the same operators for the same transaction.
100%
0%
View this question
Triggers are automatically activated by changes to data in a database.
100%
0%
View this question
In data recovery for a local database, using the strict two-phase locking protocol is necessary for guaranteeing atomicity and durability of transactions
0%
0%
View this question
In the event of a coordinator failure in 2PC, participants who voted yes are able to independently decide whether to commit or abort the transaction until the coordinator is restored, preventing a blocked state for the transaction
50%
50%
View this question
Data anomalies can be avoided or minimized by designing databases that adhere to the principles of normalization
100%
0%
View this question
Replication in distributed databases increases data availability and reliability
0%
0%
View this question