DSSSB TGT / PGT · Topic-wise previous year questions
Computer Science Previous Year Questions (page 13)
1995 Computer Science questions asked in DSSSB TGT / PGT previous year papers, each with the correct answer and explanation. Read them free on UTpaper, or attempt the full papers as timed online tests.
Which of the following statement(s) is/are correct regarding single row functions in structured query language?
I. INSERT() is a numeric function.
II. ROUND() is a numeric function.
III. LENGTH() is a character function.
ABoth I and II
BBoth II and III
COnly III
DBoth I and III
Show answerHide answer
Correct answer: (B) Both II and III
Explanation
ROUND() is a numeric function and LENGTH() is a character function. INSERT() (e.g., in MySQL) is a string function, not a numeric one.
Which of the following statement(s) is/are correct regarding Data Dictionary in Database Management System?
I. Data Dictionary is a collection of definitions, rules and advisories of data designed to be used as a reference with the data warehouse.
II. Data Dictionary is the area of memory allocated for data storage.
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (A) Only I
Explanation
A data dictionary is a metadata repository that holds definitions, rules and descriptions of the data. It is not a memory area for storing data.
ACustomer relationship management includes the methodologies, technology and capabilities that help an enterprise to manage customer relationships
BCustomer relationship management is a corporate level strategy which focuses on creating new customers
CCustomer relationship management is the process of planning, implementation and controlling the operations of the supply chain
DCustomer relationship management is the process of daily production and distribution
Show answerHide answer
Correct answer: (A) Customer relationship management includes the methodologies, technology and capabilities that help an enterprise to manage customer relationships
Explanation
CRM covers the methods, technology and capabilities a business uses to manage and analyse its interactions with customers.
Which of the following statement(s) is/are true regarding cryptography?
I. Cipher text is encrypted text transformed from plain text using an encryption algorithm.
II. According to Kerchoff's principle, all algorithms must be private and only the keys are secret.
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (A) Only I
Explanation
Ciphertext is plaintext transformed by an encryption algorithm. Kerckhoffs's principle says the algorithm should be public and only the key secret, so II is false.
Which of the following is not a example of Distributive computing?
ALAN network
BMobile network
CParallel computing
DInternet
Show answerHide answer
Correct answer: (C) Parallel computing
Explanation
LANs, mobile networks and the Internet are distributed systems of separate networked computers. Parallel computing usually uses processors sharing memory in one machine, so it is counted as different.
AA neuron is a small cell that receives electrochemical signals from various sources and transmit electrical impulses to other neurons
BA neuron is a cell that send electromagnetic signals to axons
CA neuron is a small cell that sends electric impulses to ions
DA neuron is a cell which has the capability to predict the situation from past trends
Show answerHide answer
Correct answer: (A) A neuron is a small cell that receives electrochemical signals from various sources and transmit electrical impulses to other neurons
Explanation
In neural network theory a biological neuron is a cell that receives electrochemical signals from many sources (through dendrites) and transmits electrical impulses to other neurons.
Distributed systems are loosely coupled because each node has its own memory and they communicate over a network. Parallel (multiprocessor) systems are tightly coupled because they share memory and a clock.
Which of the following is NOT a Data MINING technique?
ALink Analysis
BDatabase Segmentation
CPredictive Modeling
DEvaluation
Show answerHide answer
Correct answer: (D) Evaluation
Explanation
Link analysis, database segmentation (clustering) and predictive modelling are data mining techniques. Evaluation is a general step, not a mining technique.
Routing algorithm which do not base their routing decisions on measurements or estimates of the current traffic and topology belongs to which category?
AAdaptive algorithm
BGreedy algorithm
CBack propagation algorithm
DNon-adaptive algorithm
Show answerHide answer
Correct answer: (D) Non-adaptive algorithm
Explanation
Non-adaptive (static) routing algorithms decide routes in advance and ignore current traffic and topology. Adaptive algorithms react to them.
Newton – Raphson method is used to compute a root of the equation x² + 4x − 9 = 0 with 1 as the initial value. The approximate value after one iteration is ________.
A1.571
B0.429
C1.528
D1.429
Show answerHide answer
Correct answer: (A) 1.571
Explanation
The keyed 1.571 comes from x³ + 4x − 9 = 0 (the cube seems lost in the source): f(1) = −4, f'(1) = 3 + 4 = 7, so x₁ = 1 + 4/7 ≈ 1.571. With x² instead, x₁ would be 1.667.
An image may be defined as a 2-dimensional function f(x, y) where x and y are ________ and the amplitude of the function is called ________ of the image at the point (x, y)
AIntensity; coordinates
BIntensity; brightness
CCoordinates; intensity
DBrightness; coordinates
Show answerHide answer
Correct answer: (C) Coordinates; intensity
Explanation
In f(x, y), x and y are spatial coordinates, and the amplitude of f at any point is the intensity (grey level) of the image there.
'Preparing any project in science/mathematics may give pleasure to the pupil as result of which he/she is motivated to undertake similar activities on his/her own.' This given statement describes which of the following type(s) of motivation?
I. Intrinsic Motivation
II. Extrinsic Motivation
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (A) Only I
Explanation
The motivation comes from the pleasure of doing the activity itself, not from an outside reward, so it is intrinsic motivation.
Which of the following statement(s) is/are not correct?
I. Conditioning of elicited behaviours defines classical conditioning.
II. Conditioning of emitted behaviours defines operant conditioning.
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (D) Neither I nor II
Explanation
Both statements are correct: classical conditioning conditions elicited (respondent) behaviour, and operant conditioning conditions emitted behaviour. So neither is incorrect.
Which of the following is/are those medium(s) by which value education can be provided to the students?
I. Skits and Dramas
II. Morning Assembly
III. Compulsory Subject
AII and III
BOnly III
CI and II
DI, II and III
Show answerHide answer
Correct answer: (D) I, II and III
Explanation
Value education can be given through skits and dramas, morning assemblies, and as a compulsory subject, so all three are correct.
If a teacher is teaching topic 'Forts' to the students, then a teacher can perform introductory activities by making documentation cards indicating which of the following?
I. Name of Historical buildings.
II. Drawing of unique architectural features of the building such as pillars/domes etc
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (D) Neither I nor II
Explanation
Note: the answer key gives (D), but as written both items (names of historical buildings and drawings of features such as pillars and domes) are suitable for introductory documentation cards on forts, so (C) would be expected.
Which of the following statement(s) is/are not correct about 'Facilitation' in art education?
I. Helping the child by giving free access to handling musical instruments with a caution for care.
II. Providing lot of art material for helping the child to choose and pick and innovate.
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (A) Only I
Explanation
Following the key, statement II (providing plenty of art material so the child can choose, pick and innovate) describes facilitation, and statement I is treated as not correct.
While teaching a children how to read, which of the following things need to be kept in mind?
I. The material used must be meaningful and of the level of the child.
II. The material should be in a language that the child is familiar with.
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (C) Both I and II
Explanation
Reading material should be meaningful and suited to the child's level, and in a language the child is familiar with. Both points are needed.
Which of the following is/are the role(s) of teachers in the Theme Based Integrated Early Childhood and Care Education Programme?
I. Observe children to identify their interests, needs and capabilities and the pace of their development.
II. Create nurturing and positive relationships in the classroom.
AOnly I
BOnly II
CBoth I and II
DNeither I nor II
Show answerHide answer
Correct answer: (C) Both I and II
Explanation
In a theme-based ECCE programme, teachers observe children's interests, needs and pace of development, and build nurturing, positive relationships. Both are teacher roles.
In which stage of cognitive development of Piaget's theory, a child understands and carry out calculations involving proportions?
APre-operation Period
BConcrete Operation Period
CFormal Operation Period
DSensory Motor Period
Show answerHide answer
Correct answer: (C) Formal Operation Period
Explanation
Proportional reasoning needs abstract thought, which develops in Piaget's formal operational stage (11+ years).
How to use these DSSSB TGT / PGT Computer Science questions
Every question here was asked in a real DSSSB TGT / PGT paper; the paper and shift are shown on the card, and the number opens the question on its own page. Try each one before tapping Show answer, then attempt the full DSSSB TGT / PGT papers as timed tests to check your speed under exam conditions.