Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction? MCQ with Answer and Explanation

Question
Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction?
A. Isolation
B. Consistency
C. Atomicity
D. Durability
Answer: Option B
Solution (By JKSSB Mock Tests)
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following is a valid constraint in SQL?
A. All of the above
B. CHECK
C. PRIMARY KEY
D. FOREIGN KEY
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL are all constraints in SQL.
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which operator is used in SQL to compare a value to a set of values returned by a subquery?
A. IN
B. LIKE
C. BETWEEN
D. EXISTS
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
IN checks if a value matches any value in a list or subquery result set.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What does the ROLLBACK statement do?
A. Saves the changes
B. Creates a savepoint
C. Starts a new transaction
D. Undoes all changes made in the current transaction
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Abbreviations 369 Computer Hardware 430 Cyber Security 269 Memory and Storage Devices 438 Internet and Web Technologies 461
Explore Subjects
Reasoning 1111 Accountancy and Statistics 3179 Maths 5575 Static General Knowledge 6362 Science 4430
Practice Mix
Which type of soil is generally found in regions receiving rainfall greater than 200 cm annually?
That which cannot be touched
Which of the following states receives the highest rainfall during the Northeast Monsoon?
S1: Direct taxes are levied on income and wealth. S2: Direct taxes can be shifted to others. Which statement(s) is/are correct?
She identifies ___ the character.