Computer Science, asked by mohdaaish6103, 1 year ago

Discuss the different types of transaction failures in dbms.

Answers

Answered by vibhadudile60
5

There are many types of failures that can affect database processing. Some failures affect the main memory only, while others involve secondary storage. Following are the types of failure:

Hardware failures: Hardware failures may include memory errors, disk crashes, bad disk sectors, disk full errors and so on. Hardware failures can also be attributed to design errors, inadequate (poor) quality control during fabrication, overloading (use of under-capacity components) and wearout of mechanical parts.

Software failures: Software failures may include failures related to softwares such as, operating system, DBMS software, application programs and so on.

Answered by yoodyannapolis
0

Different types of transaction failures are given below:-

Explanation:

  • Hard Failure:- Hard failure is the type of loss that induces data loss in permanent or non-volatile disk storage.
  • Soft Failure :- Soft failure is the type of loss that triggers the lack of volatile memory on the device, not really the loss of permanent data.
  • Network Failure:-  These involve errors caused in the software system owing to the fragmented nature of the information as well as the transmission of information across the web.
  • Computer failure (System crash):- Hardware, software, or system error can cause a machine to malfunction or crash after continuous operation.
  • Disk failure:- Some disk blocks can lose the data due to reading or writing failure or to a disk read/write head collapse.  
  • Media Failure:- Database failures typically leave database systems inaccessible for a few hours before restoration is completed, particularly in broad system apps and high transaction levels.

Learn more:-

brainly.in/question/9151105

Similar questions