DSSSB TGT / PGT · Topic-wise previous year questions

Computer Science Previous Year Questions (page 32)

2444 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.

  • 2444 questions
  • 20 topics
  • Official answer key
  • Free

Practise by topic

Q1551DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Move the Read/Write head of disk in or out to position on a correct track is known as ________.
  1. AWaiting time
  2. BAccess time
  3. CSeek time
  4. DLatency time
Show answerHide answer

Correct answer: (C) Seek time

Explanation

Seek time is the time to move the read/write head to the required track. Latency (rotational delay) is the wait for the sector to rotate under the head.

Q1552DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Data structure maintained by the operating system to maintain information for each thread within a process is known as ________.
  1. AProcess control block
  2. BThread control block
  3. CSymbol table
  4. DScheduling queue
Show answerHide answer

Correct answer: (B) Thread control block

Explanation

The OS keeps a Thread Control Block (TCB) per thread, storing its thread ID, register set, stack pointer, state and priority. A PCB stores information for a whole process.

Q1553DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Monotonicity of preferences implies that the indifference curves are ________. I. Downward sloping II. Positively sloping
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (A) Only I

Explanation

Monotonic preferences mean more of a good is better, so to keep utility constant a consumer must give up some of one good to get more of the other, which makes indifference curves slope downward.

Q1554DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following is a qualitative tool used by RBI to control money supply?
  1. AMoral suasion
  2. BCash Reserve Ratio
  3. CBank Rate
  4. DOpen Market Operations
Show answerHide answer

Correct answer: (A) Moral suasion

Explanation

Moral suasion (persuasion and advice to banks) is a qualitative or selective tool. CRR, bank rate and open market operations are quantitative tools that act on the total money supply.

Q1555DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
A connection that allows traffic either way, but only one way at a time is known as ________.
  1. AFull duplex
  2. BHalf duplex
  3. CDuplex
  4. DSimplex
Show answerHide answer

Correct answer: (B) Half duplex

Explanation

Half duplex allows communication in both directions but only one direction at a time (e.g. walkie-talkie). Full duplex allows both at once; simplex is one-way only.

Q1556DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
What is the full form of DVMRP Protocol?
  1. ADistance Vector Multiple Routing Protocol
  2. BDistance Vector Multicast Routing Protocol
  3. CDistance Vector Multitask routing Protocol
  4. DDistance Vector Message Routing Protocol
Show answerHide answer

Correct answer: (B) Distance Vector Multicast Routing Protocol

Explanation

DVMRP is the Distance Vector Multicast Routing Protocol, used for routing multicast traffic.

Q1557DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which modulation technique is applied to a binary signal in figure (A) to achieve figure (B)? Figure (A): a binary digital signal (bits 0 1 0 1 1 0 0 1 0 0 1 0 0). Figure (B): a sinusoidal carrier that is present only during the intervals where the bit is 1 and absent where the bit is 0.
  1. AAmplitude modulation
  2. BFrequency modulation
  3. CPhase modulation
  4. DQuadrature phase shift keying
Show answerHide answer

Correct answer: (A) Amplitude modulation

Explanation

The carrier is sent for bit 1 and switched off for bit 0. This is on-off keying, a form of amplitude shift keying, i.e. amplitude modulation of the binary signal.

Q1558DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
The loss of energy as signal propagates outward is known as ________.
  1. ANoise
  2. BDistortion
  3. CAttenuation
  4. DScattering
Show answerHide answer

Correct answer: (C) Attenuation

Explanation

Attenuation is the loss of signal energy (strength) as the signal travels through the medium, which is why repeaters or amplifiers are needed.

Q1559DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Systems in which multiple users share a common channel in a way that can lead to conflicts are widely known as ________.
  1. ACarrier
  2. BCommunication network
  3. CContention
  4. DBus
Show answerHide answer

Correct answer: (C) Contention

Explanation

Systems where many users share one channel and their transmissions can collide are called contention systems (e.g. ALOHA, CSMA).

Q1560DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Match the following. A. Repeater — I. Network layer B. Bridge — II. Transport layer C. Routers — III. Data link layer D. Gateway — IV. Physical layer
  1. AA-II, B-I, C-III, D-IV
  2. BA-III, B-II, C-I, D-IV
  3. CA-IV, B-III, C-I, D-II
  4. DA-I, B-III, C-IV, D-II
Show answerHide answer

Correct answer: (C) A-IV, B-III, C-I, D-II

Explanation

Repeater works at the physical layer (IV), bridge at the data link layer (III), router at the network layer (I) and gateway at the transport layer or above (II).

Q1561DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
What is the name of the virtual machine component of microsoft .NET Framework which manages the execution of .NET program?
  1. ACode level security
  2. BCross language class inheritance
  3. CCommon language runtime
  4. DCommon type system
Show answerHide answer

Correct answer: (C) Common language runtime

Explanation

The Common Language Runtime (CLR) is the .NET virtual machine: it loads and runs code, and handles JIT compilation, memory management and security.

Q1562DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
________ is a system to make a file or directory visible in multiple parts of the system's file tree in Linux operator system.
  1. ADirectories
  2. BSpecial files
  3. CLinks
  4. DSockets
Show answerHide answer

Correct answer: (C) Links

Explanation

Links (hard links and symbolic links) let the same file or directory appear at multiple places in the Linux directory tree.

Q1563DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
The deliveries of goods or services ordered on an e-shop do NOT depend upon which of the following?
  1. ASize of products
  2. BCost of products
  3. CUrgency
  4. DNature of products
Show answerHide answer

Correct answer: (B) Cost of products

Explanation

Delivery arrangements depend on the size, nature and urgency of the goods, but not on their cost, so cost of products is the answer.

Q1564DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following statement(s) is/are correct regarding digital certificates? I. A digital certificate does not include the name of the CA who issues it. II. Digital certificates are based on public key cryptography. III. These certificates are available only in one strength i.e. 128-bit encryption.
  1. AI and II
  2. BOnly III
  3. COnly II
  4. DI and III
Show answerHide answer

Correct answer: (C) Only II

Explanation

Only II is correct: certificates rely on public key cryptography. A certificate does include the issuing CA's name (I false), and certificates come in various key strengths, not only 128-bit (III false).

Q1565DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following is a max-heap?
  1. ARoot 100; children 80 and 60; 80 has child 40; 60 has children 50 and 30; 50 has child 20.
  2. BRoot 100; children 80 and 60; 80 has children 40 and 50; 60 has children 20 and 30.
  3. CRoot 100; children 80 and 60; 80 has children 40 and 50; 60 has right child 30; 30 has child 20.
  4. DRoot 100; children 50 and 60; 50 has children 40 and 80; 60 has children 20 and 30.
Show answerHide answer

Correct answer: (B) Root 100; children 80 and 60; 80 has children 40 and 50; 60 has children 20 and 30.

Explanation

A max-heap must be a complete binary tree with every parent ≥ its children. Option B satisfies both. A and C are not complete trees, and in D the node 50 has a larger child 80.

Q1566DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which rotations in AVL trees are known as single rotations?
  1. ALL and RR
  2. BLL and LR
  3. CRR and RL
  4. DLR and RL
Show answerHide answer

Correct answer: (A) LL and RR

Explanation

LL and RR imbalances are fixed by one rotation (single rotations). LR and RL need two rotations, so they are double rotations.

Q1567DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
What is the at most height of red-black tree with n internal node?
  1. An
  2. Blog₂n
  3. C2log₂(n + 1)
  4. Dlog₂(2n + 1)
Show answerHide answer

Correct answer: (C) 2log₂(n + 1)

Explanation

A red-black tree with n internal nodes has height at most 2log₂(n + 1), since the black height is at least half the height.

Q1568DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Consider the following AVL tree. Root 38; left child 14, right child 56. 14 has children 8 and 23; 23 has left child 18. 56 has children 45 and 82; 82 has left child 70. What will be the resultant AVL tree after insertion of node with value 20?
  1. ARoot 38; 14 (children 8, 23); 23 has left child 18; 18 has right child 20; 56 (children 45, 82); 82 has left child 70.
  2. BRoot 38; 14 (children 8, 20); 20 has children 18 and 23; 56 (children 45, 82); 82 has left child 70.
  3. CRoot 38; 14 (children 8, 23); 23 has left child 20; 20 has left child 18; 56 (children 45, 82); 82 has left child 70.
  4. DRoot 38; 14 (children 8, 18); 18 has right child 20; 20 has right child 23; 56 (children 45, 82); 82 has left child 70.
Show answerHide answer

Correct answer: (B) Root 38; 14 (children 8, 20); 20 has children 18 and 23; 56 (children 45, 82); 82 has left child 70.

Explanation

20 goes to the right of 18, making 23 unbalanced (left height 2, right 0) with a left-right pattern. An LR double rotation makes 20 the subtree root with 18 and 23 as children, as in option B.

Q1569DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Preorder traversal of binary search tree is 38, 14, 8, 23, 18, 20, 56, 45, 82, 70. What is the postorder traversal of binary search tree?
  1. A23, 20, 18, 14, 8, 38, 45, 56, 70, 82
  2. B8, 18, 20, 23, 14, 45, 70, 82, 56, 38
  3. C8, 20, 18, 23, 14, 45, 70, 82, 56, 38
  4. D82, 70, 56, 45, 38, 23, 20, 18, 14, 8
Show answerHide answer

Correct answer: (C) 8, 20, 18, 23, 14, 45, 70, 82, 56, 38

Explanation

The BST is 38 with left subtree 14 (8, and 23 with left child 18 whose right child is 20) and right subtree 56 (45, and 82 with left child 70). Postorder: 8, 20, 18, 23, 14, 45, 70, 82, 56, 38.

Q1570DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following acts as an intermediary between the specialist and the expert system?
  1. AKnowledge base
  2. BInference engine
  3. CData dictionary
  4. DKnowledge engineer
Show answerHide answer

Correct answer: (D) Knowledge engineer

Explanation

A knowledge engineer extracts knowledge from the human expert (specialist) and encodes it into the expert system's knowledge base, acting as the intermediary between them.

Q1571DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following statement(s) is/are correct regarding batch transaction processing? I. The database is updated when the transaction is processed. II. The associated cost is very high. III. Reports generated are required only at a scheduled interval.
  1. AOnly II
  2. BOnly III
  3. CI and II
  4. DI and III
Show answerHide answer

Correct answer: (B) Only III

Explanation

In batch processing, transactions are collected and the database is updated later (I false), it is relatively cheap (II false), and reports are produced at scheduled intervals (III true).

Q1572DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
What is the full form of GPRS in mobile computing?
  1. AGeneral Packet Radio Service
  2. BGeneral Packet Radiation Service
  3. CGeneral Package Radio Service
  4. DGeneral Packet Route Service
Show answerHide answer

Correct answer: (A) General Packet Radio Service

Explanation

GPRS is General Packet Radio Service, a packet-switched data service on 2G/GSM networks.

Q1573DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following is a part of the system architecture of GSM in mobile computing? I. Radio Subsystem II. Networking and Switching Subsystem III. Operation Support Subsystem
  1. AI and II
  2. BII and III
  3. CI and III
  4. DI, II and III
Show answerHide answer

Correct answer: (D) I, II and III

Explanation

GSM architecture has three subsystems: Radio Subsystem (RSS), Network and Switching Subsystem (NSS) and Operation Subsystem (OSS). All three are parts of it.

Q1574DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
The duration of phosphorescence exhibited by a phosphor is known as ________.
  1. APhosphorescence
  2. BFluorescence
  3. CPersistence
  4. DDeflection
Show answerHide answer

Correct answer: (C) Persistence

Explanation

Persistence is how long a phosphor continues to emit light after the electron beam is removed (time for light to decay to one-tenth of its original intensity).

Q1575DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
What is the CMY co-ordinates of a colour at (0.2, 1, 0.5) in the RGB space?
  1. A(0.8, 1, 0.5)
  2. B(0.8, 0, 0.5)
  3. C(1.2, 0, 1.5)
  4. D(0.2, 0.8, 0.3)
Show answerHide answer

Correct answer: (B) (0.8, 0, 0.5)

Explanation

CMY = (1, 1, 1) − RGB, so (1 − 0.2, 1 − 1, 1 − 0.5) = (0.8, 0, 0.5).

Q1576DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Consider a triangle with co-ordinates points: A(0, 0), B(3, 3) and C(2, 5). When scaling parameter is 2 towards X-axis and 4 towards y- axis, then what are the new co-ordinates of triangle?
  1. AA(0, 0), B(6, 12), C(4, 20)
  2. BA(0, 0), B(5, 7), C(4, 9)
  3. CA(2, 4), B(5, 7), C(4, 9)
  4. DA(0, 0), B(3/2, 3/4), C(1, 5/4)
Show answerHide answer

Correct answer: (A) A(0, 0), B(6, 12), C(4, 20)

Explanation

Scaling multiplies coordinates: x' = 2x, y' = 4y. A(0, 0) stays (0, 0), B(3, 3) becomes (6, 12), C(2, 5) becomes (4, 20).

Q1577DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
________ is the person who runs our web servers.
  1. AData analyst
  2. BWeb master
  3. CDatabase designer
  4. DWeb Designer
Show answerHide answer

Correct answer: (B) Web master

Explanation

A webmaster manages and maintains web servers and websites. A web designer creates layout and look, not the server.

Q1578DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
What is the extension of MPEG Audio file?
  1. A.mpeg
  2. B.mp3
  3. C.mp4
  4. D.mov
Show answerHide answer

Correct answer: (B) .mp3

Explanation

MPEG-1/2 Audio Layer III files use the .mp3 extension. .mp4 is an MPEG-4 container, mainly for video.

Q1579DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following factors is taken into account when we develop a knowledge management system (KMS)?
  1. AIt requires a knowledge contract
  2. BIt is a cheap management system
  3. CIt is a definite process
  4. DIt has no human implications
Show answerHide answer

Correct answer: (A) It requires a knowledge contract

Explanation

The key treats a knowledge contract (agreement on who contributes, owns and shares knowledge) as a factor in building a KMS. The other options are false: a KMS is costly, evolving, and has strong human implications.

Q1580DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
In the beginning, when reporting a meeting one should give precise information about the ________.
  1. AHistory of the organization
  2. BTitle of the speech
  3. CFuture prospects
  4. DParticipants
Show answerHide answer

Correct answer: (A) History of the organization

Explanation

The keyed answer says a meeting report should begin with precise background information about the organisation holding the meeting, before details of the speeches and participants.

Q1581DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which symbol in flowchart is used for processing?
  1. ADiamond
  2. BRectangle
  3. CParallelogram
  4. DRounded rectangle (oval)
Show answerHide answer

Correct answer: (B) Rectangle

Explanation

In a flowchart, a rectangle stands for a processing step. A diamond is a decision, a parallelogram is input/output and an oval is start/end.

Q1582DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following are included in the user documentation of program? I. Program formatting II. Description of program and its purpose III. Description of program output
  1. AII and III
  2. BI and II
  3. CI and III
  4. DI, II and III
Show answerHide answer

Correct answer: (A) II and III

Explanation

User documentation explains what the program does, its purpose, how to use it and what output to expect (II and III). Program formatting belongs to technical (programmer) documentation.

Q1583DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
The median of 7, 5, 8, x, 12, 17 is 10, then what is the value of x?
  1. A13
  2. B11
  3. C9
  4. D12
Show answerHide answer

Correct answer: (D) 12

Explanation

With six values, median = mean of 3rd and 4th values. Taking x between 8 and 12, the ordered list is 5, 7, 8, x, 12, 17, so (8 + x)/2 = 10, giving x = 12.

Q1584DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
In a bulb factory, machines P, Q and R manufacture respectively 25%, 35% and 40% of the total. Of their output 5, 4 and 2 percent respectively are defective bulbs. A bulb is drawn at random and it is found to be defective. What is the probability that it was manufactured by machine Q?
  1. A0.55
  2. B0.45
  3. C0.31
  4. D0.41
Show answerHide answer

Correct answer: (D) 0.41

Explanation

P(defective) = 0.25×0.05 + 0.35×0.04 + 0.40×0.02 = 0.0125 + 0.014 + 0.008 = 0.0345. By Bayes' theorem, P(Q | defective) = 0.014/0.0345 ≈ 0.41.

Q1585DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following is/are the characteristic(s) of Teacher Centred Approach of teaching-learning? I. Extrinsic modes of motivation like praise, rewards and punishment are generally used by the teachers. II. Emphasis is given on passive listening, reading and writing and reproducing things taught by or as directed by the teacher.
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (C) Both I and II

Explanation

In a teacher-centred approach the teacher controls learning, uses extrinsic motivation (praise, rewards, punishment), and students mainly listen passively and reproduce what was taught. Both are features.

Q1586DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
'It is not always possible to bring real objects to the classroom'. Which of the following is/are the reason(s) behind the given statement? I. Size of the object II. Safety III. Cost
  1. AI, II and III
  2. BII and III
  3. COnly III
  4. DI and II
Show answerHide answer

Correct answer: (A) I, II and III

Explanation

Real objects may be too big or too small, unsafe to bring (dangerous animals, chemicals) or too costly, so size, safety and cost are all reasons.

Q1587DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
'If you are planning to teach the different states of India in class VI, then you need to know whether the students are well conversant in using the atlas'. This given statement is referred to which of the following phase(s) of Assessment For Learning? I. Formative Assessment II. Diagnostic Assessment
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (B) Only II

Explanation

Checking whether students already have a prerequisite skill (using an atlas) before teaching a topic is diagnostic assessment of their prior knowledge.

Q1588DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
While giving written feedback in Assessment for Learning, which of the following point(s) need to be taken care of? I. Don't jump straight to errors. Praise first. II. Encourage the student to make corrections. Don't simply write the correct answers, spellings and so on.
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (C) Both I and II

Explanation

Good written feedback starts with praise of what is done well, then points out errors, and asks the student to make corrections rather than simply writing the correct answer. Both points apply.

Q1589DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
________ is the first step for learning a language. I. Speaking II. Listening
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (C) Both I and II

Explanation

Language learning starts with oral skills: in the LSRW order listening comes first, closely followed by speaking, before reading and writing. The key accepts both as the first step.

Q1590DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
How can we provide opportunities for listening and speaking in the classroom? I. Listening and singing poems II. Discussion through pictures
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (C) Both I and II

Explanation

Listening to and singing poems, and talking about pictures, both give children chances to listen and speak in class.

Q1591DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
In order to use drama as a linguistic activity, which of the following characteristic(s) need to be included? I. Freedom II. Enjoyment
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (C) Both I and II

Explanation

Drama works as a language activity when children have freedom to express themselves and enjoy it, so both freedom and enjoyment are needed.

Q1592DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
People who work with visual images includes ________. I. Painters II. Sculptors
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (C) Both I and II

Explanation

Painters and sculptors both create visual images (visual arts), so both are included.

Q1593DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following statement(s) is/are NOT correct? I. Gender is a socio-cultural construct. II. Sex is systemic.
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (B) Only II

Explanation

Gender is a socio-cultural construct (correct). Sex is biological, not "systemic"; it is gender that is socially and systemically constructed, so statement II is not correct.

Q1594DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1
Which of the following is/are the special feature(s) of Kasturba Gandhi Balika Vidyalaya? I. Providing residential facilities to create a free environment for learning II. Providing life skill trainings III. Providing extra coaching for slow learners
  1. AI, II and III
  2. BOnly III
  3. CII and III
  4. DI and III
Show answerHide answer

Correct answer: (A) I, II and III

Explanation

KGBVs are residential upper primary schools for girls from disadvantaged groups. They provide hostel facilities, life skill training and extra or bridge coaching for slow learners, so all three are features.

Q1595DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)
Which of the following mechanisms ensures that data is NOT duplicated after crash recovery?
  1. ASequence numbers and acknowledgments
  2. BPort numbers
  3. CTimeouts
  4. DWindow size adjustment
Show answerHide answer

Correct answer: (A) Sequence numbers and acknowledgments

Explanation

TCP numbers every byte with sequence numbers and confirms receipt with acknowledgments. After recovery, the receiver can then detect and discard duplicate segments.

Q1596DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)
Which of the following statements correctly updates the Bill column in the Customer table by applying a 10% discount only for customers who belong to the 'High privilege' account?
  1. AMODIFY Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';
  2. BUPDATE Customer SET Bill = Bill / 1.1;
  3. CUPDATE Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';
  4. DUPDATE Customer (Bill) VALUES (Bill / 1.1) WHERE Account = 'High privilege';
Show answerHide answer

Correct answer: (C) UPDATE Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';

Explanation

UPDATE ... SET ... WHERE changes only the rows that match. Dividing by 1.1 gives the discounted bill, and the WHERE clause limits it to 'High privilege' accounts. MODIFY is not DML, and B has no WHERE.

Q1597DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)
What is the output of the following SQL command if the subquery returns no rows? DELETE FROM Product WHERE ProductID IN (SELECT ProductID FROM ArchivedProduct WHERE Status = 'Sell');
  1. ANo rows are deleted
  2. BAll rows in Product are deleted
  3. CRows will be deleted from ArchivedProduct
  4. DError
Show answerHide answer

Correct answer: (A) No rows are deleted

Explanation

If the subquery returns no rows, the IN list is empty and the condition is false for every row, so no rows are deleted from Product and no error occurs.

Q1598DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)
Which of the following statements is true about TRUNCATE in SQL (Structured Query Language)?
  1. ATRUNCATE removes table structure.
  2. BTRUNCATE does not remove data from the table.
  3. CTRUNCATE is a DML command.
  4. DTRUNCATE is faster than DELETE.
Show answerHide answer

Correct answer: (D) TRUNCATE is faster than DELETE.

Explanation

TRUNCATE removes all rows at once with little logging and no row-by-row triggers, so it is faster than DELETE. It keeps the table structure and is a DDL command.

Q1599DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)
What does the DROP TABLE command do?
  1. ADeletes a table permanently from the database
  2. BDeletes all records in a table but keeps the structure
  3. CDeletes only duplicate rows in a table
  4. DRestores deleted data from the table
Show answerHide answer

Correct answer: (A) Deletes a table permanently from the database

Explanation

DROP TABLE removes the table's structure and all its data from the database permanently. TRUNCATE is the command that empties a table but keeps it.

Q1600DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)
What mechanism is used by TCP to establish a reliable connection?
  1. AThree-way handshake
  2. BSimple handshake
  3. CFour-way handshake
  4. DTwo-way handshake
Show answerHide answer

Correct answer: (A) Three-way handshake

Explanation

TCP sets up a connection with a three-way handshake (SYN, SYN-ACK, ACK). The two sides agree on initial sequence numbers before data is sent.

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.

More DSSSB TGT / PGT subjects