Questions Library

A question bank for every class and subject

Practice questions, with answers and explanations included

794 questions available

Class 10 Class 11 Class 12

Refine

Class

Subject

Type

All questions

794 results

181

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;

182

A Railway company has tables Machine(Machine_ID [PK, CHAR(3)], Station [CHAR(30)]) and Sales(Machine_ID [CHAR(3)], Date, Tickets_Sold [INTEGER], Income [DECIMAL(8,2)]), with Machine_ID+Date as the key of Sales. Write SQL queries to: (a) find the number of ticket machines in each station (b) find the total ticket income of station 'New Delhi' for each day (c) find the total tickets sold by machine with Machine_ID = 122 till date.

LONG Hard

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Explanation: (a) SELECT Station, COUNT(*) FROM Machine GROUP BY Station; (b) SELECT Date, SUM(Income) FROM Sales, Machine WHERE Sales.Machine_ID = Machine.Machine_ID AND Station = 'New Delhi' GROUP BY Date; (c) SELECT SUM(Tickets_Sold) FROM Sales WHERE Machine_ID = '122';

183

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.

184

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;

185

An application accessed via a web browser over a network connection is called a:

MCQ Easy

a. Desktop application

b. Web-based application

c. Firmware application

d. Standalone application

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Web-based application

Explanation: A web-based application is one that can be accessed via a web browser over a network connection, offering 24x7 availability.

186

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.

187

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;

188

Which of these is an example of an online reservation system application?

MCQ Easy

a. Word processor

b. Railway ticket booking

c. Spreadsheet software

d. Antivirus software

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Railway ticket booking

Explanation: Railway ticket booking (along with airline, bus, movie tickets, and hotel booking) is an example of an online reservation system.

189

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.

190

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;

191

Which of these is an advantage of an online reservation system for the CONSUMER?

MCQ Easy

a. Requires less staffing for the company

b. Convenience of booking anytime, anywhere

c. No spatial restrictions for office location

d. Global access for the business

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Convenience of booking anytime, anywhere

Explanation: Convenience (booking anytime/anywhere) is an advantage for the consumer; the other options are advantages for the service provider/company.

192

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.

193

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;

194

Which of these is an advantage of an online reservation system for the SERVICE PROVIDER?

MCQ Medium

a. Price comparison for the customer

b. Time saving for the customer

c. Requires less staffing since tasks are computerized

d. Discount schemes for the customer

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Requires less staffing since tasks are computerized

Explanation: Requiring less staffing (since tasks are computerized) is an advantage for the provider/company, not directly for the consumer.

195

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.

196

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;

197

Which of the following is a recommended precaution for online transactions?

MCQ Easy

a. Use your name or birthdate as password for easy recall

b. Make the password complex with mixed case, numbers, and special characters

c. Share your password with close friends for backup

d. Write your password on a sticky note near the computer

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Make the password complex with mixed case, numbers, and special characters

Explanation: A complex password (mixed case, numbers, special characters) decreases the chance of automated attacks succeeding; passwords should never be shared or use personal names.

198

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.

199

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;

200

IRCTC is an example of an online portal used for:

MCQ Easy

a. Online shopping

b. Booking railway tickets

c. E-governance tax filing