Question 1

Figure from the original question paper A role **Department\_Lead** has the privilege of delete and update on all the tables of the database. A new role **Employee1** is created, and the following statement is executed.\ grant Department\_Lead to Employee1\ What privileges will be inherited by **Employee1**? Consider the following statements:\ **Statement 1**: In case a transaction is not completely executed due to logical errors, the redo operation is used for transaction rollback.\ **Statement 2**: A transaction *T*1 needs to be undone, if it contains the record \< *T*1, *start* \> and also contains the record \< *T*1, *commit* \>.\ **Statement 3**: A transaction *T*1 needs to be redone, if it contains the record \< *T*1, *start* \>, but does not contain the record \< *T*1, *commit* \>.\ **Statement 4**: When a transaction *T*1 finishes its last statement successfully, the log record \< *T*1, *commit* \> is written.\ Which among the given statements is/are correct?