A question bank for every class and subject

Practice questions, with answers and explanations included

794 questions available

Refine

All questions

794 results
61

Convert: 4096 Bytes = ______ KB.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: 4096 Bytes = 4096 / 1024 KB = 4 KB.
62

Which of the following is NOT one of the standard SQL aggregate functions?

MCQ Easy
a. COUNT
b. SUM
c. SORT
d. AVG
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
SORT
Explanation: The standard aggregate functions are COUNT, SUM, MAX, MIN, and AVG. SORT is not an aggregate function.
63

How many times does the loop body execute? for(int count=0; count<5; count++)

MCQ Medium
a. 5
b. 6
c. 4
d. 7
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
5
Explanation: The loop runs from count=0 while count<5, stepping by 1 each time, giving 5 iterations.
64

1024 Megabytes is equal to:

MCQ Easy
a. 1 Kilobyte
b. 1 Gigabyte
c. 1 Terabyte
d. 1 Petabyte
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
1 Gigabyte
Explanation: 1024 MB = 1 Gigabyte (GB), as per the standard storage hierarchy.
65

Convert: 5120 Bytes = ______ KB.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: 5120 Bytes = 5120 / 1024 KB = 5 KB.
66

Which aggregate function returns the number of tuples in the result of a query?

MCQ Easy
a. SUM
b. COUNT
c. AVG
d. MAX
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
COUNT
Explanation: COUNT counts the number of tuples (rows) in the result of a query; COUNT(*) counts all rows.
67

How many times does the loop body execute? for(int count=2; count<=20; count = count + 2)

MCQ Medium
a. 10
b. 11
c. 9
d. 12
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
10
Explanation: The loop runs from count=2 while count<=20, stepping by 2 each time, giving 10 iterations.
68

Which device converts AC power supply to the low voltage DC required by the computer?

MCQ Easy
a. Motherboard
b. NIC
c. Power Supply Unit
d. Cache Memory
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Power Supply Unit
Explanation: The Power Supply Unit converts AC current from the mains to low-voltage DC needed by the machine.
69

Convert: 2048 KB = ______ MB.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: 2048 KB = 2048 / 1024 MB = 2 MB.
70

What is the difference between COUNT(Salary) and COUNT(*)?

MCQ Hard
a. They are identical in every case
b. COUNT(Salary) ignores NULL salary values while COUNT(*) counts all rows regardless of NULLs
c. COUNT(*) is invalid syntax
d. COUNT(Salary) always returns 0
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
COUNT(Salary) ignores NULL salary values while COUNT(*) counts all rows regardless of NULLs
Explanation: COUNT(column) counts only non-NULL values in that column, while COUNT(*) counts all rows in the result, regardless of NULL values.
71

How many times does the loop body execute? for(int count=5; count>=1; count--)

MCQ Medium
a. 5
b. 6
c. 4
d. 7
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
5
Explanation: The loop runs from count=5 while count>=1, stepping by -1 each time, giving 5 iterations.
72

Which of the following correctly orders storage capacity from smallest to largest?

MCQ Medium
a. Byte, Bit, Nibble, KB
b. Bit, Nibble, Byte, KB
c. Nibble, Bit, Byte, KB
d. KB, Byte, Nibble, Bit
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Bit, Nibble, Byte, KB
Explanation: The correct order is Bit < Nibble (4 bits) < Byte (8 bits) < Kilobyte (1024 bytes).
73

Convert: 3072 KB = ______ MB.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: 3072 KB = 3072 / 1024 MB = 3 MB.
74

Which clause is used to group rows sharing a common value in one or more columns, typically with an aggregate function?

MCQ Easy
a. ORDER BY
b. GROUP BY
c. HAVING
d. WHERE
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
GROUP BY
Explanation: The GROUP BY clause groups rows based on an attribute (e.g., Dept_No) so aggregate functions can be applied per group.
75

How many times does the loop body execute? for(int count=10; count>1; count--)

MCQ Medium
a. 9
b. 10
c. 8
d. 11
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
9
Explanation: The loop runs from count=10 while count>1, stepping by -1 each time, giving 9 iterations.
76

Which is an example of an optical storage device?

MCQ Easy
a. Pen drive
b. Hard Disk
c. DVD
d. RAM
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
DVD
Explanation: CD and DVD are examples of optical storage devices; DVDs have higher capacity than CDs.
77

Convert: 4096 KB = ______ MB.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: 4096 KB = 4096 / 1024 MB = 4 MB.
78

Which clause is used to filter groups AFTER a GROUP BY has been applied (as opposed to filtering individual rows)?

MCQ Medium
a. WHERE
b. HAVING
c. ORDER BY
d. DISTINCT
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
HAVING
Explanation: HAVING is used to filter groups after GROUP BY, e.g., HAVING COUNT(*) > 1; WHERE cannot be used to filter on aggregate results.
79

How many times does the loop body execute? for(int count=1; count<=7; count++)

MCQ Medium
a. 7
b. 8
c. 6
d. 9
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
7
Explanation: The loop runs from count=1 while count<=7, stepping by 1 each time, giving 7 iterations.
80

Processor speed is generally measured in megahertz (MHz) or gigahertz (GHz).

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: Speed of processors is measured in MHz (millions of instructions/cycles per second) or GHz (billions).