Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and then apply a 5% interest.
1. T1 start
2. T1 B old=1200 new=10000
3. T1 M old=0 new=2000
4. T1 commit
5. T2 start
6. T2 B old=10000 new=10500
7. T2 commit
Suppose the database system crashes just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?
(A) We must redo log record 6 to set B to 10500
(B) We must undo log record 6 to set B to 10000 and then redo log records 2 and 3
(C) We need not redo log records 2 and 3 because transaction T1 has committed
(D) We can apply redo and undo operations in arbitrary order because they are idempotent.

Which one of the following is a top-down parser?
(A) Recursive descent parser
(B) Shift left associative parser
(C) SLR(k) parser
(D) LR(k) parser

Which grammar rules violate the requirement of the operator grammar? A, B, C are variables and a, b, c are terminals

1) A → BC2) A → CcBb3) A → BaC4) A → ε

(A) 1 only
(B) 1 and 2 only
(C) 1 and 3 only
(D) 1 and 4 only

Increasing the RAM of a computer typically improves performance because:
(A) Virtual Memory increases
(B) Larger RAMs are faster
(C) Fewer page faults occur
(D) Fewer segmentation faults occur

How many bits internet address is assigned to each host on a TCP/IP internet which is used in all communication with the host?
(A) 16 bits
(B) 32 bits
(C) 48 bits
(D) 64 bits

The DNS maps the IP address to
(A) A binary address as strings
(B) An alphanumeric address
(C) A hierarchy of domain names
(D) A hexadecimal address

In a class B subnet, we know the IP address of one host and the mask as given below:

IP address: 125.134.112.66Mask: 255.255.224.0

What is the first address(Network address)?
(A) 125.134.96.0
(B) 125.134.112.0
(C) 125.134.112.66
(D) 125.134.0.0

A T-switch is used to
(A) Control how messages are passed between computers
(B) Echo every character that is received
(C) Transmit characters one at a time
(D) Rearrange the connections between computing equipments

What frequency range is used for microwave communications, satellite and radar?
(A) Low frequency: 30 kHz to 300 kHz
(B) Medium frequency: 300 kHz to 3 MHz
(C) Super high frequency: 3000 MHz to 30000 MHz
(D) Extremely high frequency: 30000 kHz

Consider an uncompressed stereo audio signal of CD quality which is sampled at 44.1 kHz and quantized using 16 bits. What is required storage space if a compression ratio of 0.5 is achieved for 10 seconds of this audio?
(A) 172 KB
(B) 430 KB
(C) 860 KB
(D) 1720 KB