GATE 1996 CS Computer Science Question Paper
SECTION - A
1. Write in your answer book the correct or the most appropriate answer to the following multiple choice questions by writing the corresponding letter a, b, c or d against the sub-question number.
c c 1.1 Let A and B be sets and let and A B denote the complements of the sets A and B. the set (a œ b) (b-a) (a n b) is equal to.
c c c c (a) A B (b) A B (c) A n B (d) A B n
1.2 Let X = {2,3,6,12,24}, Let = be the partial order defined by X = Y if x divides y.
Number of edge as in the Hasse diagram of (X, = ) is
(a) 3 (b) 4
(c) 9 (d) None of the above
X Y and 1.3 Suppose X and Y are sets and are their respective cardinalities. It is given that there are exactly 97 functions from X to Y. from this one can conclude that
X Y = = 1, 97 (b) 97, 1 X Y = = (a)
(c) 97, 97 X Y = = (d) None of the above
1.4 Which of the following statements is false?
(a) The set of rational numbers is an abelian group under addition.
(b) The set of integers in an abelian group under addition.
(c) The set of rational numbers form an abelian group under multiplication.
(d) The set of real numbers excluding zero in an abelian group under
multiplication.
1.5 Two dice are thrown simultaneously. The probability that at least one of them will have 6 facing up is
1 1 25 11
(a) (b) (c) (d)
36 3 36 36
1.6 The formula used to compute an approximation for the second derivative of a function f at a point X is.
0
( ) ( ) ( ) ( )
f x h fx h + + - f x h fx h + - -
0 0 0 0 (b) (a)
2 2 h
( ) ( ) ( ) ( ) ( ) ( )
f x h f x f x h + + + - 2 f x h f x f x h + - + - 2
(c) 0 0 0 0 0 0 (d)
2 2 h h
1.7 Let Ax = b be a system of linear equations where A is an m × n matrix and b is a m × 1 column vector and X is a n × 1 column vector of unknows. Which of the following is false?
(a) The system has a solution if and only if, both A and the augmented matrix [A b] have the same rank.
(b) If m < n and b is the zero vector, then the system has infinitely many
solutions.
(c) If m = n and b is non-zero vector, then the system has a unique solution.
(d) The system will have only a trivial solution when m = n, b is the zero vector and rank (A) = n.
1.8 Which two of the following four regular expressions are equivalent? ( e is the
empty string).
(i) (00) * ( e + 0)
(ii) (00)*
(iii) 0*
(iv) 0(00)*
(a) (i) and (ii) (b) (ii) and (iii) (c) (i) and (iii) (d) (iii) and (iv)
1.9 Which of the following statements is false?
(a) The Halting problem of Turing machines is undecidable.
(b) Determining whether a context-free grammar is ambiguous is undecidbale.
(c) Given two arbitrary context-free grammars G and G it is undecidable
1 2
whether L(G ) = L(G ).
1 2
(d) Given two regular grammars G and G it is undecidable whether L(G ) =
1 2 1
L(G ).
2
1.10 Let L S * where S = {a, b}. which of the following is true?
{ }
(a) L x x = has an equal number of a's and b's is regular
{ }
n n L a b n = = 1 is regular (b)
{ }
(c) L x x = has more a's and b's is regular
{ }
m n (d) L a b m n = = = , 1 is regular
1.11 Which of the following is false?
n n ( ) ˜ '
(a) log 100 log 100 n = (b) log 0 loglog n n = ÷
«
( ) ( ) x y (c) If 0 then 0 < < = x y n n (d) 2 0 n nk
Join discussion of this test paper at http://forum .gatem entor.com
1.12 Consider the following statements:
(i) First-in-first out types of computations are efficiently supported by STACKS.
(ii) Implementing LISTS on linked lists is more efficient than implementing LISTS
on an array for almost all the basic LIST operations.
(iii) Implementing QUEUES on a circular array is more efficient than
implementing QUEUES on a linear array with two indices.
(iv) Last-in-first-out type of computations are efficiently supported by QUEUES.
(a) (ii) and (iii) are true (b) (i) and (ii) are true
(c) (iii) and (iv) are true (d) (ii) and (iv) are true
1.13 An advantage of chained hash table (external hashing) over the open addressing scheme is
(a) Worst case complexity of search operations is less?
(b) Space used is less (c) Deletion is easier
(d) None of the above
1.14 In the balanced binary tree in Fig.1.14 given below, how many nodes will become unbalanced when a node is inserted as a child of the node —g"?
(a) 1 (b) 3 (c) 7 (d) 8
1.15 Which of the following sequences denotes the post order traversal sequence of the tree of question 1.14?
(a) f e g c d b a (b) g c b d a f e (c) g c d b f e a (d) f e d g c b a
1.16 Relative mode of addressing is most relevant to writing
(a) coroutines (b) position œ independent code
(c) shareable code (d) interrupt handlers
1.17 The pass numbers for each of the following activities
(i) object code generation
(ii) literals added to literal table
(iii) listing printed
(iv) address resolution of local symbols that occur in a two pass assembler
respectively are
(a) 1, 2, 1, 2 (b) 2, 1, 2, 1 (c) 2, 1, 1, 2 (d) 1, 2, 2, 2
1.18 The process state transition diagram in Fig.1.8 is representative of
TERMINATED
NEW
RUNNING READY
BLOCKED
(a) a batch operating system
(b) an operating system with a preemptive scheduler
(c) an operating system with a non-preemptive scheduler
(d) a uni-programmed operating system.
1.19. A critical section is a program segment
(a) which should run in a certain specified amount of time
(b) which avoids deadlocks
(c) where shared resources are accessed
(d) which must be enclosed by a pair of semaphore operations, P and V
1.20. Which of the following is an example of spooled device?
(a) A line printer used to print the output of a number of jobs.
(b) A terminal used to enter input data to a running program.
(c) A secondary storage device in a virtual memory sytem.
(d) A graphic display device.
1.21. A ROM is sued to store the table for multiplication of two 8-bit unsigned integers.
The size of ROM required is
(a) 256 × 16 (b) 64 K × 8 (c) 4 K × 16 (d) 64 K × 16
1.22. Number of machine cycles required for RET instruction in 8085 microprocessor is
(a) 1 (b) 2 (c) 3 (d) 5
1.23. Both's algorithm for integer multiplication gives worst performance when the multiplier pattern is
(a) 101010 …..1010 (b) 100000 …..0001
(c) 111111 …..1111 (d) 011111 …..1110
1.24. For the daisy chain scheme of connecting I/O devices, which of the following statements is true?
(a) It gives non-uniform priority to various devices.
(b) It gives uniform priority to all devices.
(c) It is only useful for connecting slow devices to a processor device.
(d) It requires a separate interrupt pin on the processor for each device.
1.25 Consider the following floating-point number representation.
31 24 23 0
Exponent Mantissa
The exponent is in 2's complement representation and mantissa is in the sign magnitude representation. The range of the magnitude of the normalized numbers in this representation is
(a) 0 to 1 (b) 0.5 to 1
( )
-23 - 2 3 (c) 2 to 0.5 (d) 0.5 to 1-2
2. Write in your answer book the correct or the most appropriate answer to the following multiple choice questions by writing the corresponding letter a, b, c or d against the sub-question number.
2.1 Let R denotes the set of real numbers. Let f:R × R ‰ R × R be a bijective function defined by f(x,y)=(x+y,x-y). the inverse function of f is given by
˜ ' ( ) ( ) ( ) 1 1
1 - (a) f x y x y x y , , = (b) f x y x y x y , , = - + - 1 ÷
+ - «
( ) ( ) ( ) ( ) ˜ ' x y x y + -
» ÿ f x y x y x y , 2 ,2 = - + - 1 (c) f x y , , = (d) - 1 / ÷
2 2 «
2.2. Let R be a non-empty relation on a collection of sets defined by A R B if and only if A n B = f . Then, (pick the true statement)
(a) R is reflexive and transitive
(b) R is symmetric and not transitive
(c) R is an equivalence relation
(d) R is not reflexive and not symmetric
2.3. Which of the following is false? Read as AND, as OR, ~ as NOT, as one way ‰implication and as two way implication.
( ) ( ) ( ) ( ) ( )
(a) x y x y (b) - - - x y x y x
( ) ( ) ( ) ( ) ( )
(c) x x (d) x y x y - -
2.4. Which one of the following is false?
(a) The set of all bijective functions on a finite set forms a group under function composition.
(b) The set {1,2, ……., p œ1} forms a group under multiplication mod p where p is a prime number.
(c) The set of all strings over a finite alphabet forms a group under
concatenation.
(d) A subset s f of G is a subgroup of the group if and only if for any
pair of elements a, b s, a* b s. - 1
2.5. Newton-Raphson iteration formula for finding 3 , c where c > 0 is,
2 3 x c + 2 3 x c - 3 3
(a) x x = (b) x x = n n
n n + 1 2 3 + 1 2 3
n n
2 x c + 2 x c - 3 3
(c) x x = (d) x x = n n
n n + 1 2 3 + 1 2 3
n n
- a » ÿ » ÿ
2.6. The matrices cos sin 0 and commute under multiplication … Ÿ … Ÿ
sin cos 0 b / /
(a) if a = b or = n p , is an integer (b) always
(c) never (d) if a cos b sin
2.7. The probability that top and bottom cards of a randomly shuffled deck are both aces in
(a) 4 4 (b) 4 3 (c) 4 3 (d) 4 4 × × × ×
52 52 52 52 52 51 52 51
2.8. If L and L are context free languages and R a regular set, one of the languages below is not necessarily a context free language. Which one?
(a) L , L (b) L L (c) L R (d) L L n n
1 2 1 2 1 1 2
2.9. Define a context free languages L {0,1} init (L) = {u/uv L for some in =
{{0,1}} (in other words, init(L) is the set of prefixes of L)
Let L {w/w is nonempty and has on equal number of 0's and 1's
Then init (L) is
(a) the set of all binary strings with unequal number of 0's and 1's
(b) the set of all binary strings including the null string
(c) the set of all binary strings with exactly one more 0's than the number of 1's
or one more 1 than the number of 0's.
(d) None of the above
2.10. The grammar whose productions are
if id then ‰
if id then else ‰
id:=id ‰
is ambiguous because
(a) the sentence
if a then if b then c:=d
(b) the left most and right most derivations of the sentence
if a then if b then c:=d
give rise top different parse trees
(c) the sentence
if a then if b then c:=d else c:=f
has more than two parse trees
(d) the sentence
if a then if then c:=d else c:=f
has two parse trees
2.11. The minimum number of interchanges needed to convert the array
89, 19, 40, 17, 12, 10, 2, 5, 7, 11, 6, 9, 70
(a) 0 (b) 1 (c) 2 (d) 3
2.12. The recurrence relation
T(1) = 2
˜ ' n
T(n) = 3 4 T n + ÷
«
Has the solution T(n) equal to
(a) O(n) (b) O (log n)
˜ ' 3
(c) O n (d) None of the above ÷ 4
÷
«
2.13. The average number of key comparisons done on a successful sequential search in list of length n is
n n (d) 1 n - +
(a) log n (b) 1 (c) 2
2 2
2.14. A binary search tree is generated by inserting in order the following integers:
50, 15, 62, 5, 20, 58, 91, 3, 8, 37, 60, 24
The number of nodes in the left subtree and right subtree of the root respectively
is
(a) (4, 7) (b) (7, 4) (c) (8, 3) (d) (3,
2.15. Quick-sort is run on two inputs shown below to sort in ascending order
(i) 1,2,3 ….n
(ii) n, n œ 1, n œ 2, …. 2, 1
Let C and C be the number of comparisons made for the inputs (i) and (ii)
1 2
respectively. Then,
(a) C < C (b) C > C (c) C = C
1 2 1 2 1 2
(d) we cannot say anything for arbitrary n.
2.16. Which of the following macros can put a macro assembler into an infinite loop?
(i) MACRO M1, X
IF EQ, X: if X=0 then ….
M1 X + 1
ENDC
IF NE, X: if X O then ……
WORD X: address (X) is stored here
ENDC
ENDM
(ii) MACRO M2,X
IF EQ, X
M2 X
ENDC
IF NE, X
WORD X + 1
ENDC
ENDM
(a) (ii) only (b) (i) only
(c) both (i) and (ii) (d) None of the above
2.17. The correct matching for the following pairs is
(A) Activation record (1) Linking loader
(B) Location counter (2) Garbage collection
(C) Reference counts (3) Subroutine call
(D) Address relocation (4) Assembler
(a) A œ 3 B œ 4 C œ 1 D - 2 (b) A œ 4 B œ 3 C œ 1 D - 2
(c) A œ 4 B œ 3 C œ 2 D - 1 (d) A œ 3 B œ 4 C œ 2 D - 1
2.18. A 1000 Kbyte memory is managed using variable partitions but to compaction. It currently has two partitions of sizes 200 Kbytes and 260 Kbytes respectively. The smallest allocation request in Kbytes that could be denied is for
(a) 151 (b) 181 (c) 231 (d) 541
2.19. A solution to the Dining Philosophers Problem which avoids deadlock is
(a) ensure that all philosophers pick up the left fork before the right fork
(b) ensure that all philosophers pick up the right fork before the left fork
(c) ensure that one particular philosopher picks up the left fork before the right
fork, and that all other philosophers pick up the right fork before the left fork
(d) None of the above
2.20. Four jobs to be executed on a single processor system arrive at time 0 in the + order A, B, C, D. their burst CPU time requirements are 4, 1, 8, 1 time units respectively. The completion time of A under round robin scheduling with time
slice of one time unit is
(a) 10 (b) 4 (c) 8 (d) 9
2.21. Consider the circuit in Fig.2.21 which has a four fit binary number b b b b as
3 2 1 0
input and a five bit binary number, ddddd as output. b b b b
3 2 0 4 3 2 1 0 1
" f '
(a) Binary of Hex conversion
(b) Binary to BCD conversion
(c) Binary to grey code conversion
C in " f ' C out
(d) Binary to radix-12 conversion.
Binary adder
d
4
d d d d
0 3 2 1
2.22. Consider the circuit in Fig.2.22 f implements
(a) ABC ABC ABC (b) A + B + C + +
(c) (d) AB+BC+CA A B C
2.23. Consider the following state table in Fig.2.23 for a sequential machine. The number of states in the minimized machine will be
(a) 4 (b) 3 (c) 2 (d) 1
2.24. What is the equivalent Boolean expression in product-of-sums form for the Karnaugh map given in Fig.2.24.
AB
00 01 11 20
CD (a) BD BD +
( )( ) 00 1 1
(b) B C D B C D + + + +
( )( ) 01 1 1
(c) B D B D + +
( )( ) 1 1 11
(d) B D B D + +
1 1 10
2.25. A micro program control unit is required to generate a total of 25 control signals. Assume that during any microinstruction, at most two control signals are active. Minimum number of bits required in the control word to generate the required control signals will be
(a) 2 (b) 2.5 (c) 10 (d) 12
3. Let f be a function defined by
2 x x for 1 =
( )
f x ax bx c x = + + = for 1 2 2
x d x + > for 2
Find the values for the constants a; b; c and d so that f is continuous and
differentiable everywhere on the real line.
4. A binary search tree is used to locate the number 43. Which of the following probe sequences are possible and which are not? Explain.
(a) 61 52 14 17 40 43
(b) 2 3 50 40 60 43
(c) 10 65 31 48 37 43
(d) 81 61 52 14 41 43
(e) 17 77 27 66 18 43
5. A logic network has two data inputs A and B, and two control inputs C and C . It implements the function F according to the following table.
C C F
1 2
0 0 A B +
0 1 A + B
1 0 A B
Implement the circuit using one 4 to AB Multiplexor, one 2-input Exclusive OR gate, one 2-input AND gate, one 2-input OR gate and one Inverter.
6. An 8085 based system has an output port with address 00H. Consider the
following assembly language program.
ORG 0100H
MVI A, 00H
LXI H, 0105H
PCHL
HLT
(a) What does the program do with respect to the output port ff H?
(b) Show the waveforms at the three least significant bits of the port ff H.
7. A demand paged virtual memory system uses 16 bit virtual address, page size of 256 bytes, and has 1 Kbyte of main memory. LRU page replacement is
implemented using list, whose current status (page numbers in decimal) is
17 1 63
LRU page
For each hexadecimal address in the address sequence given below,
00FF, 010D, 10FF 11B0
indicate,
(i) the new status of the list
(ii) page faults, if any, and
(iii) page replacements, if any.
SECTION B
Answer any TEN questions from this section. All questions carry equal marks.
8. Let F be the collection of all functions f:{1,2,3} ‰ {1,2,3}. If f and g F, define an equivalence relation ~ by f ~ g if and only if f(3) = g.
(a) Find the number of equivalence classes defined by ~
(b) Find the number of elements in each equivalence class.
{ }
> 9. The Fibonacci sequence f f f f , , is defined by the following recurrence:
1 2 3 n
f f f n f f = + = = = , 1; 1 : 1 :
n n n 2 1 2 1 + +
Prove by induction that every third element of the sequence is even.
» ÿ » ÿ a a b b
11 12 11 12 10. Let A B = = and be two matrices such that … Ÿ … Ÿ
a a b b / / 21 22 21 22
AB = I. Let 1 0 C A» ÿ = and CD = 1. Express the elements of D in terms of the … Ÿ
1 1 /
elements of B.
11. Let G be a context-free grammar where G = ({S, A, B, C}, {a, b, d}, P,S) with the productions in P given below.
S ‰ ABAC
A ‰ aA| e
B ‰ bB ‰ e
C ‰ d
( e denoted the null string). Transform the grammar G to an equivalent context-free grammar G that has no e productions and no unit productions. ( A unit
production is of the form x ‰ y, and y are non terminals).
12. Given below are the transition diagrams (Fig.12) for two finite state machines M
1
and M recognizing languages L and L respectively.
2 1 2
(a) Display the transition diagram for a machine that recognizes L L , obtained
1 2
from transition diagrams for M and M by adding only and transitions and no
1 2
new states.
(b) Modify the transition diagram obtained in part (a) obtain a transition diagram
for a machine that recognizes (L L ) by adding only e transitions and no new
1 2 states.
(Final states are enclosed in double circles).
13. Let Q = (q , q ) (a,b), (a, b, Z) d , qi, Z, f ) be a pushdown automaton accepting
1 2
by empty stack for the language which is the set of all nonempty even
palindromes over the set {a,b}. Below is an incomplete specification of the
transition d. complete the specification. The top of stack is assumed to be at the right end of the string representing stack contents.
{ } ( ) ( )
d (1) q a Z q Za , , , =
1 1
{ } ( ) ( )
d (2) q b Z q Zb , , , =
1 1
( ) { }
d >> >> (3) q a a , , , =
1
( ) { }
d >> >> (4) q b b , , , =
1
{ } ( ) ( )
d e (5) q a a q ,, , =
2 2
{ } ( ) ( )
d e (6) q b b q , , , =
2 2
{ } ( ) ( )
d e e (7) q Z q ,, , =
2 2
14. A two dimensional array A[1- n] [1 œ n] of integers is partially sorted if
e - - < + ij n A i j A i j , 1 1 1 and » ÿ » ÿ » ÿ » ÿ » ÿ / / / / /
» ÿ A i j A i j » ÿ» ÿ » ÿ» ÿ < + 1 / / / / /
Fill in the blanks:
(a) The smallest item in the array is at A[i] [j] where i =
and j = …………
(b) The smallest item is deleted. Complete the following O(n) procedure to insert
item x (which is guaranteed to be smaller than any item in the last row or
column) still keeping A partially sorted.
procedure insert (x integer)
' var j j:integer;
begin
(1) i: =1; j:=A[i] [j]:=x;
(2) while (x > or x >) do
(3) if A[ i + 1] [j] n [i] ]j] then begin
(4) A [i] [j]:= A[i +1] [j]; i: =i + 1
(5) end
(6) else begin
(7)
(8) end
(9) A [i] [j]:=
end
15. Insert the characters of the string K R P C S N Y T J M into a hash table of size
10.
Use the hash funtion
H(x) = (ord (x) œ ord ("a') + 1) mod 10
And linear probing to resolve collisions.
(a) Which insertions cause collisions?
(b) Display the final hash table?
16. A complete, undirected, weighted graph G is given on the vertex {0, 1 …., n œ 1}
for any fixed "n'. Draw the minimum spanning tree of G if
(a) the weight of the edge (u, v) is |u œ v|
(b) the weight of the edge (u, v) is u + v
17. Let G be the directed, weighted graph shown below in Fig.4
We are interested in the shortest paths from A.
(a) Output the sequence of vertices identified by the Dijkstra's algorithm for
single source shortest path when the algorithm is started at node A.
(b) Write down sequence of vertices in the shortest path from A to E.
(c) What is the cost of the shortest path from A to E?
18. Consider the following program that attempts to locate an element x in an array a [ ] using binary search. Assume N > 1. The program is erroneous. Under what conditions does the program fail?
var i.j.k:integer; x:integer.
a:=array; [1 … N] of integer.
begin i:1;=n;
repeat k:(i+j) div 2;
if a [k] < x then i:=k
else j:=k
until (a/ =x) or (i n =j);
if (a [k] = x) then
writeln ("x is not in the array')
else
writeln ("x' is not in the array')
end;
19. Consider the following program in pseudo-Pascal syntax. What is printed by the program if parameter a is procedure test 1 is passed as
(i) call-by-reference parameter?
(ii) call-by-value-result parameter?
program Example (input, output)
var b: integer;
procedure test 2;
begin b: = 10 end
procedure test 1 (a:integer);
begin a:5;
writeln ("point 1: "a,b);
test 2;
wrote;m("point: "a,b);
end;
begin (*Example*)
b:=3; test ] (b);
writeln ("point 3: "b)
end
20. Consider the syntax-directed translation schema (SETS) shown below:
E ‰ E + E {print —+"}
E ‰ E * E {print —."}
E ‰ id {print id.name}
E ‰ (E)
An LR œ parser executes the actions associated with the productions immediately after a reduction by the corresponding production. Draw the parse tree and write the translation for the sentence.
(a + b)* (c + d), using SDTS given above.
21. The concurrent programming constructs fork and join are as below:
fork which creates a new process executing from the specified label
join which decrements the specified synchronization variable (by 1)
and terminates the process if the new value is not 0.
Show the precedence graph for S1, S2, S3, S4 and S5 of the concurrent program
below.
N = 2
M = 2
fork L3
fork L4
S1
L1 : join N
S3
L2: join M
S5
L3:S2
goto L1
L4:S4
goto L2
next:
22. A computer system uses the Banker's Algorithm to deal with deadlocks. Its current state is shown in the tables below, where P0, P1, P2 are processes, and R0, R1, R2 are resoures types.
Maximum Need Current Allocation Available
R0 R1 R2 R0 R1 R2 R0 R1 R2
P0 4 1 2 P0 1 0 2 2 2 0
P1 1 5 1 P1 0 3 1
P2 1 2 3 P2 1 0 2
(a) Show that the system can be in this state.
(b) What will system do on a request by process P0 for one unit of resource type R1?
23. A file system with a one-level directory structure is implemented on a disk with disk block size of 4 K bytes. The disk is used as follows:
Disk-block 0: File Allocation Table, consisting of one 8-bit entry per date
block, representing the data block address of the next date
block in the file
Disk block 1: Directory, with one 32 bit entry per file:
Disk block 2: Data block 1;
Disk block 3: Data block 2; etc.
(a) What is the maximum possible number of files?
(b) What is the maximum possible file size in blocks?
24. Consider the synchronous sequential circuit in Fig.5.
Fig.5
(a) Draw a state diagram, which is implemented by the circuit. Use the following names for the states corresponding to the values of flip-flops as given below.
Q1 Q2 Q3 State
0 0 0 S
0
0 0 1 S
1
- - - -
- - - -
- - - -
1 1 1 S
7
(b) Given that the initial of the circuit is S , identify the set of states, which are 4 not reachable.
25. A hard disk is connected to a 50 MHz processor through a DMA controller. Assume that the initial set-up of a DMA transfer takes 1000 lock cycles for the processor, and assume that the handling of the interrupt at DMA completion requires 500 clock cycles for the processor. The hard disk has a transfer rate of 2000 Kbytes/sec and average block size transferred is 4 K bytes. What fraction of the processor time is consumed by the disk, if the disk is actively transferring 100% of the time?
Level 1 (Cache memory) Level 1 (Cache memory)
Access time = 50 nsec/byte Access time = 200 nsec/byte
Size Hit ratio Size Hit ratio
8 Kbytes 0.80 4 Kbytes 0.98
16 Kbytes 0.90 16 Kbytes 0.99
64 Kbytes 0.95 64 Kbytes 0.995
Size Hit ratio
250 M bytes 1.0
26. A computer system has a three level memory hierarchy, with access time and hit ratios as shown below:
Level 1 (Cache memory) Level 2 (main memory) Level 3
Access time = 50 nsec/byte Access time = 200 nsec/byte Access time = 5 sec/byte Size Hit ratio Size Hit ratio Size Hit ratio
8 M byte 0.80 4M byte 0.98 260 Mbyte 1.0
16 M byte 0.90 16 M byte 0.99
64 M byte 0.95 64 M byte 0.995
(a) What should be the minimum sizes of level 1 and 2 memories to achieve an average access time of less than 100 nsec?
(b) What is the average access time achieved using the chosen sizes of level 1 and level 2 memories?
27. A library relational database system uses the following schema
USERS (User #, User Name, Home Town)
BOOKS (Books # Book Title, Author Name)
ISSUED (Book #, User #, Date)
Explain in one English sentence, what each of the following relational algebra queries is designed to determine
(a) s User #=6 (11 User #, Book Title ((USERS ISSUED) BOOKS))
(b) s Author Name (BOOKS ( s Home Town) = Delhi (USERS ISSUED)))