Opening the paper…

Database Management Systems, End Term

May 2024 term, 1 Sept 2024, Set QDF1

Learning mode

Question 1

+2−0Single correct

Select one option

A.
75000
B.
250
C.
300
D.
50

Report a problem

to report a problem with this question.

Choose a question

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 19

Discussion

Submit this paper?

You cannot change your answers after submitting.

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 2

Instructions

The palette shows the status of every question. Pick a number to go straight to it.

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 2

Save & Next moves to the next question. Answers are saved as you go.
Mark for Review & Next flags the question to come back to. A flagged answer still counts.
Clear Response removes your answer to the question on screen.
The ← and → keys move to the previous and next question.

Figure from the original question paper Choose the correct output obtained on running the given SQL statements on Table **Employee**. | EID | EName | |---|---| | E01 | Arthur | | E02 | Raina | | E03 | Meena | | E04 | Arthur | | E06 | Joey | Table **Employee** 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; 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.