Write an SQL query to retrieve names of teachers whose first name starts with the letter 'S'.
SHORT
Easy
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: SELECT First_Name FROM Teacher WHERE First_Name LIKE 'S%';
126
What is an Operating System?
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: An Operating System is software that acts as an interface between the user and the computer hardware, managing resources and coordinating the components of a computer.
127
Write an SQL query to display fname and marks of students where marks greater than 85.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks > 85;
128
Write an SQL query to retrieve names of teachers having at least 6 characters in the first name.
SHORT
Hard
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: SELECT First_Name FROM Teacher WHERE First_Name LIKE '______%';
129
Name the two main types of file systems mentioned in the chapter.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: FAT (File Allocation Table, e.g., FAT16/FAT32) and NTFS (New Technology File System).
130
Write an SQL query to display fname and marks of students where marks less than 40.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks < 40;
131
Write an SQL query to list names of teachers in alphabetical order (by First_Name then Last_Name).
SHORT
Easy
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: SELECT First_Name, Last_Name FROM Teacher ORDER BY First_Name, Last_Name;
132
List the various functions of an Operating System and briefly explain any two.
LONG
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: Functions: Communication Manager, Resource Management, Process Management, File Management, and Memory Management. Process Management: the OS manages, controls and schedules all processes in memory or waiting for the CPU, deciding which process gets the processor and for how long. Memory Management: the OS allocates working memory (RAM) to processes dynamically — on demand and released when not needed.
133
Write an SQL query to display fname and marks of students where marks greater than or equal to 90.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks >= 90;
134
Write an SQL query to list department names in descending alphabetical order.
SHORT
Easy
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: SELECT Dept_Name FROM Department ORDER BY Dept_Name DESC;
135
Differentiate between Single-tasking and Multi-tasking operating systems, and between Single-user and Multi-user operating systems.
LONG
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: Single-tasking OS allows execution of only one program at a time, while Multi-tasking OS can execute multiple programs simultaneously by dividing processor time among processes. Single-user OS allows only one user to use the system (e.g., typical desktop systems), while Multi-user OS allows many users to access the system by maintaining accounts of all registered users.
136
Write an SQL query to display fname and marks of students where marks less than or equal to 33.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks <= 33;
137
Write an SQL query to retrieve details of teachers whose Last_Name is NOT specified (NULL).
SHORT
Easy
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: SELECT * FROM Teacher WHERE Last_Name IS NULL;
138
Which key is generally used to access the Help window while troubleshooting?
MCQ
Easy
a.F1
b.F2
c.F5
d.F12
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
F1
Explanation: Pressing F1 accesses the Help window, which may help find a solution to a problem.
139
Write an SQL query to display fname and marks of students where marks equal to 100.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: SELECT fname, marks FROM STUDENT WHERE marks = 100;
140
Write a nested SQL query to retrieve the names of all departments having female teachers.
SHORT
Hard
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: SELECT DISTINCT Dept_Name FROM Department WHERE Dept_ID IN (SELECT Dept_No FROM Teacher WHERE Gender = 'F');