Class 11

Information Technology (802)

443 questions available

Refine

All questions

443 results
141

Write an SQL query to display employee names along with their salary after adding a 10 percent bonus (esal+esal*0.1).

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname, esal+esal*0.1 FROM EMPLOYEE;
142

What is Digital Literacy?

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Digital literacy refers to raising knowledge and awareness about technology such as computers, smartphones, and tablets, including familiarity with software tools and the Internet, enabling people to acquire, analyze, share, create, and deliver information efficiently.
143

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;
144

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.
145

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';
146

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.
147

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;
148

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.
149

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.
150

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.
151

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.
152

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.
153

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.
154

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.
155

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.
156

Which of these tools aims to protect the internal network from malicious traffic from external networks?

MCQ Easy
a. Antivirus
b. Password Manager
c. Firewall
d. Cookie
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Firewall
Explanation: A firewall inspects network traffic and blocks data that violates security constraints, protecting internal networks from malicious external traffic.
157

What is the value of 25 % 7 in Java (the remainder operator)?

MCQ Easy
a. 4
b. 3
c. 175
d. 32
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
4
Explanation: The % operator returns the remainder of division. 25 % 7 = 4.
158

Which act was introduced as an amendment to the IT Act 2000 for cyber security?

MCQ Hard
a. Information Technology Amendment Act, 2008
b. Cyber Crime Prevention Act, 2010
c. Digital India Act, 2005
d. Data Protection Act, 2000
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Information Technology Amendment Act, 2008
Explanation: The Information Technology Amendment Act, 2008 was introduced as an amendment to the IT Act 2000 to address cyber security.
159

What is the value of 18 % 6 in Java (the remainder operator)?

MCQ Easy
a. 0
b. 3
c. 108
d. 24
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
0
Explanation: The % operator returns the remainder of division. 18 % 6 = 0.
160

Which of the following is a small piece of information about a client stored by a website's server, later saved on the client's browser?

MCQ Medium
a. Malware
b. Cookie
c. Firewall
d. Patch
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Cookie
Explanation: A cookie is a small piece of client information stored by the server and later kept in the browser's cookie directory.