PPSC Lecturer of Computer Science New Pattern 2020
MCQs Solved
PPSC Lecturer of Computer Science
New Pattern Paper Questions 2020
PPSC Lecturer of Computer Science New Pattern Paper:
1. The network layer concerns with
a) bits
b) frames
c) packets
d) none of the mentioned
Answer: C
2.The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
Answer: B
3. Which forms are based on the concept of functional
dependency:
a) 1NF
b) 2NF
c) 3NF
d) 4NF
Answer: C
4. _____________ can help us detect poor E-R design.
a) Database Design Process
b) E-R Design Process
c) Relational scheme
d) Functional dependencies
Answer: D
5. For each attribute of a relation, there is a set of permitted
values, called the ________ of that attribute.
a) Domain
b) Relation
c) Set
d) Schema
Answer: A
6. A ________ in a table represents a relationship among a set
of values.
a) Column
b) Key
c) Row
d) Entry
Answer: C
7. A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
Answer: a
Explanation: Fields are the column of the relation or tables. Records are each row in relation. Keys are the constraints in a relation.
8. Users _______ that their processes are running on a paged
system.
a) are aware
b) are unaware
c) None of these
Answer: B
9. Optimal page – replacement algorithm is :
a) Replace the page that has not been used for a long time
b) Replace the page that has been used for a long time
c) Replace the page that will not be used for a long time
d) None of these
Answer: C
10. LRU page – replacement algorithm associates with each page
the ______
a) time it was brought into memory
b) the time of that page’s last use
c) page after and before it
d) All of these
Answer: b
11. How many page faults does the LRU page replacement
algorithm produce ?
a) 10
b) 15
c) 11
d) 12
Answer: D
12. Parsing is also known as
a) Lexical Analysis
b) Syntax Analysis
c) Semantic Analysis
d) Code Generation
Answer: B
13. Designers use which of the following to tune performance of
systems to support time-critical operations?
a) Denormalization
b) Redundant optimization
c) Optimization
d) Realization
Answer: A
14.The lexical analyzer takes _________as input and produces a
stream of _______as output.
a) Source program, tokens
b) Token, source program
c) Either of the two
d) None of the mentioned
Answer: A
15. In which of the following , a separate schema is created
consisting of that attribute and the primary key of the entity set.
a) A many-to-many relationship set
b) A multivalued attribute of an entity set
c) A one-to-many relationship set
d) Both a and b
Answer: B
16. Which forms has a relation that possesses data about an
individual entity:
a) 2NF
b) 3NF
c) 4NF
d) 5NF
Answer: C
17. The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
Answer: B
18. Which model can be selected if user is involved in all the
phases of SDLC?
a) Waterfall Model
b) Prototyping Model
c) RAD Model
d) both b & c
Answer: C
19. SDLC stands for
a) Software Development Life Cycle
b) System Development Life cycle
c) Software Design Life Cycle
d) System Design Life Cycle
Answer: A
20. RAD Model has
a) 2 phases
b) 3 phase
c) 5 phases
d) 6 phases
Answer: C
21. What is the major drawback of using RAD Model?
a) Highly specialized & skilled developers/designers are required.
b) Increases re-usability of components.
c) Encourages customer/client feedback.
d) Both a & c.
Answer: D
22. Which one of the following models is not suitable for
accommodating any change?
a) Build & Fix Model
b) Prototyping Model
c) RAD Model
d) Waterfall Model
Answer: D
23. RAD stands for
a) Relative Application Development
b) Rapid Application Development
c) Rapid Application Document
Answer: B
24. Build & Fix Model is suitable for programming exercises of
___________ LOC (Line of Code).
a) 100-200
b) 200-400
c) 400-1000
d) above 1000
Answer: A
25. A memory page containing a heavily used variable that was
initialized very early and is in constant use is removed, then the
page replacement algorithm used is :
a) LRU
b) LFU
c) FIFO
d) None of these
Answer: C
"Best of Luck"
More Information " Click here "
1 comment:
What is a telegram channel?
In its scientific sense, the channel means a medium and a web platform that has been created
on the telegram and using it.buy telegram members
Anyone with the least information from this social network can create a channel for himself,
and then post any content and content he wishes to publish inside it.
Buy Telegram Channel Members The attractiveness of this web site grows when
a person can create his message in the form of a photo, text, video or audio and listen to his audience.
Post a Comment