SINDH PUBLIC SERVICE COMMISSION, HYDERABAD.
Combined Competitive Examination, 2021.
Computer Science(Paper-II)
Tuesday the 15th February, 2022.
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 Discuss the role of session support also discuss the role of internal representation conversion. 20
02 (A) Explain different file allocation methods with the help of diagrams. 10
(B) Discuss and explain why does fixed portioning suffer from internal fragmentation whereas dynamic partitioning suffers from external fragmentation. Illustrate the reason with suitable examples. 10
03 (A) Discuss the role of each layer in the OSI network model. 10
(B) Describe the feature operation and use of well-known TCP/IP network layered services. 10
04 What is Preemptive Multitasking? 10
05 Elaborate the term Machine instruction. Discuss the different characteristics of machine instruction. 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 What is the role of edge detection in image segmentation. 20
07 (A) Discuss with appropriate examples the error reporting functionality using MySQL functions to report errors. 10
(B) Write a program to connect PHP with MySQL using mysqli connect(). List out the database operations. 10
08 (A) Describe using suitable example the dilation and erosion morphological transformations on a binary image. 10
(B) Explain the concept of edge detection in digital image processing. Discuss about the Local processing for edge linking. 10
09 Discuss the role of Demoralization process in Database systems. 10
10 Describe the following terms: 10
(i) Normalization, 2NF, 3NF and 4NF in DBMSs. (ii) ACID Transactions in DBMS.
****************************************************