Past Paper Punjab University 2016 BSC Computer Studies Paper B

Past Paper Punjab University 2016 BSC Computer Studies Paper B

Welcome to Taleem E Pakistan BSC Computer Studies Paper B 2016 Computer Studies Punjab University Section, the largest collection of PU Computer Studies Past Papers, that provides to the educational needs of all students to enable them to study at their own way. Scroll down to watch Punjab University BSC Computer Studies Paper B 2016 Past Paper.

Punjab University B.Sc-2016 Time Allowed: 3Hrs.
Computer Studies PAPER: B Max.Marks:70

NOTE: Attempt THREE questions from Part-1 and THREE questions from Part-11.

Part-I (Database Management Systems) Max Marks: 35

Note:
1. Question 1 in part-I is compulsory.
2. Attempt any TWO questions from the remaining questions in part-I

Question # 1

Choose the most appropriate option for the following statements and write on the provided answer sheet. (Please write only correct options, no need to write whole Answer). (Marks: 10)

1. In SQL, which of the following is not a data Manipulation Language Commands?
A) DELETE
B) SELECT
C) UPDATE
D) CREATE

2. Which of the following is not an advantage of the database approach?
A) Elimination of data redundancy
B) Ability of associate deleted data
C) Increased security
D) Program/data independence

3. More than one PRIMARY Key can be created for each table in a relational database.
A) True
B) False
C) Statement is not clear

4. With SQL statement, how can. you delete all the records in the EMPLOYEES Table?
A) DELETE FROM EMPLOYEES WHERE FirstName = ‘*’
B) DELETE ALL ROW FROM EMPLOYEES
C) DELETE FROM EMPLOYEES
D) None of them

5.PRIMARY KEY may not comprise more than one column
A) True
B) False
C) Statement is not clear

6. Metadata is ………
A) Material Data
B) Manipulated Data
C) Data about Data
D) None of them

7. A ……… entity is one whose existence depends on another entity.
A) Weak
B) Strong
C) Structured
D) Independent

8. More than one Foreign Keys can be created for each table in a relational database.
A) True
B) False
C) Statement is not clear

9. The following SQL is which type of join:
SELECT, e.ename, e.sal, s.grade
FROM emp e, salgrade s
WHERE e.sal BETWEEN s.losal AND s.hisal
A) Equi Join
B) Non-Equi Join
C) Outer Join
D) None of them

10. When mapping a supertype/subtype relationship which of the following is true?
A) The supertype primary key is assigned to each subtype
B) The subtype primary key is assigned to each supertype.
C) There is no link between the supertype/subtype entities.
D) There is no primary key/foreign key relationship between a supertype/subtype.

Question # 2

Differentiate File Processing systems and Database Procesing systems. And also discuss disadvantages of file procesing systems over database processing systems. 12.5

Question # 3

Define briefly Relationship, Degree of Relationship, Cardinality of Relationship, Database Schema and Attribute Domain 5*2.5=12.5

Question # 4

Identify Entities with attributes, Relationships and Draw an Entity Relationship Diagram (ERD) for the following SSQ University. Use the following requirements and take your own assumptions (if needed) A SSQ university consists of a number of departments. Each department offers several courses. A number of modules make up each
course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students.

Part-II (Operating Systems and Networks) Max. Marks: 35

Note:
1. Question 5 in part — II is compulsory.
2. Attempt any TWO questions from the remaining questions in part – II

Question # 5

Choose the most appropriate option for the following statements and write on the provided answer sheet. (Please write only correct options, no need to write whole Answer). (Marks : 10)

1. Which of the following scheduler is invoked most frequently?
A) Long term scheduler
B) Medium term scheduler
C) Short term scheduler
D) None of the above

2. The ……… replacement algorithm is a combination of the FIFO and NRU algorithms.
A) Second Chance
B) N-FIFO
C) FIFO-RU
D) First Chance

3. In a batch environment a new process is created in response to the submission of a job
A) True
B) False
C) Statement is not clear

4. A process is in a Running state, if it is not allocated to a CPU but is ready to run.
A) True
B) False
C) Statement is not clear

5. Which of the following scheduler controls the degree of multiprogramming?
A) Long term scheduler
B) Medium term scheduler
C) Short term scheduler
D) None of the above

6. On a system that uses simple paging, memory is divided into fixed-size blocks called page frames.
A) True
B) False
C) Statement is not clear

7. The number of processes the system can execute in a period of time is called: throughput of a system.
A) True
B) False
C) Statement is not clear

8. The ….. layer is the layer closest to the transmission medium.
A) Physical
B) Data link
C) Network
D) Transport

9. Coaxial cable carries signals of higher frequency ranges than …….. cable
A) Twisted-pair
B) Optical Fiber
C) Twisted Fiber
D) Fiber Pair

10. Which of the following is not a transmission mode?
A) Simplex
B) Half Duplex.
C) Semi Duplex
D) Full Duplex

Question # 6

Discuss Briefly Different Process Scheduling Algorithms (Marks: 12.5)

Question # 7

a) Discuss briefly Critical Section 6.5
b) Discuss Three Different Phases of Process Scheduling. 6

Question # 8

a) Define Line Configuration and also Differentiate Point to Point Line Configuration and Multipoint Line Configuration with Figures. 6.5
b) Discuss briefly functions of Application Layer of OSI Model. 6

Print Friendly, PDF & Email






Leave a Reply

Your email address will not be published. Required fields are marked *

Copy Protected by Chetan's WP-Copyprotect.