Which of the following is a property of a database that ensures transactions are isolated from each other? MCQ with Answer and Explanation

Question
Which of the following is a property of a database that ensures transactions are isolated from each other?
A. Atomicity
B. Isolation
C. Consistency
D. Durability
Answer: Option B
Solution (By JKSSB Mock Tests)
Isolation ensures that concurrent execution of transactions results in a state that is equivalent to some serial execution.
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 commands is a Data Manipulation Language (DML) statement?
A. UPDATE
B. TRUNCATE
C. COMMENT
D. RENAME
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL 'GROUP BY' clause?
A. To group rows that have the same values in specified columns into summary rows
B. To filter rows
C. To join tables
D. To sort the result set
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
GROUP BY organizes data into groups based on the values of one or more columns, often used with aggregate functions.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a type of lock in a database?
A. Both A and B
B. None
C. Shared lock
D. Exclusive lock
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Shared locks allow multiple transactions to read a resource, while exclusive locks allow only one transaction to write.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Abbreviations 369 Computer Networking 325 Programming Languages 0 Microsoft Office 1199 Database Management System (DBMS) 278
Explore Subjects
Geography GK 6121 Current Affairs 575 Economy GK 2220 English 15164 Science 4430
Practice Mix
Simple interest on Rs. 1224000 for 3 years at 32% per annum is
Spot the error: 'These kind of mistakes are common.'
What is 'Edge Computing'?
If a:b = 4:10 and b:c = 10:12, then a:b:c = ?
The administrative position of 'Waqil' in the early Mughal hierarchy under Akbar was essentially equivalent to which role?