Get premium membership and access revision papers, questions with answers as well as video lessons.
Network Programming Question Paper
Network Programming
Course:Bachelor Of Science In Information Technology
Institution: Kca University question papers
Exam Year:2010
UNIVERSITY EXAMINATIONS: 2010/2011
FIRST YEAR STAGE EXAMINATION FOR THE DEGREE OF BACHELOR
OF SCIENCE IN INFORMATION TECHNOLOGY
BIT 3105: NETWORK PROGRAMMING
DATE: DECEMBER 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE (30 MARKS) - COMPULSORY
a) Define the following terms as used in client/server systems:
i. Application/Business Logic [1 Mark]
ii. Cooperative Processing Methodology [1 Mark]
iii. Heterogeneous Environment [1 mark]
iv. Platform [1 mark]
v. Service [1 mark]
b) Distinguish between the following terms as used in Client/Server systems:
i. User and Client [2 Marks]
ii. Tier and Layer [2 Marks]
iii. Thin Client and Thin Server [2 Marks]
c) The key assets that a network provides to a client/server system are reliability, speed, and
bandwidth. Discuss these assets. [6 Marks]
d) The Transport Layer provides services that are necessary for a Client/Server application. Discuss
any two (2) protocols found on this layer. [2 Marks]
e) Briefly discuss the steps taken by a client when placing a Remote Procedure Call (RPC) in a
Client/Server system. [5 Marks]
2
f) Give any three (3) SQL (Structured Query Language) functions/commands that are used in data
manipulation and their meaning. [3 Marks]
g) Briefly describe any three (3) functional interfaces provided by middleware. [3 Marks]
QUESTION TWO – (TOTAL MARKS: 20)
(a) TCP/IP Protocol suite is considered the best protocol in implementing network applications. Give
three (3) reasons for this preference. [3 Marks]
(b) Describe the reasons which make Distributed Operating Systems suitable for the execution of the
network applications. [6 Marks]
(c) Describe the diagram below as an example of Client/Server system implementation. [Hint:
Distribution of layers; Network; Whether it is a one-, two-, or three-tier, and protocol for
connectivity between the client and the server]. [11 Marks]
QUESTION THREE – (TOTAL MARKS: 20)
a) Using a well labelled diagram, explain the Client/Server Architecture. [5 Marks]
b) Details of a business organisation are stored in two related database tables called ‘SUPPLIER’ and
‘PRODUCT’. The fields in the two tables are as shown below.
SUPPLIER: SupplierID, CompanyName, ContactPerson, Address, City (for the supplier’s unique ID,
company name, contact person, address and city respectively).
PRODUCT: ProductID, ProdName, SupplierID, UnitPrice (for the unique product ID, product name,
supplier’s id and unit price of the product respectively).
Tables Relationships
SupplierID
SUPPLIER
PRODUCT
Network
Database Server
Client Client
3
Required: Write SQL statements for doing the following:
i. To create the two related database tables. [4 Marks]
ii. To change the unit price of product ID ‘101’ to be ’75.25’ [2 Marks]
iii. To produce a listing of all products, b name, supplied by ‘Unilever (K) Ltd.’ [2 Marks]
iv. To delete a product whose ID is ‘235’ from the ‘PRODUCT’ table. [2 Marks]
c) List five (5) objectives of a communication protocol. [5 Marks]
QUESTION FOUR – (TOTAL MARKS: 20)
(a) In the context of socket programming, explain the role of the following socket primitives/APIs:
i. send() [2 Marks]
ii. recv() [2 Marks]
iii. htons() [2 Marks]
iv. socket() [2 Marks]
v. close() [2 Marks]
(b) List six (6) functions needed from a network API. [6 Marks]
(c) State two (2) drawbacks and two (2) strengths of Client/Server computing. [4 Marks]
QUESTION FIVE – (TOTAL MARKS: 20)
(a) List any five (5) commands that are used in a Telnet session between a telnet client and telnet
server. [5 Marks]
(b)(i) Describe the PL/SQL block Structure. [5 Marks]
(ii) List any five (5) differences between PL/SQL and Standard SQL. [5 Marks]
(c) What do the following Socket APIs return?
i. accept()
ii. socket()
iii. bind()
iv. connect()
v. listen()
[5 Marks]
More Question Papers
Popular Exams
Return to Question Papers