A question bank for every class and subject

Practice questions, with answers and explanations included

794 questions available

Refine

All questions

794 results
241

Write an SQL query to increase the salary of all employees by 10 percent using UPDATE.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: UPDATE EMPLOYEE SET esal = esal + esal*0.1;
242

Checking whether a project is technically possible and economically profitable is part of which activity?

MCQ Medium
a. Scope definition
b. Feasibility check
c. Testing
d. Implementation
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Feasibility check
Explanation: Feasibility check examines whether a project is technically feasible (possible to do) and economically feasible (profitable).
243

Explain the four layers of the TCP/IP model and the primary function of each.

LONG Hard
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Application Layer: creates and processes the message at the sender's/receiver's end and envelopes it with a header; protocols like HTTP and POP3 operate here. Transport Layer: appends source and destination port information and divides the message into segments (using TCP for reliable delivery or UDP for fast, connectionless delivery). Internet Layer: adds source and destination IP addresses to the segments using the Internet Protocol (IP), defining the packet format. Link Layer (Host-to-Internet layer): adds the header containing sender and receiver physical (MAC) addresses to the packet.
244

Write an SQL query to change the zone from 'North' to 'East' for employees whose city is 'Jaipur'.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: UPDATE EMPLOYEE SET zone = 'East' WHERE city = 'Jaipur';
245

Designing the map of the web application site, the database, and the page structure is part of which phase?

MCQ Medium
a. Requirement Definition Phase
b. Design Phase
c. Implementation Phase
d. Testing Phase
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Design Phase
Explanation: The Design Phase focuses on 'how' the application is designed, including the site map, database design, and page structure.
246

A malicious program that requires no host application and floods the hard disk by making copies of itself is called a:

MCQ Medium
a. Virus
b. Worm
c. Trojan Horse
d. Firewall
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Worm
Explanation: A worm automatically creates several copies of itself on the hard disk without needing a host application, e.g., the Code Red Worm.
247

Write an SQL query to delete the record of the student whose roll number (rno) is 13.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: DELETE FROM STUDENT WHERE rno = 13;
248

Creating the backend database, developing the frontend, and establishing data connectivity between them is part of which phase?

MCQ Medium
a. Requirement Definition Phase
b. Design Phase
c. Implementation Phase
d. Testing Phase
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Implementation Phase
Explanation: The Implementation Phase involves creating the backend database, frontend, and the connectivity between them.
249

A program that appears useful but creates a backdoor allowing hacker access is called a:

MCQ Easy
a. Worm
b. Virus
c. Trojan Horse
d. Spyware
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Trojan Horse
Explanation: A Trojan Horse appears desirable/useful but creates a backdoor through which a hacker can access the system.
250

What is the value of 17 % 5 in Java (the remainder operator)?

MCQ Easy
a. 2
b. 3
c. 85
d. 22
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
2
Explanation: The % operator returns the remainder of division. 17 % 5 = 2.
251

Testing each page and feature of an application, finding and fixing bugs, is part of which phase?

MCQ Easy
a. Design Phase
b. Implementation Phase
c. Testing Phase
d. Planning Phase
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Testing Phase
Explanation: The Testing Phase involves testing the complete application, finding bugs, fixing them, and validating the modified code.
252

An attack that floods a machine/network with excessive requests to make it unavailable to legitimate users is called:

MCQ Medium
a. Phishing
b. Denial of Service (DoS) attack
c. Eavesdropping
d. Spamming
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Denial of Service (DoS) attack
Explanation: A Denial-of-Service (DoS) attack overloads a system with superfluous requests, making it unavailable to legitimate users.
253

What is the value of 20 % 3 in Java (the remainder operator)?

MCQ Easy
a. 2
b. 6
c. 60
d. 23
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
2
Explanation: The % operator returns the remainder of division. 20 % 3 = 2.
254

Project Management is the process of achieving project objectives through activities defined within a time frame using knowledge, skills, tools and techniques.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
TRUE
Explanation: Project Management is the application of knowledge, skills, tools, and techniques to project activities to meet requirements within a defined time frame.
255

Stealing personal information through fraudulent emails or fake links is called:

MCQ Easy
a. Vishing
b. Phishing
c. Cyberstalking
d. SIM Swap Scam
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Phishing
Explanation: Phishing refers to stealing personal information through fraud emails or links to fake web pages.
256

What is the value of 9 % 2 in Java (the remainder operator)?

MCQ Easy
a. 1
b. 4
c. 18
d. 11
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
1
Explanation: The % operator returns the remainder of division. 9 % 2 = 1.
257

Name the four main phases in the development of a web-based application.

SHORT Easy
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Explanation: Requirement Definition Phase, Design Phase, Implementation Phase, and Testing Phase (with a Planning and Monitoring phase running across all of them).
258

Seeking personal information like OTP, PIN, or CVV through a phone call is known as:

MCQ Medium
a. Phishing
b. Vishing
c. SMSing
d. Spamming
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Vishing
Explanation: Vishing is seeking personal information such as OTP, PIN, CVV through a phone call.
259

What is the value of 14 % 4 in Java (the remainder operator)?

MCQ Easy
a. 2
b. 3
c. 56
d. 18
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
2
Explanation: The % operator returns the remainder of division. 14 % 4 = 2.
260

What two aspects of feasibility should be checked in the Requirement Definition Phase?

SHORT Medium
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Explanation: Technical feasibility (is it possible to do?) and economic feasibility (is it profitable?).