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

141

Which keyboard combination is used to forcefully open the Windows Task Manager to end an unresponsive application?

MCQ Easy

a. Ctrl+Alt+Delete

b. Ctrl+Shift+Esc only

c. Alt+F4

d. Ctrl+C

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

Show answer

Ctrl+Alt+Delete

Explanation: Pressing and holding Ctrl+Alt+Delete opens the Windows Task Manager to forcefully end a non-responding application.

142

Write an SQL query to display fname and marks of students where marks not equal to 0.

SHORT Medium

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

Show answer

Explanation: SELECT fname, marks FROM STUDENT WHERE marks <> 0;

143

Write an SQL query to find the total salary of all teachers.

SHORT Easy

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

Show answer

Explanation: SELECT SUM(Salary) AS Total_Salary FROM Teacher;

144

What is the recommended minimum free hard drive space to maintain good system performance?

MCQ Medium

a. 10-20 MB

b. 50-100 MB

c. 200-500 MB

d. 1-2 GB

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

Show answer

200-500 MB

Explanation: There should be at least 200-500 MB of free hard drive space for smooth functioning of the computer.

145

Write an SQL query to display fname and marks of students where marks between 60 and 80.

SHORT Easy

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

Show answer

Explanation: SELECT fname, marks FROM STUDENT WHERE marks BETWEEN 60 AND 80;

146

Write an SQL query to find the maximum and minimum salary among all teachers.

SHORT Easy

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

Show answer

Explanation: SELECT MAX(Salary) AS Max_Salary, MIN(Salary) AS Min_Salary FROM Teacher;

147

Which of these is NOT a function of Utility software?

MCQ Medium

a. Improving system performance

b. Providing virus protection

c. Compiling source code into machine code

d. Managing disk space

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

Show answer

Compiling source code into machine code

Explanation: Utilities improve performance, provide security, manage disk space and backups; compiling code is the job of a compiler/translator, not a utility.

148

Write an SQL query to display fname and marks of students where marks between 45 and 55.

SHORT Medium

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

Show answer

Explanation: SELECT fname, marks FROM STUDENT WHERE marks BETWEEN 45 AND 55;

149

Write an SQL query to count the number of teachers earning more than Rs 40000.

SHORT Easy

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

Show answer

Explanation: SELECT COUNT(*) FROM Teacher WHERE Salary > 40000;

150

Before troubleshooting, it is a good practice to take a backup of important files.

TRUE FALSE Easy

a. TRUE

b. FALSE

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

Show answer

TRUE

Explanation: Always take a backup of important files to another source, like a pen drive, before troubleshooting.

151

Write an SQL query to display fname and marks of students where marks in 88, 90, or 95.

SHORT Medium

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

Show answer

Explanation: SELECT fname, marks FROM STUDENT WHERE marks IN (88, 90, 95);

152

Write an SQL query to display teacher names, current salary, and a 10 percent increased salary (as New_Salary) for teachers in department 4.

SHORT Medium

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

Show answer

Explanation: SELECT First_Name, Last_Name, Salary, Salary*1.1 AS New_Salary FROM Teacher WHERE Dept_No = 4;

153

A hard reboot (manually turning off the computer) is recommended as the first troubleshooting step.

TRUE FALSE Medium

a. TRUE

b. FALSE

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

Show answer

FALSE

Explanation: A hard reboot should be performed only as a last resort in extreme situations, as it may cause data loss.

154

Write an SQL query to display fname and marks of students where marks in 40, 50, or 60.

SHORT Easy

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

Show answer

Explanation: SELECT fname, marks FROM STUDENT WHERE marks IN (40, 50, 60);

155

Write an SQL query using GROUP BY to find the number of teachers in each department (Dept_No).

SHORT Medium

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

Show answer

Explanation: SELECT Dept_No, COUNT(*) AS No_of_Teachers FROM Teacher GROUP BY Dept_No;

156

What should you check first if a printer is not printing?

SHORT Easy

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

Show answer

Explanation: Check that the printer is properly connected and switched on, that it is not out of paper, that there is no paper jam, and that the ink/toner cartridge is not empty.

157

Write an SQL query to display fname and marks of students where gender equal to 'F'.

SHORT Medium

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

Show answer

Explanation: SELECT fname, marks FROM STUDENT WHERE gender = 'F';

158

Write an SQL query using GROUP BY and JOIN to find the number of teachers per department, showing department names.

SHORT Medium

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

Show answer

Explanation: SELECT Dept_No, Dept_Name, COUNT(*) AS No_of_Teachers FROM Teacher, Department WHERE Dept_ID = Dept_No GROUP BY Dept_No;

159

Explain the common troubleshooting steps to be followed when a connected device does not switch on.

LONG Medium

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

Show answer

Explanation: Close unnecessary running programs; check cables to ensure all connections are tight and correctly plugged in and that power buttons are ON (and batteries charged for wireless devices); repeat the steps that led to the problem to see if it recurs; use the Help window (F1) to find a solution; record the full error message for future reference; and finally restart the peripheral device or the whole computer if the device still does not switch on.

160

Write an SQL query to display fname and marks of students where gender equal to 'M'.

SHORT Medium

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

Show answer

Explanation: SELECT fname, marks FROM STUDENT WHERE gender = 'M';