A question bank for every class and subject

Practice questions, with answers and explanations included

794 questions available

Refine

All questions

794 results
221

Online shopping is best described as:

MCQ Easy
a. An e-governance application
b. An e-commerce application where customers purchase goods over the Internet
c. A social networking application
d. A programming language
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
An e-commerce application where customers purchase goods over the Internet
Explanation: Online shopping is an e-commerce application where customers can purchase goods over the Internet and have them delivered.
222

TELNET stands for:

MCQ Medium
a. Telecommunication Network
b. Terminal Network
c. Telephone Network
d. Text Network
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Terminal Network
Explanation: TELNET stands for TErminaLNETwork; it is a client-server application allowing remote login to a system.
223

Write an SQL query to display empname of employees whose zone is specified (NOT NULL).

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE zone IS NOT NULL;
224

Which of these is NOT a typical mode of payment mentioned for online shopping?

MCQ Easy
a. Credit/debit card
b. Net banking
c. Cash on Delivery
d. Barter exchange
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Barter exchange
Explanation: Typical modes of payment for online shopping include credit/debit card, net banking, e-gift voucher, cash on delivery, and wire transfer — not barter exchange.
225

Which protocol allows downloading of email messages to a local computer so they can be read offline?

MCQ Medium
a. POP3
b. HTTP
c. FTP
d. TELNET
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
POP3
Explanation: POP3 (Post Office Protocol version 3) allows downloading email messages onto a local computer for offline reading.
226

Write an SQL query to display empname of employees who are Managers.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT empname FROM EMPLOYEE WHERE designation = 'Manager';
227

Which of the following is an online educational site offering free video tutorials on subjects like mathematics, history, and physics?

MCQ Easy
a. Flipkart
b. Khan Academy
c. IRCTC
d. Ebay
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Khan Academy
Explanation: Khan Academy is an educational website offering free video tutorials on various subjects.
228

The World Wide Web (WWW) is based on which protocol for client-server communication?

MCQ Easy
a. FTP
b. SMTP
c. HTTP
d. TELNET
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
HTTP
Explanation: WWW uses a distributed client-server architecture based on HTTP (HyperText Transfer Protocol).
229

Write an SQL query to display distinct departments (edept) from the EMPLOYEE table.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT DISTINCT edept FROM EMPLOYEE;
230

Which type of online tutorial involves real-time lectures where users can participate and ask questions?

MCQ Medium
a. Video/slide tutorials
b. Interactive tutorials
c. Webinars
d. Text tutorials
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Webinars
Explanation: Webinars are real-time lectures where users participate live and get their questions answered.
231

Which TCP/IP layer is responsible for dividing the message into segments and appending source/destination port information?

MCQ Medium
a. Application Layer
b. Transport Layer
c. Internet Layer
d. Link Layer
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Transport Layer
Explanation: The Transport layer appends port information and divides the message into segments, using protocols like TCP and UDP.
232

Write an SQL query to display distinct genders from the STUDENT table.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT DISTINCT gender FROM STUDENT;
233

w3schools.com is primarily known for offering free tutorials in which area?

MCQ Easy
a. Cooking recipes
b. Web development technologies (HTML, CSS, JavaScript, PHP)
c. Financial accounting
d. Medical sciences
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Web development technologies (HTML, CSS, JavaScript, PHP)
Explanation: w3schools.com offers free tutorials in web development technologies like HTML, CSS, Javascript, and PHP.
234

Which of these protocols is connectionless and used for quick request-reply communication rather than assured delivery?

MCQ Medium
a. TCP
b. UDP
c. FTP
d. HTTP
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
UDP
Explanation: UDP (User Datagram Protocol) is an unreliable, connectionless protocol suited for short messages where speed matters more than guaranteed delivery.
235

Write an SQL query to display rno as 'Roll Number' and fname as 'First Name' from the STUDENT table using aliases.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: SELECT rno AS 'Roll Number', fname AS 'First Name' FROM STUDENT;
236

A task undertaken to create a unique product, service, or result, with a definite beginning and end, is called a:

MCQ Easy
a. Program
b. Project
c. Function
d. Module
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Project
Explanation: A project is a task undertaken to create a unique product/service/result, having a beginning and end, finite resources, and a specific time frame.
237

SMTP and POP3 are examples of e-mail protocols.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: Email transfer over the Internet is governed by protocols such as SMTP (Simple Mail Transfer Protocol) and POP3 (Post Office Protocol).
238

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

Which is the CORRECT order of the four main phases of a web application development project?

MCQ Medium
a. Design, Requirement Definition, Testing, Implementation
b. Requirement Definition, Design, Implementation, Testing
c. Implementation, Testing, Design, Requirement Definition
d. Testing, Design, Implementation, Requirement Definition
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Requirement Definition, Design, Implementation, Testing
Explanation: The four phases, in order, are: Requirement Definition, Design, Implementation, and Testing (with Planning and Monitoring running throughout).
240

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.