Question bank

Class 11

1 subject · 443 questions

Refine

All questions

443 results
121

Write an SQL query to display empname of employees whose salary is at least 60000.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE esal >= 60000.00;
122

Differentiate between Guided and Unguided transmission media, giving examples of each.

LONG Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Guided medium refers to physical conductors such as twisted pair cable, coaxial cable, and fiber optics, where the signal travels as voltage/current (twisted pair, coaxial) or light (fiber optic). Unguided medium uses electromagnetic waves that do not require a physical conductor, such as microwave, radio wave, and infrared.
123

Write an SQL query to display empname of employees who work in the Sales department.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE edept = 'Sales';
124

Explain any three network devices used in setting up a computer network: Repeater, Hub, and Router.

LONG Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Repeater: restores a weakened/distorted signal to its original form so it can travel a greater distance; placed between two cable segments. Hub: connects several cable segments through multiple I/O ports; data received on one line is sent out to all other lines. Router: connects different networks (LAN or WAN) with each other, maintaining a routing table and forwarding incoming packets to the appropriate network based on the destination address.
125

Write an SQL query to display empname of employees who do NOT work in the Sales department.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE edept <> 'Sales';
126

Compare Bus, Ring, Star, and Mesh topologies on the basis of cabling requirement and fault tolerance.

LONG Hard
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Bus topology uses minimal cabling (a single backbone) but fault detection/isolation is difficult, and a single break can disrupt the whole network. Ring topology needs a cable in the shape of a ring; addition/deletion of devices and fault detection is easy, but a single point failure disrupts the entire network. Star topology needs more cabling as every node connects to a central hub; it is easy to install and isolate faults, but hub failure brings down the whole network. Mesh topology requires the most cabling (dedicated links between every pair of nodes) and is difficult to install as nodes grow, but it provides secure, traffic-free data transfer with no single point of failure.
127

Write an SQL query to display empname of employees who belong to the city Jaipur.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE city = 'Jaipur';
128

Which protocol is used for transferring files between hosts on a TCP-based network?

MCQ Easy
a. HTTP
b. FTP
c. SMTP
d. TELNET
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FTP
Explanation: FTP (File Transfer Protocol) is used for transferring files between local hosts (clients) and remote hosts (servers).
129

Write an SQL query to display empname of employees whose zone is not specified (NULL).

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE zone IS NULL;
130

TELNET stands for:

MCQ Medium
a. Telecommunication Network
b. Terminal Network
c. Telephone Network
d. Text Network
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Terminal Network
Explanation: TELNET stands for TErminaLNETwork; it is a client-server application allowing remote login to a system.
131

Write an SQL query to display empname of employees whose zone is specified (NOT NULL).

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE zone IS NOT NULL;
132

Which protocol allows downloading of email messages to a local computer so they can be read offline?

MCQ Medium
a. POP3
b. HTTP
c. FTP
d. TELNET
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
POP3
Explanation: POP3 (Post Office Protocol version 3) allows downloading email messages onto a local computer for offline reading.
133

Write an SQL query to display empname of employees who are Managers.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE designation = 'Manager';
134

The World Wide Web (WWW) is based on which protocol for client-server communication?

MCQ Easy
a. FTP
b. SMTP
c. HTTP
d. TELNET
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
HTTP
Explanation: WWW uses a distributed client-server architecture based on HTTP (HyperText Transfer Protocol).
135

Write an SQL query to display distinct departments (edept) from the EMPLOYEE table.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT DISTINCT edept FROM EMPLOYEE;
136

Which TCP/IP layer is responsible for dividing the message into segments and appending source/destination port information?

MCQ Medium
a. Application Layer
b. Transport Layer
c. Internet Layer
d. Link Layer
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Transport Layer
Explanation: The Transport layer appends port information and divides the message into segments, using protocols like TCP and UDP.
137

Write an SQL query to display distinct genders from the STUDENT table.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT DISTINCT gender FROM STUDENT;
138

Which of these protocols is connectionless and used for quick request-reply communication rather than assured delivery?

MCQ Medium
a. TCP
b. UDP
c. FTP
d. HTTP
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
UDP
Explanation: UDP (User Datagram Protocol) is an unreliable, connectionless protocol suited for short messages where speed matters more than guaranteed delivery.
139

Write an SQL query to display rno as 'Roll Number' and fname as 'First Name' from the STUDENT table using aliases.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT rno AS 'Roll Number', fname AS 'First Name' FROM STUDENT;
140

SMTP and POP3 are examples of e-mail protocols.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: Email transfer over the Internet is governed by protocols such as SMTP (Simple Mail Transfer Protocol) and POP3 (Post Office Protocol).