A question bank for every class and subject

Practice questions, with answers and explanations included

794 questions available

Refine

All questions

794 results
201

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

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);
203

E-Governance refers to:

MCQ Easy
a. Use of ICT tools for governance by the government for citizens
b. A private company's e-commerce website
c. A social media platform
d. A type of database management system
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Use of ICT tools for governance by the government for citizens
Explanation: E-Governance is the use of electronic/ICT tools for governance by the government for the citizens, enhancing access to information and services.
204

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

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;
206

Which was the national satellite-based computer network launched in 1987, providing the main thrust for e-Governance in India?

MCQ Medium
a. NeGP
b. NICNET
c. DISNIC
d. DAR&PG
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
NICNET
Explanation: NICNET, launched in 1987, was the national satellite-based computer network that provided the main thrust for e-Governance in India.
207

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).
208

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;
209

Which program was launched to computerize all district offices in India, offering free hardware/software to State Governments?

MCQ Medium
a. NeGP
b. DISNIC
c. NICNET
d. DAR&PG
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
DISNIC
Explanation: The District Information System of the National Informatics Centre (DISNIC) program computerized district offices, offering free hardware and software.
210

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

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';
212

The National e-Governance Plan (NeGP) was formulated in which year?

MCQ Medium
a. 1987
b. 1990
c. 2000
d. 2006
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
2006
Explanation: The National e-Governance Plan (NeGP) was formulated in 2006 by DEITY and DAR&PG, boosting the e-Governance process.
213

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

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';
215

Which website is described as the National Portal of India providing single-window access to government information and services?

MCQ Medium
a. goidirectory.nic.in
b. india.gov.in
c. irctc.co.in
d. ncert.nic.in
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
india.gov.in
Explanation: india.gov.in is the National Portal of India, providing single-window access to information and services of various government entities.
216

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

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';
218

An online reservation system requires that the user must have some understanding of using a computer.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
TRUE
Explanation: Although online reservation is convenient, it is important that the user understands how to use a computer for making the reservation.
219

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).
220

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;