Computer Science MCQs for Lecturer Test PPSC FPSC

Test Name:	Computer Science MCQs for lecturer test
Subject Category:	Computer Science
Test Type:	Online MCQs based Quiz
Total Score / Questions:	90 / 90
Time Allowed:	50 Min
Who Should Practice this Test:	Students, job seekers or professionals who are preparing for competitive exams, job interviews or jobs test.

Here we have solved the original PPSC past paper of computer science which will help you to prepare for the upcoming computer-based jobs. This Practice test is equally helpful for the NTS, FPSC, KPPSC, SPSC and other exams in which computer or information technology questions are asked.

Computer Science Lecturer Solved Past Paper from PPSC FPSC NTS

1. Which of the following can help us detect poor E-R design?

Database Design Process

ER Diagram

Schema

Functional dependencies (FDs)

2. Which of the following software development model is suitable if the user is involved in all the phases of SDLC??

Prototyping Model

Waterfall Model

RAD Model

All options

3. The interval from the time of submission of a process to the time of process completion is known as??

Response time

Throughput

Turnaround time

Lead time

4. The idiom “face the music” means….?

to bear the consequences

to face the happiness

to be greeted warmly

to be welcomed rudely

5. Which of the following is NOT an example of NoSQL database??

BigTable

CouchDB

MongoDB

SQL

6. Which of the following strategy is used by the designers to increase the performance of systems to support time-critical operations?

Denormalization

Redundant optimization

Normalization

Defragmentation

7. Which of the following American president was the first to live in the White House??

John Adams

George Washington

James Madison

Richard Nixon

8. A memory buffer used to accommodate a speed differential is known as….?

Cache

Stack Pointer

Accumulator

Disk Buffer

9. Choose the correct synonym of POSTHUMOUS:

Antemortem

Ahead of time

After death

Before death

10. A unique set of values permitted for each attribute of relation in a table is known as…?

Domain

Set

Schema

Relation

11. In MS Word by default header and footer are printed on……?

First three pages

Every page

Alternate pages

First page only

12. Which of the following statements is incorrect about the web-based systems?

should be scalable

should be unscalable

must be secure

must be user-friendly

13. There are how many phases of the RAD model in software development?

Three

Seven

Six

Five

14. A device that forwards data packets between computer networks by processing the routing information is known as…?

Firewall

Hub

Router

Bridge

15. Which of the following risk is associated with using external hypertext links in websites??

Hypertexts can present misleading information

It affects user engagement with the content

It diverts user attention

All options

16. Which of the following mathematician is known as the father of the computer?

Isaac Newton

Vint Cerf

John von Neumann

Charles Babbage

17. Which of the following module gives control of the Central Processing Unit to the process selected by the short term schedule??

Dispatcher

Interrupt

Interpreter

Schedule

18. An area of memory used to store information related to the pixels in the pictures in a graphic system is known as…?

Frame buffer

Frame memory

Resolution memory

Pixel buffer

19. What is the main unit of a personal computer?

CPU

Hard Disk

RAM

VGA

20. Which of the following represents a relationship among a set of values in a table?

Files

Field

Row

Column

21. The plantains are similar to which fruit??

Apples

Bananas

Grapefruit

Jackfuit

22. Which of the following analysis involved in the web engineering process framework??

All options

Interaction Analysis

Content Analysis

Functional Analysis

23. Which of the following protocol operates at the network layer protocol of the OSI model?

Ethernet

HTTP

HTML

IP (Internet Protocol)

24. Some UV radiations from the sun are essential to our body as it stimulates the production of………..??

Vitamin C

Vitamin B

Vitamin D

Vitamin K

25. Which of the following normal form is based on multivalued dependencies?

4NF

3NF

2NF

1NF

26. A compiler program written in a high-level language (like C#, Python) is known as…?

Source Program/Source Code

Machine Code

Object Program

Readable Code

27. Choose the correct full form of RAD?

Rapid Application Development

Rapid Access Development

Rational Application Development

Rapid Application Design

28. Choose the correct full form of W3C:

World Wide Web Collaboration

World Wide Web Control

Word Wide Websites Consortium

World Wide Web Consortium

29. Which of the following software development model is NOT suitable for accommodating any change?

Rapid Application Development Model

Waterfall Model

Prototyping Model

Build and fix model

30. A relational database consists of a collection of which of the following…?

Files

Records

Fields

Tables

31. Who gave the idea that a program can be stored in binary format in a memory device??

Isaac Newton

Vint Cerf

John von Neumann

Charles Babbage

32. Which of the following database normalization has a relation that possesses data about an individual entity??

4NF

3NF

2NF

1NF

33. Each packet in a virtual circuit network contains a short number known as…?

Virtual Packet Identifier (VPID)

Virtual Circuit Identifier (VCID or VCI)

Host address

MAC address

34. Which of the following addresses are generated by the CPU while execution?

Logical Address

Physical Address

Absolute Address

Data Address

35. In which of the following communication channel is shared by all the devices on the network?

Omnicast network

Unicast network

Multicast network

Broadcast network

36. A memory management scheme used by a computer to stores and retrieve data from secondary storage for use in main memory is known as…?

Fetching

Paging

Mapping

Thrashing

37. Which of the following term is used to refer to a column in a table?

Tuple

Key

Field

Attribute

38. Which of the following term is used to refer to a row in a table?

Tuple

Key

Field

Attribute

39. Which of the following is the main objective of creating page replacement algorithms?

to process pages faster

to increase the number of page faults

to reduce the number of page faults

to process multiple pages at once

40. Choose the correct full form of SDLC?

Software Development Life Cycle

Software Design Life Cycle

Software Development Line Cycle

System Development Life Cycle

41. Which statement is correct about the nodes in a computer network?

a device that can exchange data

a computer that routes the data

A device that has a unique IP address

All options

42. Choose the correct antonym of MEANDERING:

Zigzag

Straight

Winding

Curves

43. In which scheduling processes automatically get the CPU allocation first that requests the CPU first is known as?

Round Robin(RR)

Shortest-Job-Next (SJN)

Priority Scheduling

First Come First Serve (FCFS)

44. Which of the following is related to a tuple generating dependency?

Multivalued dependencies

Non-functional dependency

Equality-generating dependencies

Functional dependency

45. Which statement is correct about the Second Normal form?

No functional dependencies (FDs) exist

No multivalued dependencies (MVDs) exist

No partial MVDs exist

No partial functional dependencies (FDs) exist

46. Which of the following is an example of personal area network (PAN)?

TV network

Unicast network

Wi-Fi

Bluetooth

47. Which of the following person proposed the idea of Boao Forum for Asia in 1998??

Fidel V. Ramos, former Philippines President

Bob Hawke, former Australian Prime Minister

Morihiro Hosokawa, former Japanese Prime Minister

All options

48. Why the Optimal page replacement algorithm is difficult to implement?

it requires future knowledge of reference string

it requires past knowledge of data

it requires cache memory

it is very complex algorithm

49. Which of the following is NOT the cause of Network congestion?

Security attacks

Traffic overloading

Outdated Hardware

Use of VPNs

50. The lexical analyzer takes a source program as an input and produces what kind of output?

source program

Tokens

Source code

Keys

51. Which of the following network extends a private network across a public network and enables users to exchange data across public networks?

Personal Area Network (PAN)

Local Area Network (LAN)

Storage-Area Network (SAN)

Virtual Private Network (VPN)

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

A multivalued attribute of an entity set

A many-to-many relationship set

A one-to-many relationship set

A one-to-one relationship set

53. Which of the following focuses on the discovery of new information from the pre-existing data?

Data wrangling

Data mining

Information mining

Machine Mining

54. Which of the following queue keeps a list of all processes residing in the main memory and wanting to execute?

Execution Queue

Device Queue

Job Queue

Ready Queue

55. Time quantum is defined in which scheduling algorithm??

Round Robin(RR)

Shortest-Job-Next (SJN)

Priority Scheduling

First Come First Serve (FCFS)

56. Which of the following is NOT a responsibility of the OSI network layer??

to deliver bits from source to destination

to deliver packets from source to destination

it allows different networks to be interconnected

it provides data routing paths

57. Which statement is correct about optical page replacement?

The process will be replaced which is least used

Pages are replaced which arrives first into memory

Pages are modified which are not used for a long time

Pages are replaced which are not used for a long time

58. After the partition of Bengal in 1905 the capital city of East Bengal was??

Dhaka

Kolkata

New Delhi

Karachi

59. In priority scheduling when a process reaches the ready queue, its priority is compared with the priority of……?

Parent Process

All processes

Currently running process

Waiting process

60. The IPv4 a 32-bit address consists of…??

network address and host address

only network address

host address only

internet address and MAC address

61. The current capital of Kazakhstan is Nur-Sultan; do you know the old capital city name?

Almaty

Astana

Taraz

Shymkent

62. Which of the following American president was the first to resign from office on August 9, 1974?

John Adams

George Washington

James Madison

Richard Nixon

63. A group of protocols used by a system that are running concurrently to allow software or hardware to perform a function is known as…?

Protocol Stack/network stack

Protocol Suit

Network Suit

System Stack

64. Which of the following is NOT a type of prototype of the Prototyping Model?

Horizontal Prototype

Diagonal Prototype

Domain Prototype

Vertical Prototype

65. What does the term Pangaea mean in geography??

Hypothetical Hills

Hypothetical supercontinent

Supernova

Big continent

66. Which of the following is the best way to represent the attributes in a huge database??

Relational-and

Dot representation

Concatenation

All options

67. Which of the following is NOT an example of OS(operating system)?

iOS

MS Access

Linux

MS Windows

68. Which of the following was the official language before British rule in India??

Urdu

Hindi

Persian

Arabic

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

A multivalued attribute of an entity set

A many-to-many relationship set

A one-to-many relationship set

A one-to-one relationship set

70. What is the last missing number in the given series: 15, 31, 63, 127, 255……?

511

510

517

520

71. Central Processing Unit fetches the instruction from memory according to the value of….?

Program counter

Memory Buffer Register

Status register

72. Choose the correctly spelled word from the following:

Dicotomy

Dichotomy

Dicotamy

Dechotomy

73. In which of the following normal form unnecessary repeating attributes are removed by creating a separate table?

Fourth Normal Form

Second Normal Form

Third Normal Form

First Normal Form

74. Build and fix model (ad hoc model) is suitable for programming exercises of…………….Line of Code?

Above 1k

500-1000

400

100-200

75. Choose the correct alternative name of Parsing?

Syntax Analysis

Lexical Analysis

Semantic Analysis

Code Analysis

76. The signal sent to the device from the processor to the device after receiving an interrupt is known as…?

Return signal

Permission signal

Interrupt-acknowledge

Service signal

77. Which of the following software process model is best in all situations of Web application development??

Incremental Model

Spiral Model

Waterfall Model

V model

78. Which of the following type of web-based systems would you assign to discussion groups??

Online community/Web community

Workflow-oriented

Online portals

Web portals

79. The interrupt request line or IRQ is a part of…?

Address Line

Control Line

Data Line

Bus Line

80. A memory page containing an excessively used variable that was initialized very early and is in constant use is removed, which page replacement algorithm is used?

LRU

LFU

LIFO

FIFO

81. Which of the following sport is NOT a part of the modern Olympic Games??

Football

Badminton

Cricket

Swimming

82. The return address from the interrupt-service routine is stored on which of the following…?

System Heap

Processor stack

Memory stack

Processor register

83. Which of the following type of web-based systems would you assign to the E-commerce website??

Transaction-oriented

Workflow-oriented

Question oriented

Information-oriented

84. Which of the following routing algorithms can be used to transmit an incoming data packet to reach the destination efficiently in network layer design?

Dijkstra's algorithm (Shortest Path algorithm)

Distance-vector routing

Link-state routing

All options

85. Which of the following cannot be scheduled by the Kernel??

Process

All Incorrect

Kernel level threads

User-level threads

86. The main purpose of ICMP (Internet Control Message Protocol) is…?

to diagnose network communication issues

it provides data routing paths

to deliver packets from source to destination

to deliver bits from source to destination

87. In a computer network two devices are connected if…..?

software is active in both devices

the process is running on both devices

a process can exchange data with other processes

All options

88. Which of the following country flag is also known as Union Jack??

New Zealand

France

USA

89. Which of the following is the major drawback of using RAD model in software development?

High amounts of risk and uncertainty

Encourages client feedback

Not Flexible and adaptable to changes

Requires highly skilled developers/designers

90. The network layer is concerned with what type of data??

Packets

Bits

Waves

Frames

Computer Science Lecturer Solved Past Paper from PPSC FPSC NTS

Related Quizzes: