Question 1
1
2
3
4
Question 2
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?
All privileges - select, insert, delete and update
Only select
Only delete and update
Only select and insert
Question 3
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 T1 needs to be undone, if it contains the record < T1, start > and also contains the record < T1, commit >.
Statement 3: A transaction T1 needs to be redone, if it contains the record < T1, start >, but does not contain the record < T1, commit >.
Statement 4: When a transaction T1 finishes its last statement successfully, the log record < T1, commit > is written.
Which among the given statements is/are correct?
Only statement 1
Statement 2 & 3
Statement 1 & 4
Only statement 4
22 more questions in this paper
Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.
More on the DBMS End Term 7 Aug 2022 Set QPD1 paper
The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 7 Aug 2022, in the May 2022 term, set QPD1: 25 questions for 50 marks in 180 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.
| Feature | DBMS End Term 7 Aug 2022 Set QPD1 at a glance |
|---|---|
| Term | May 2022 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 25 |
| Marks | 50 |
| Duration | 180 min |
| MCQ | 16 |
| MSQ | 7 |
| Numerical | 2 |
| Official paper | IIT M FOUNDATION DIPLOMA ENDTERM QPD1 07 Aug 2022 IBA NS |
| Negative marking | No negative marking. |
| Updated |