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!
The maximum number of tuples in the query result is the sum of the cardinality of the relationships in the FROM clause
25%
75%
View this question
Possible architectures for global catalogs in distributed systems include centralized, replicated, multiple, and partitioned catalogs, each offering distinct advantages and disadvantages in terms of communication and performance
100%
0%
View this question
PostgreSQL allows only one transaction to be active at a time
0%
100%
View this question
Heaps: Data structure in the form of a complete binary tree (all levels except the leaf levels are complete).
100%
0%
View this question
When a write lock (exclusive lock) is found on an object A for a transaction, the transaction can execute Write(A) (but not Read(A)).
0%
100%
View this question
The cost of eliminating duplicates is always higher than projecting without eliminating duplicates
50%
50%
View this question
Two execution plans are equivalent if they have the same set of transactions and the same effect on a database.
100%
0%
View this question
'Full table scan' refers to a database operation where the database engine scans every row in a table to satisfy a query
100%
0%
View this question
Transactions are a collection of successive DB operations that modify a database from an inconsistent state to a consistent state.
0%
100%
View this question
Repeatable Read isolation level allows other transactions to modify rows selected by the current transaction before it completes
0%
0%
View this question