Question bank

Class 11

1 subject · 443 questions

Refine

All questions

443 results
101

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

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

Which topology requires a dedicated point-to-point link between every pair of nodes?

MCQ Medium
a. Bus
b. Ring
c. Star
d. Mesh
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Mesh
Explanation: In mesh topology, every node is connected to every other node through a dedicated link.
103

Write an SQL query to display fname, lname, and marks of all students sorted by marks in ascending order.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, lname, marks FROM STUDENT ORDER BY marks;
104

What is the typical maximum span of a LAN?

MCQ Medium
a. 10 meters
b. 1 Km
c. 50 Km
d. 1000 Km
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
1 Km
Explanation: A Local Area Network (LAN) is a private network that can span a radius of up to 1 Km.
105

Write an SQL query to display fname, lname, and marks of all students sorted by marks in descending order.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, lname, marks FROM STUDENT ORDER BY marks DESC;
106

Which network spans up to about 1000 Km and connects various LANs and MANs across a country or continent?

MCQ Medium
a. PAN
b. LAN
c. MAN
d. WAN
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
WAN
Explanation: WAN (Wide Area Network) spans about 1000 Km and connects LANs/MANs within a country or continent.
107

Write an SQL query to display fname, lname, and marks of all students sorted by fname in ascending order.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, lname, marks FROM STUDENT ORDER BY fname;
108

A MAC address is a:

MCQ Medium
a. 4-byte decimal number
b. 12-digit hexadecimal (48-bit) number
c. 8-bit binary code
d. 16-digit octal number
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
12-digit hexadecimal (48-bit) number
Explanation: MAC addresses are 12-digit hexadecimal (48-bit) numbers assigned by the NIC manufacturer, and they never change.
109

Write an SQL query to display fname, lname, and marks of all students sorted by fname in descending order.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname, lname, marks FROM STUDENT ORDER BY fname DESC;
110

Which of these correctly differentiates IP address from MAC address?

MCQ Medium
a. IP address never changes; MAC address changes with network
b. Both are assigned by the manufacturer
c. IP address is assigned by the network administrator/ISP; MAC address is assigned by the manufacturer
d. MAC address is 4 bytes; IP address is 6 bytes
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
IP address is assigned by the network administrator/ISP; MAC address is assigned by the manufacturer
Explanation: The IP address is assigned by the network administrator or ISP and can change; the MAC address is permanently assigned by the NIC manufacturer.
111

Write an SQL query to display fname of female students who scored more than 90 marks.

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

In full-duplex mode, both communicating parties can send and receive data at the same time.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: Full-duplex allows simultaneous two-way communication, used in interactive applications.
113

Write an SQL query to display fname of male students who scored more than 75 marks.

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

A hub is an intelligent device that forwards data only to the destination port.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: A hub sends incoming data to all lines except the one it received the data on; switches, not hubs, intelligently forward to a single destination line.
115

Write an SQL query to display fname of students who are female OR scored more than 95 marks.

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

A gateway connects networks that use different protocol technologies, performing protocol conversion.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: A gateway may be thought of as a router equipped with software for protocol conversion between different network technologies.
117

Write an SQL query to display fname of students whose marks are NOT less than 50.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT fname FROM STUDENT WHERE NOT(marks < 50);
118

Give the full forms of: (a) PAN (b) MAN (c) WAN.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: (a) PAN - Personal Area Network (b) MAN - Metropolitan Area Network (c) WAN - Wide Area Network.
119

Write an SQL query to display empname of employees whose salary is less than 50000.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE esal < 50000.00;
120

What is Domain Name Resolution?

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Domain Name Resolution is the process of obtaining the corresponding IP address of a computer from its domain name, typically performed with the help of Domain Name Servers (DNS).