Question 1
Reflexivity
Reflexivity and Augmentation
Augmentation and Transitivity
Union and Reflexivity
Question 2
Atomicity
Consistency
Isolation
Durability
Question 3
Which of the following statement(s) is/are correct regarding the third normal form in normalization?
1. Non-prime attributes are not allowed to functionally determine non-prime attributes. 2. The proper subset of any candidate key functionally determines non-prime attributes. 3. Multivalued attributes are allowed in third normal form.
4. Proper subset of any candidate key is not allowed to functionally determine the non-prime attributes.
Statements 1,2 & 3 are correct.
Statements 3 & 4 are correct.
Statements 1 & 4 are correct.
All the statements are correct.
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 3 Apr 2022 Set AN1 paper
The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 3 Apr 2022, in the January 2022 term, set AN1: 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 3 Apr 2022 Set AN1 at a glance |
|---|---|
| Term | January 2022 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 25 |
| Marks | 50 |
| Duration | 180 min |
| MCQ | 19 |
| MSQ | 3 |
| Numerical | 3 |
| Official paper | IIT M FOUNDATION DIPLOMA ENDTERM FN1 3 Apr 2022 |
| Negative marking | No negative marking. |
| Updated |