DBMS Data Transmission and Execution

Questions and Answers

To resolve a problem or task

It is loaded into the main memory and becomes a process.

A program is a static entity, while a process is a program in a running state.

Because this is a rule of computer operation. Signup and view all the answers

To normalize the data. Signup and view all the answers

A program in programming language and its equivalent in DBMS is a query. Signup and view all the answers

A process in programming language and its equivalent in DBMS is a transaction. Signup and view all the answers

Withdrawing or depositing money is an example of a transaction in a banking system. Signup and view all the answers

The balance amount increases by the deposited amount. Signup and view all the answers

A transaction is an individual smallest unit of work. Signup and view all the answers

Study Notes

In DBMS, a program is equivalent to a query, and a process is equivalent to a transaction.
A program is a static entity saved on a disk, and when it's executed, it's loaded into main memory and becomes a process.
Similarly, in DBMS, a query is a set of instructions to achieve a task or objective, and when it's executed, it becomes a transaction.
A transaction is an individual smallest unit of work in DBMS, similar to a process in programming.

In a banking system, transactions refer to operations such as withdrawing or depositing money.
These operations involve updating records, such as increasing or decreasing the balance amount in an account.
In DBMS, these operations are considered transactions, not processes, because they deal purely with the database.

A transaction is a single unit of work that can be executed independently.
It's a self-contained operation that can be committed or rolled back as a whole.
Transactions are used to ensure data consistency and integrity in a database.