PAST PAPER PPSC LECTURER COMPUTER SCIENCE 2017

PAST PAPER PPSC LECTURER COMPUTER SCIENCE 2017

If, you are looking for PPSC Past Paper Lecturer Computer Science 2017 (BPS-17), then wait is over.

Here, PAST PAPERS PPSC will provide you All Past Paper PPSC Lecturer Computer Science 2017 (BPS-17) with fully Computer Solved Answers.

If the answer to any of the MCQs is wrong, be sure to mention it in the comments below the post. So PAST PAPERS PPSC answer to that MCQs can be corrected.

Past Paper PPSC Lecturer Computer Science 2017 (BPS-17)

31. For each attribute of a permitted values, called the ………………………….of the attribute.

Domain
Relation
Set
Schema

... Answer is A)
Domain

32. Which of the following is a tuple-generating dependency?

Functional dependency
Equality-generating dependencies
Multi-valued dependencies
Non-functional dependencies

... Answer is C)
Multi-valued dependencies

33. The main task carried out in the to remove repeating attributes to separate tables.

First Normal Form
Second Normal Form
Third Normal Form
Fourth Normal Form

... Answer is A)
First Normal Form

34. Which of the normal is based on multi-valued dependencies?

First
Second
Third
Fourth

... Answer is D)
Fourth

35. Which forms has a relation that possesses data about an individual entity?

2NF
3NF
4NF
5NF

... Answer is C)
4NF

36. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?

A many-to-many relationship set
A multi-valued attribute of an entity set
A one-to-many relationship set
Both A and B

... Answer is A)
A many-to-many relationship set

37. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set?

A many-to-many relationship set
A multi-valued attribute of an entity set
A one-to-many relationship set
Both A and B

... Answer is B)
A multi-valued attribute of an entity set

38. In 2NF:

No functional dependencies (FDs) exist
No multi-valued dependencies (MVDs)
No partial FDs exist
No partial MVDs exist

... Answer is C)
No partial FDs exist

39. ………………………… can help us detect poor E-P design.

Database Design Process
E-R Design Process
Relational Scheme
Functional Dependencies

... Answer is D)
Functional Dependencies

40. Build & Fix Model is suitable for programming exercises of ………………….LOC (Line of Code)

100-200
200-400
400-1000
Above 1000

... Answer is A)
100-200

41. What is the best way to represent the attributes in a large database?

Relational-and
Concatenation
Dot representation
All of these

... Answer is B)
Concatenation

42. Designers uses which of the following to tune performance of systems to support time critical operations?

Demoralization
Redundant optimization
Optimization
Realization

... Answer is A)
Demoralization

43. RAD stands for:

Relative Application Development
Rapid Application Development
Rapid Application Document
Rational Application Document

... Answer is B)
Rapid Application Development

44. Which one of the following models is not suitable for accommodating any change?

Build & Fix Model
Prototyping Model
RAD Model
Waterfall Model

... Answer is D)
Waterfall Model

45. Which one of the following is not a phase of Prototyping Model?

Quick
Coding
Prototype Refinement
Engineer Product

... Answer is B)
Coding

46. RAD Model has:

2 Phase
3 Phase
5 Phase
6 Phase

... Answer is C)
5 Phase

47. What is the major drawback of using RAD Model?

High Specialized & skilled developers designers are required
Increase reusability of components
Encourages customer / client feedback
Both A & C

... Answer is D)
Both A & C

48. SDLC Stands for:

Software Development Life Cycle
System Development Life Cycle
Software Design Life Cycle
System Design Life Cycle

... Answer is A)
Software Development Life Cycle

49. Which model can be selected in all the phases of SDLC?

Waterfall Model
Prototyping Model
RAD Model
Both A & C

... Answer is C)
RAD Model

50. Two devices are in network if:

A process in one device is able to exchange information with a process in another device.
A process is running on both devices
PIDs of the processes running of different devices are same.
None of these

... Answer is A)
A process in one device is able to exchange information with a process in another device.

51. In computer network nodes are:

The computer that originates the data
The computer that routes the data
The computer that terminates data
All of these

... Answer is D)
All of these

52. Communication channel is shared by all the machines on the network in:

Broadcast network
Uni-cast network
Multi-cast network
None of these

... Answer is A)
Broadcast network

53. Bluetooth is an example of:

Personal area network
Local area network
Virtual private network
None of these

... Answer is A)
Personal area network

54. A………………………..is a device that forwards packets between networks by processing the routing information included in the packet.

Bridge
Firewall
Router
All of these

... Answer is C)
Router

55. A list of protocols used by a system, one protocol per layer is called:

Protocol architecture
Protocol stack
Protocol suit
None of these

... Answer is B)
Protocol stack

56. Network congestion occurs:

In case of traffic overloading
When system terminates
When connection between two nodes terminates
None of these

... Answer is A)
In case of traffic overloading

57. Which one of the following extends a private network across public networks?

Local area network
Virtual private network
Enterprise private network
Storage area network

... Answer is B)
Virtual private network

58. The network layer concerns:

Bits
Frames
Packets
None of these

... Answer is C)
Packets

59. Which one of the following is not a function of network layer?

Routing
Inter-networking
Congestion control
None of these

... Answer is D)
None of these

60. The 4 byte IP address consists of:

Network address
Host address
Both A & B
None of these

... Answer is C)
Both A & B

Lecturer Computer Science, Lecturer Computer Science Jobs, Mcqs, IT Past Papers, Computer Mcqs, Ppsc Past Papers, Mcq Questions With Answers, , Mcq Question And Answer, Mcq Exam, PPSC Test Preparation, PPSC Exam Preparation, Computer Science Syllabus, Lecturer Jobs PPSC, Test MCQS, PPSC Test. Computer Science Test, Computer Science PPSC past papers, PPSC lecturer computer science past papers pdf.