MC	Which statement is NOT CORRECT?	Fragmentation transparency refers to the fact that users can execute global queries, without being concerned with the fact that distributed fragments will be involved, and need to be combined, to perform the query.	incorrect	Replication transparency means that different replicas of the same data item will be automatically kept consistent by the database system and updates to one replica will be propagated transparently (be it synchronously or asynchronously) to the other copies of the same data item.	incorrect	Transaction transparency refers to the fact that the distributed database can be accessed and queried in a uniform fashion, regardless of the different database systems and APIs that may be involved. 	correct	Location transparency means that database users do not need to know on which node the required data resides.	incorrect	
MC	Many NoSQL databases apply some form of...	vertical fragmentation.	incorrect	horizontal fragmentation.	correct	
MC	Which statement is CORRECT?	In a shared memory architecture, multiple interconnected processors that run the DBMS software share the same central storage and secondary storage. 	incorrect	With a shared disk architecture, each processor has its own central storage but shares secondary storage with the other processors. 	incorrect	In a shared nothing architecture, each processor has its own central storage and hard disk units.	incorrect	All statements are CORRECT.	correct	
MC	Which statement is NOT CORRECT?	Eventual consistency in a NoSQL environment implies that the results of a database transaction will eventually be propagated to all replicas and if no further transactions are executed then the system will eventually become consistent.	incorrect	In a shared nothing architecture, each processor has its own central storage and hard disk units.	correct	A schedule in 2PL is deadlock free if both the local and global wait-for graphs contain no cycles.	incorrect	Replication transparency means that different replicas of the same data item will be automatically kept consistent by the database system and updates to one replica will be propagated transparently (be it synchronously or asynchronously) to the other copies of the same data item.	incorrect	
MC	Which statement is NOT CORRECT?	Even if the database contains replicated data, applying the basic 2PL protocol still suffices to guarantee serializability. 	correct	A disadvantage of Primary site 2PL is that the central lock manager may become a bottleneck.	incorrect	With distributed 2PL, every site has its own lock manager, which is responsible for managing all locking data pertaining to the fragments stored on that site. 	incorrect	Primary site 2PL comes down to applying the centralized Two-Phase Locking protocol in a distributed environment. 	incorrect	
MC	A schedule in 2PL is deadlock free if...	the local wait-for graphs contain no cycles.	incorrect	both the local and global wait-for graphs contain no cycles.	correct	the local wait-for graph contains only a limited number of cycles.	incorrect	the global wait-for graph contains only a limited number of cycles.	incorrect	
MC	Which statement is NOT CORRECT?	Transaction transparency refers to the fact that the distributed database can be accessed and queried in a uniform fashion, regardless of the different database systems and APIs that may be involved. 	correct	Fragmentation transparency refers to the fact that users can execute global queries, without being concerned with the fact that distributed fragments will be involved, and need to be combined, to perform the query.	incorrect	Location transparency means that database users do not need to know on which node the required data resides.	incorrect	Replication transparency means that different replicas of the same data item will be automatically kept consistent by the database system and updates to one replica will be propagated transparently (be it synchronously or asynchronously) to the other copies of the same data item.	incorrect	
MC	Which statement is CORRECT?	Eventual consistency in a NoSQL environment implies that the database is inconsistent at all times.	incorrect	A schedule in 2PL is deadlock free if the local wait-for graph contains only a limited number of cycles.	incorrect	Many NoSQL databases apply some form of vertical fragmentation.	incorrect	A disadvantage of Primary site 2PL is that the central lock manager may become a bottleneck.	correct	
MC	A schedule in 2PL is deadlock free if...	both the local and global wait-for graphs contain no cycles.	correct	the global wait-for graph contains only a limited number of cycles.	incorrect	the local wait-for graph contains only a limited number of cycles.	incorrect	the local wait-for graphs contain no cycles.	incorrect	
MC	Many NoSQL databases apply some form of...	vertical fragmentation.	incorrect	horizontal fragmentation.	correct