Questions Library

Question bank

Class 11

1 subject · 443 questions

Information Technology (802)

Refine

Subject

Type

All questions

443 results

281

Differentiate between MAN and WAN.

LONG Medium

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

Show answer

Explanation: MAN spans up to about 50 Km, typically linking networks within a single city. WAN spans about 1000 Km, connecting networks across a country or continent, and is generally larger and slower than a MAN.

282

Which operator is used to fetch records where a column value lies within a specified range, inclusive of the bounds?

MCQ Easy

a. IN

b. LIKE

c. BETWEEN

d. IS

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

Show answer

BETWEEN

Explanation: The BETWEEN operator fetches data within a range of values, including both the upper and lower bounds.

283

Differentiate between Internet and WWW.

LONG Medium

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

Show answer

Explanation: The Internet is a global network of interconnected networks (network of networks) that enables communication and data exchange between remote nodes using protocols like TCP/IP. The World Wide Web (WWW) is a service that runs over the Internet — a repository of linked documents (web pages) accessed via HTTP, containing text, images, and hyperlinks.

284

Which logical operator returns TRUE only when both conditions in a WHERE clause are TRUE?

MCQ Easy

a. OR

b. AND

c. NOT

d. IN

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

Show answer

AND

Explanation: The AND operator returns TRUE only if both connected conditions evaluate to TRUE.

285

What will be the final value of sum1 after this code executes? int sum1 = 3; sum1 = sum1 + 1; sum1 = sum1 + 1; sum1 = sum1 + 1; sum1 = sum1 + 1;

MCQ Medium

a. 5

b. 6

c. 4

d. 7

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

Show answer

Explanation: sum1 starts at 3 and is incremented by 1 four times: 3+1+1+1+1 = 7.

286

Which operator/keyword must be used to test whether a column value IS a NULL value (since = NULL is undefined)?

MCQ Medium

a. #NAME?

b. IS NULL

c. <> NULL

d. !NULL

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

Show answer

IS NULL

Explanation: The IS operator (IS NULL / IS NOT NULL) is used to test for NULL values; the operations = NULL and <> NULL are not defined in SQL.

287

Consider: int anumber = 14; if (anumber >= 10) jLabel1.setText("first string"); else jLabel1.setText("second string"); jLabel2.setText("third string"); What is displayed in jLabel1 and jLabel2?

MCQ Medium

a. first string, third string

b. second string, third string

c. first string only

d. second string only

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

Show answer

first string, third string

Explanation: Since anumber (14) is >= 10, the if-condition is true, so jLabel1 displays 'first string'. The statement setting jLabel2 to 'third string' is outside the if-else block and always executes.

288

Which SQL clause is used to sort the result set of a query?

MCQ Easy

a. GROUP BY

b. ORDER BY

c. SORT BY

d. ARRANGE BY

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

Show answer

ORDER BY

Explanation: ORDER BY clause sorts the result set based on one or more columns, in ascending (ASC, default) or descending (DESC) order.

289

What is wrong with the test condition: if( (ctr < 5) && (ctr > 30) )

MCQ Medium

a. The && operator cannot be used in a test condition

b. The test condition is always false

c. The test condition is always true

d. Nothing is wrong with it

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

Show answer

The test condition is always false

Explanation: No value of ctr can be simultaneously less than 5 AND greater than 30, so this condition is always false.

290

By default, records displayed using the ORDER BY clause (without DESC) are sorted in:

MCQ Easy

a. Descending order

b. Random order

c. Ascending order

d. Insertion order

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

Show answer

Ascending order

Explanation: By default, ORDER BY sorts records in ascending order of the specified column unless DESC is specified.

291

Given: int a=11, b=22, c=33, d=11; Which of these relational expressions are TRUE? i) a==b ii) b!=d iii) c<=b iv) a<c v) a==d vi) c>a vii) a>=c

MCQ Hard

a. i, iv & vii

b. ii, iv, v & vi

c. ii, iv, vi & vii

d. iii, v, vi & vii

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

Show answer

ii, iv, v & vi

Explanation: b!=d (22!=11) is true; a<c (11<33) is true; a==d (11==11) is true; c>a (33>11) is true. So ii, iv, v, and vi are true.

292

Which keyword provides a customized column heading in the output of a SELECT query without altering the table?

MCQ Medium

a. ALIAS

b. AS

c. NAME

d. LABEL

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

Show answer

Explanation: The AS keyword is used to give an alias name to a column in the SELECT output; it does not change the actual table.

293

Convert: 2 KB = ______ MB.

SHORT Medium

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

Show answer

Explanation: 2 KB = 2 x 1024 MB = 2048 MB.

294

Which query correctly displays first names of students whose marks are either 88, 92, or 95?

MCQ Medium

a. SELECT fname FROM student WHERE marks LIKE (88,92,95);

b. SELECT fname FROM student WHERE marks IN (88,92,95);

c. SELECT fname FROM student WHERE marks BETWEEN 88 AND 95;

d. SELECT fname FROM student WHERE marks = (88,92,95);

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

Show answer

SELECT fname FROM student WHERE marks IN (88,92,95);

Explanation: The IN operator is used to match a column against a specific set of listed values, e.g., marks IN (88,92,95).

295

Convert: 3 KB = ______ MB.

SHORT Medium

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

Show answer

Explanation: 3 KB = 3 x 1024 MB = 3072 MB.

296

Which command is used to insert a new row into a table?

MCQ Easy

a. INSERT INTO

b. ADD INTO

c. APPEND INTO

d. CREATE INTO

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

Show answer

INSERT INTO

Explanation: INSERT INTO <table>(<columns>) VALUES (values); is used to insert a new row into a table.

297

Convert: 4 KB = ______ MB.

SHORT Medium

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

Show answer

Explanation: 4 KB = 4 x 1024 MB = 4096 MB.

298

The '*' symbol in a SELECT statement is used to display all columns of a table.

TRUE FALSE Easy

a. TRUE

b. FALSE

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

Show answer

TRUE

Explanation: SELECT * FROM <table>; retrieves and displays all columns of the specified table.

299

Convert: 5 KB = ______ MB.

SHORT Medium

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

Show answer

Explanation: 5 KB = 5 x 1024 MB = 5120 MB.

300

Using WHERE clause conditions in a SELECT statement permanently changes the values stored in the table.

TRUE FALSE Medium

a. TRUE

b. FALSE

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

Show answer

FALSE

Explanation: Calculations or filters applied via SELECT only affect the displayed result set; the actual table data remains unchanged unless UPDATE is used.