Question bank

Class 11

1 subject · 443 questions

Refine

All questions

443 results
81

Write an SQL query to display fname and marks of students where marks between 45 and 55.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks BETWEEN 45 AND 55;
82

Before troubleshooting, it is a good practice to take a backup of important files.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: Always take a backup of important files to another source, like a pen drive, before troubleshooting.
83

Write an SQL query to display fname and marks of students where marks in 88, 90, or 95.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks IN (88, 90, 95);
84

A hard reboot (manually turning off the computer) is recommended as the first troubleshooting step.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: A hard reboot should be performed only as a last resort in extreme situations, as it may cause data loss.
85

Write an SQL query to display fname and marks of students where marks in 40, 50, or 60.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks IN (40, 50, 60);
86

What should you check first if a printer is not printing?

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Check that the printer is properly connected and switched on, that it is not out of paper, that there is no paper jam, and that the ink/toner cartridge is not empty.
87

Write an SQL query to display fname and marks of students where gender equal to 'F'.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE gender = 'F';
88

Explain the common troubleshooting steps to be followed when a connected device does not switch on.

LONG Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Close unnecessary running programs; check cables to ensure all connections are tight and correctly plugged in and that power buttons are ON (and batteries charged for wireless devices); repeat the steps that led to the problem to see if it recurs; use the Help window (F1) to find a solution; record the full error message for future reference; and finally restart the peripheral device or the whole computer if the device still does not switch on.
89

Write an SQL query to display fname and marks of students where gender equal to 'M'.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE gender = 'M';
90

ARPANET, developed in 1969, made use of which technology?

MCQ Medium
a. Circuit switching
b. Digital packet switching
c. Frequency hopping
d. Optical switching
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Digital packet switching
Explanation: ARPANET was developed using digital packet switching technology proposed by Paul Baran, Donald Davies, and Len Kleinrock.
91

Write an SQL query to display fname and marks of students where fname starting with the letter 'A'.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE fname LIKE 'A%';
92

Which body coordinates the assignment of unique identifiers like domain names and IP addresses on the Internet?

MCQ Medium
a. IETF
b. ICANN
c. ISP
d. W3C
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
ICANN
Explanation: ICANN (Internet Corporation for Assigned Names and Numbers) coordinates domain names, IP addresses, and other identifiers.
93

Write an SQL query to display fname and marks of students where fname ending with the letter 'H'.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE fname LIKE '%H';
94

In which mode of communication can data be transferred in only one direction?

MCQ Easy
a. Simplex
b. Half-duplex
c. Full-duplex
d. Duplex
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Simplex
Explanation: In simplex mode, information can be transferred only in one direction (unidirectional).
95

Write an SQL query to display fname and marks of students where fname containing the substring 'AN'.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE fname LIKE '%AN%';
96

Which network device connects two or more LANs, possibly operating at different speeds?

MCQ Medium
a. Repeater
b. Hub
c. Bridge
d. Switch
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Bridge
Explanation: A bridge is a multiport device used to connect two or more LANs, enabling communication between devices on different LAN segments.
97

Write an SQL query to display fname and marks of students where fname of exactly five characters.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE fname LIKE '_____';
98

Which network device is used to restore a weakened/distorted signal so it can travel farther?

MCQ Medium
a. Router
b. Repeater
c. Gateway
d. Switch
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Repeater
Explanation: A repeater restores the input signal to its original form; it is also called a digital regenerator.
99

Write an SQL query to display fname and marks of students where marks IS NULL.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks IS NULL;
100

Which topology uses a backbone cable, with nodes connected via a tap connector?

MCQ Easy
a. Star
b. Ring
c. Bus
d. Mesh
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Bus
Explanation: Bus topology uses a long backbone cable to which nodes connect via taps; it requires less cabling but fault detection is difficult.