ISRO Computer Science Previous Year Question Paper 2007 with Solutions ⋆ CSE Study247

ISRO Computer Science Previous Year Question Paper 2007 with Solutions

Questions 46-50 of 80

0% completed (0/80 answered)

Question 46

MCQ · Single Correct 3 mark

Previous Year Question ISRO 2007 PYQ

2-way set-associative cache of 4 blocks (2 sets of 2 blocks). LRU replacement. Sequence of block addresses: 8, 12, 0, 12, 8. Number of cache misses is:

A 2 B 3 C 4 D 5

📘 Solution & Detailed Explanation

🔢 Step-by-Step Solution

Set index = Address mod 2. All addresses (8, 12, 0) map to Set 0.

CODE

Set 0 has capacity 2:
   - 8: Miss -> Set 0: [8]
   - 12: Miss -> Set 0: [8, 12]
   - 0: Miss -> Evicts 8 -> Set 0: [12, 0]
   - 12: Hit -> Set 0: [0, 12]
   - 8: Miss -> Evicts 0 -> Set 0: [12, 8]

Total misses = 4.

Key Points for Revision:
• Set index = Address mod 2.
• All addresses (8, 12, 0) map to Set 0.
• Set 0 has capacity 2:
• 8: Miss -> Set 0: [8]
• 12: Miss -> Set 0: [8, 12]

Question 47

MCQ · Single Correct 3 mark

Previous Year Question ISRO 2007 PYQ

Which commands are used to control access over objects in relational database?

A CASCADE & MVD B GRANT & REVOKE C QUE & QUIST D None of these

Question 48

MCQ · Single Correct 3 mark

Previous Year Question ISRO 2007 PYQ

Which of the following is an aggregate function in SQL?

A Avg B Select C Ordered by D distinct

Question 49

MCQ · Single Correct 3 mark

Previous Year Question ISRO 2007 PYQ

How many ternary logic elements (flits, base-3) are required to represent at least 256 different values?

A 4 B 5 C 6 D 7

Question 50

MCQ · Single Correct 3 mark

Previous Year Question ISRO 2007 PYQ

A view of database that appears to an application program is known as:

A Schema B Subschema C Virtual table D None of these