Quiz Space

DBMS End Term: 1 September 2024, Set QDF1 (May 2024 term)

Question 1

+2 marksOne correct option
  1. A

    75000

  2. B

    250

  3. C

    300

  4. D

    50

Question 2

+2 marksOne correct option

Choose the correct output obtained on running the given SQL statements on Table Employee.

EIDEName
E01Arthur
E02Raina
E03Meena
E04Arthur
E06Joey

Table Employee

sql
SQL> SAVEPOINT SP1;
SQL> UPDATE Employee SET EName=‘Jainie’
     WHERE EID=‘E06’;
SQL> SAVEPOINT SP2;
SQL> DELETE FROM Employee WHERE EID=‘E02’;
SQL> SAVEPOINT SP3;
SQL> UPDATE Employee SET EName=‘Raina’
     WHERE EID=‘E04’;
SQL> ROLLBACK TO SP2;
  1. A
  2. B
  3. C
  4. D

Question 3

+2 marksOne correct option

Given below are four statements. Match each of them with the corresponding property in the set of ACID properties.
Statement 1: Any data written to the database must be valid according to all the defined rules like the check and key constraints and triggers.
Statement 2: Every completed transaction is saved into the secondary storage.
Statement 3: During money transfer, either the amount debited from the source account must be credited to the destination account or the money should not be debited from the source account at all.
Statement 4: If multiple transactions are being executed concurrently, then the final result should be the same irrespective of the sequence in which the transactions were executed.
Let A denote Atomicity, C denote Consistency, I denote Isolation and D denote Durability. From among the given options, find the correct match.

  1. A

    1 - A, 2 - C, 3 - I, 4 - D

  2. B

    1 - C, 2 - D, 3 - A, 4 - I

  3. C

    1 - C, 2 - D, 3 - I, 4 - A

  4. D

    1 - I, 2 - A, 3 - D, 4 - C

17 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 1 Sept 2024 Set QDF1 paper

The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 1 Sept 2024, in the May 2024 term, set QDF1: 20 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.

FeatureDBMS End Term 1 Sept 2024 Set QDF1 at a glance
TermMay 2024 term
SubjectDatabase Management Systems
Course codeBSCS2001
Questions20
Marks50
Duration180 min
MCQ8
MSQ9
Numerical3
Official paperIIT M FOUNDATION DIPLOMA AN EXAM QDF3 01 Sep 2024
Negative markingNo negative marking.
Updated

Other sets that day

Same End Term, other subjects

More DBMS