Suppose that the transaction processing system of your university contains a table in which there is one tuple for each current student.
a. Estimate howmuch disk storage is required to store this table.
b. Give examples of transactions in the student registration system that have to 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.
You might also like to view...
Which of the following statements is false?
a. Functional interfaces are also known as single abstract method (SAM) interfaces. b. Package java.util.function contains six basic functional interfaces BinaryOperator, Consumer, Function, Predicate, Supplier and UnaryOperator. c. There are many specialized versions of the six basic functional interfaces for use with int, long and double primitive values. There are also generic customizations of Consumer, Function and Predicate for binary operations—that is, methods that take two arguments. d. All of these statements are true.
For the Mentcare system, suggest an example of an asset, an exposure, a vulnerability, an attack, a threat and a control, in addition to those discussed in this chapter.
What will be an ideal response?
A _____________ converts computer data into audio tones that can be transmitted over a normal telephone circuit.
Fill in the blank(s) with the appropriate word(s).
Land-grid arrays (LGAs)have two rows of pins that connect the chip to a circuit board.
Answer the following statement true (T) or false (F)