1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
mariarad [96]
3 years ago
13

A database has two tables Rand S with 100 tuples each. Exactly two transactions, 11 and T2, execute concurrently on the database

. T1 inserts a tuple in R and after some time decides to abort. T2 computes the difference: SELECT count(*) from R - SELECT count(*) from s and inserts as many tuples in S. After the transactions complete, R has 100 tuples and S has 101 tuples. Which of the following is possible?
a. The transactions executed in the REPEATABLE READ isolation level.
b. The transactions executed in the READ UNCOMMITTED isolation level.
C. The transactions executed in the READ COMMITTED isolation level.
d. This outcome is not possible in any of these isolation levels.
Computers and Technology
1 answer:
poizon [28]3 years ago
5 0

Answer:

a. The transaction executed in the REPEATABLE READ isolation level.

Explanation:

Database management system are used by businesses to organize and handle large data. There are 3 types of DBMS :

1- Hierarchical Database management system

2- Network Database management system

3- Object oriented Database management system.

You might be interested in
Abby is creating a professional development plan to advance in her current career. She has identified what job she wants and wha
Andre45 [30]

Evaluate her current skills and identify areas of improvement

5 0
3 years ago
What is the output of the following program?
Alex787 [66]

Answer:

B:2 should be the first answer

C: 14 the second

7 0
3 years ago
What are 3 ways to get friends to stop texting and driving?
Leni [432]
Not allow them to use their phone, tell them you won’t get in the car with them unless they stop texting and driving, inform their parents
3 0
3 years ago
Read 2 more answers
What is a feature of webmail
Fantom [35]

Answer:

Webmail allows the users to access their emails as long as they have access to an Internet connection and a web browser. This also means that the user cannot read an old email or draft a new email offline.

8 0
3 years ago
Which field in a Transmission Control Protocol (TCP) header provides the next<br> expected segment?
Papessa [141]

In a Transmission Control Protocol (TCP) header next  Expected segment is provided by Acknowledgment Number

Explanation:

  • TCP is one of the main protocols of the Internet protocol suite. It originated in the initial network implementation in the Internet Protocol.
  • The fields in TCP Segment Header are Source Port, Destination Port, Sequence Number, Acknowledgement Number, Header Length, Flags, Window Size, TCP Checksum and Urgent Pointer.
  • The Acknowledgment Number is a  32 Bit number field which indicates the next sequence number that the sending device is expecting from the other device.
  • The SYN packets consume one sequence number, so actual data will begin at ISN+1. The sequence number is the byte number of the first byte of data in the TCP packet sent.
  • If the acknowledgment flag is set in the flags field, the acknowledgment number field holds the sequence number of the next byte that the receiver expects.
3 0
4 years ago
Other questions:
  • Analog footage can be digitized using video _____ equipment.â
    7·1 answer
  • Ith what frequency do balance changes happen in the game?​
    11·2 answers
  • A printer is connected locally on Computer1 and is shared on the network. Computer2 installs the shared printer and connects to
    10·1 answer
  • Which tag will you use if you want your web page to look the same as your source code?
    11·1 answer
  • A cell reference =SUM(sheet1.A1,sheet 2.A2) will place the results in which of the following, the current worksheet, worksheet 1
    7·1 answer
  • Sequence encryption is a series of encryptions and decryptions between a number of systems, wherein each system in a network dec
    9·1 answer
  • A ________ is a gateway service that permits users to log in once, with one specific user ID and password, to gain access to mul
    8·1 answer
  • Convert (675.6)8 to hexadecimal. (use base 2 instead of base 10 as the intermediate base for conversion).
    15·1 answer
  • Need answer ASAP!!!!!
    6·1 answer
  • How many different textile items would you find at a festival? (please list 5 items)
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!