MC	Which statement is NOT CORRECT?	The logfile is often duplicated, e.g. in a RAID level 1 configuration.	incorrect	The logfile contains redundant data.	incorrect	The logfile can be implemented as a sequential file.	incorrect	The logfile contains all updates after they have been written to disk. 	correct	
MC	Which statement is NOT CORRECT?	One approach for deadlock resolution is victim selection which means choosing and aborting one of the transactions involved in the deadlock.	incorrect	The Read committed isolation level uses long-term read locks, but short-term write locks. 	correct	Deadlock prevention can be achieved by Static 2PL.	incorrect	The use of short-term locks violates rule 3 of the 2PL protocol, so serializability can no longer be guaranteed.	incorrect	
MC	Which statement is NOT CORRECT?	Archiving is an approach in which database files are copied periodically to other storage media, such as tape or (another) hard disk. 	incorrect	There is a trade-off between the cost (overhead and storage cost) of more frequent backups and the cost of lost data because of less frequent backups.	incorrect	Traditional relational databases allow for a certain measure of temporary inconsistency, in return for increased performance.	correct	Disk mirroring is a (near) real time approach that writes the same data simultaneously to two or more physical disks	incorrect	
MC	If the precedence graph contains a cycle, the schedule is...	not serializable	correct	serializable	incorrect	
MC	When a transaction is aborted, it is important that:	A rollback of the transaction is executed: all changes made by the transaction's respective operations should be undone.	correct	All changes made by the individual operations belonging to that transaction should be made permanent.	incorrect	
MC	Which of the following DBMS components is involved in Transaction Management?	Scheduler	incorrect	Stored data manager	incorrect	Buffer manager	incorrect	Recovery manager	incorrect	All of these components	correct	
MC	Which statement is NOT CORRECT?	The logfile can be implemented as a sequential file.	incorrect	The logfile contains all updates after they have been written to disk. 	correct	The logfile is often duplicated, e.g. in a RAID level 1 configuration.	incorrect	The logfile contains redundant data.	incorrect	
MC	Which statement is NOT CORRECT?	The logfile can be implemented as a sequential file.	incorrect	The logfile is often duplicated, e.g. in a RAID level 1 configuration.	incorrect	The logfile contains all updates after they have been written to disk. 	correct	The logfile contains redundant data.	incorrect	
MC	If the precedence graph contains a cycle, the schedule is...	not serializable	correct	serializable	incorrect	
MC	Which statement is NOT CORRECT?	Traditional relational databases allow for a certain measure of temporary inconsistency, in return for increased performance.	correct	Archiving is an approach in which database files are copied periodically to other storage media, such as tape or (another) hard disk. 	incorrect	Disk mirroring is a (near) real time approach that writes the same data simultaneously to two or more physical disks	incorrect	There is a trade-off between the cost (overhead and storage cost) of more frequent backups and the cost of lost data because of less frequent backups.	incorrect