CSS Computer Science Paper II Past Paper 2018

Briefly describe the functionality of the following CPU special-purpose registers: Instruction Register (IR), Memory Data Register (MDR) and Program Counter (PC).

Differentiate between Address, Data and Control bus.

Discuss instruction pipelining in the context of fetch-decode-execute cycle.

Differentiate between hub, bridge, switch and router.

Discuss how Network Address Translation (NAT) works and why is it useful?

Elaborate the working of multiplexing/de-multiplexing at the transport layer.

There are three processes $P_{A}$, $P_{B}$ and $P_{C}$ and three resources $R_{A}$, $R_{B}$ and $R_{C}$. Resources $R_{A}$ and $R_{B}$ have one instance each while resource $R_{C}$ has two instances. $P_{A}$ is holding one instance of $R_{C}$ and has requested for $R_{A}$. Process $P_{B}$ is holding $R_{A}$ and has requested for $R_{B}$. $R_{B}$ is allocated to $P_{C}$ which has also requested an instance of $R_{C}$. Represent the scenario with a resource allocation graph. Discuss whether there is a deadlock or not? If yes, which processes are blocked?

In the context of Paging, consider the case where memory addresses are 32 bits i.e. 20 bits Virtual Page Numbers and 12 bits of offset. How many virtual pages are there and what is the size of each page? Given the virtual address 0x7589, find the virtual page number and offset. If the respective page table entry contains 0x900DF, find the physical address.

In the context of I/O management, differentiate between Pooling and Interrupts.

Given two relations $R$ and $S$, where $R$ contains $M$ tuples, $S$ contains $N$ tuples, and $M > N > 0$, give the minimum and maximum possible sizes (in tuples) for the resulting relation produced by each of the following relational algebra expressions.

Elaborate the concepts of super key, candidate key and foreign key with examples.

Discuss the difference between physical data independence and logical data independence.

Differentiate between image sampling and quantization. Discuss how these concepts relate to spatial and intensity resolutions.

In the context of image smoothing, discuss the differences between mean and median filters.

For the image ‘X’ shown in Figure 1, show the result of applying the given morphological operators. Assume zero padding for border pixels.

Perform histogram equalization on the 8-bit image shown in Figure 2.

For the 3x3 image shown in the following, apply the horizontal and vertical Sobel operators and compute the magnitude of gradient at the central pixel with intensity value 50.

In the context of compression, differentiate between coding, spatial and temporal redundancies.

Elaborate the concept of three tier architecture with reference to presentation, business logic and data access layers.

Differentiate between XHTML and XML.

Discuss Agile and Water Fall methodologies in the context of web application development.