Suppose that the transaction processing system of your university contains a table in which there is one tuple for each currently registered student.

a. Estimate howmuch disk storage is required to store this table.
b. Give examples of transactions that must lock this entire table if a table-locking
concurrency control is used.


a. 10,000 tuples * 100 bytes/tuple = 1 megabyte.
b. Find all students who are registered in at least one course.

Computer Science & Information Technology

You might also like to view...

The array subscript operator [], when overloaded, cannot:

a. Be used with linked list classes. b. Take a float as an operand. c. Take multiple values inside (e.g., [4,8]). d. Take user-defined objects as operands.

Computer Science & Information Technology

Variables of the boolean data type are useful for

a. evaluating conditions that are either true or false b. working with small integers c. working with very large integers d. evaluating scientific notation

Computer Science & Information Technology

What are some advantages that Vector-Based graphics have over Bitmap Graphical representations (like JPEG, BMP, GIF)?

What will be an ideal response?

Computer Science & Information Technology

Bob Schwartz is a technician working for a local electronics store. While working on some repairs of a customer's computer, he comes across over 60 thousand music files along with software that publishes and shares playlists over the Internet. He calls law enforcement, who obtains a warrant to seize and search the computer. Because the original discovery of the files was the result of an illegal

search this case will not hold up in court. a. True b. False

Computer Science & Information Technology