Crowdly
Add to Chrome
Questions Bank (1484939 total)
The SQL command GRANT is not used to provide privileges to database users
0%
100%
View this question
Synchronous replication generally involves more communication overhead compared to asynchronous replication
100%
0%
View this question
Transactions are a collection of successive DB operations that modify a database from an inconsistent state to another inconsistent state.
0%
0%
View this question
Update anomalies occur when modifying data in a database and can result in inconsistencies or errors
100%
0%
View this question
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