Ask a Question

In order to maintain the consistency during transactions, database provides

in Education by
In order to maintain the consistency during transactions, database provides (a) Commit (b) Atomic (c) Flashback (d) Retain I have been asked this question in a job interview. This is a very interesting question from Transactions in chapter SQL : Queries, Constraints and Triggers of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
The correct choice is (b) Atomic The best I can explain: By atomic, either all the effects of the transaction are reflected in the database, or none are (after rollback).

Related questions

0 votes
Q: In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?
    In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy? ( ... Protocols in division Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions.
    Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions. (1)False (2)True...
asked Apr 22, 2021 in Technology by JackTerrance
0 votes
Q: Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions.
    Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions....
asked Oct 11, 2020 in Education by anonymous
0 votes
Q: Which organization was created after World War I to maintain peace and order in the world?
    Which organization was created after World War I to maintain peace and order in the world? Select the correct answer from above options...
asked Aug 3, 2022 in Education by JackTerrance
0 votes
Q: What type of visibility should Product Owners provides during ART sync
    What type of visibility should Product Owners provides during ART sync...
asked Nov 30, 2020 in Technology by Editorial Staff
0 votes
Q: store and a document database.Some of the common Write Consistency level in Cassandra include all except ___________.
    store and a document database.Some of the common Write Consistency level in Cassandra include all except ___________....
asked Jan 26, 2021 in Technology by JackTerrance
0 votes
Q: A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
    A relational database system needs to maintain data about the relations, such as the schema of the relations. ... in division Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Multiple database transactions on a single connection
    I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 7, 2022 in Education by JackTerrance
0 votes
Q: Multiple database transactions on a single connection
    I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 6, 2022 in Education by JackTerrance
0 votes
Q: Multiple database transactions on a single connection
    I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 5, 2022 in Education by JackTerrance
0 votes
Q: Multiple database transactions on a single connection
    I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 5, 2022 in Education by JackTerrance
0 votes
Q: Multiple database transactions on a single connection
    I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 5, 2022 in Education by JackTerrance
0 votes
Q: Multiple database transactions on a single connection
    I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 5, 2022 in Education by JackTerrance
0 votes
Q: The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as
    The database system must take special actions to ensure that transactions operate properly without interference ... Concept topic in chapter Transactions of Database Management...
asked Oct 10, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...