SINDH PUBLIC SERVICE COMMISSION, HYDERABAD.
Combined Competitive Examination, 2020.
Computer Science(Paper-II)
Wednesday the 18th November, 2020.
Time: 02:00 pm to 05: 00 pm Maximum marks. 100
=================================================
Question No. Marks
SECTION-A
Note: This Section carries Total 50 marks. Attempt any Three questions from this Section by selecting Two questions of 20 marks and 01 question of 10 marks.
01 (A) Discuss the Internal Memory and External Memory. 10
(B) Compare the Cache Memory and Auxiliary Memory. Outline the working mechanism of Cache Memory with the help of a diagram. 10
02 (A) Elaborate on the Multicore Microprocessors‟ Architecture by
differentiating core i3, core i5 and corei7 microprocessors. How does the hyper threading technology improve the performance of microprocessors in Multicore Environment. 10
(B) Compare the different addressing modes of 8086 Microprocessor
Architecture and provide the interpretation of instructions of respective addressing techniques. 10
03 (A) Describe how computer networks impact in Computer Science. Identify and discuss the key components of a Data Network. 10
(B) Explain the role of Protocol in Network Communication. 10
04 Discuss the role of data modeling. How data modeling gives structure moving to the cloud. 10
05 What is Fragmentation? 10
SECTION-B
Note: This Section carries Total 50 marks. Attempt any Three questions from this Section by selecting Two questions of 20 marks and 01 question of 10 marks.
06 Discuss using your own simple examples and suitable diagrams, the following data modeling concepts. 20
(A) Entity Relationship Diagram (ERD), Entity Types, Entity Instantiations and Identifiers.
(B) Enhanced Entity Relationship Diagram (EERD), Super-Types and Sub-Types
07 Discuss in detail the following in context of Digital image. 20
(i) Histogram of a Digital Image (ii) Smoothing Spatial filter (iii) Sampling and quantization of digital image (iv) Image formation model
08 (A) “A well formed XML document is necessarily valid”. Briefly explain the correctness or otherwise for this XML assertion. Support your answer with a suitable example. 10
(B) XML documents can be validated against DTDs or XML schema. Discuss the benefits and drawbacks of each approach along with suitable examples. 10
09 Write difference between Software Engineering and Web Engineering.
10 What are Cookies? Explain Cookie in PHP.
****************************************************