(Grade X) Case Study
Chapter 1: Networking and Telecommunication
1. A student has connected a
laptop to the internet at home without using any cables. Which technology is
being used to transmit data in this situation, and how does it work?
Answer:The technology used
is Wi-Fi. It transmits data using radio waves between the router
and the laptop without using cables.
2.A school has connected 25
computers using network cables so students can share files and printers. Which
type of network is this, and why?
Answer:It is a Local
Area Network (LAN) because it connects computers within a small area like a
school or office.
3. A teacher sends the exam
routine to students using email. Which internet service is being used, and what
is its advantage?
Answer:The service is Email.
It allows users to send and receive messages and files quickly over the
internet.
4. A student attends an online
class and talks to the teacher using video and audio from home. Which internet
service is being used?
Answer:The service is Video
Conferencing. It allows people in different places to communicate through
live video and audio over the internet.
5A village receives internet
service through optical fiber cables installed by an internet service provider.
Which transmission media is used, and why is it preferred?
Answer:The transmission
media is Optical Fiber Cable. It is preferred because it provides
high-speed data transmission and is less affected by interference.
6. A student opens a web browser
and types www.neb.gov.np to check
examination notices. Which internet service is being used?
Answer:The service is the World
Wide Web (WWW). It allows users to access web pages and information through
websites.
7. A company has offices in
Kathmandu, Pokhara, and Biratnagar. All offices are connected to share data and
communicate. Which type of network is suitable?
Answer:The suitable
network is Wide Area Network (WAN) because it connects computers over
large geographical areas.
8. A student uses mobile data on a
smartphone to browse educational websites while travelling. Which communication
technology is being used?
Answer:The technology used
is Cellular Network (Mobile Network). It provides internet access
through mobile towers using wireless signals.
9. Two friends transfer notes from
one smartphone to another without using the internet. Which wireless technology
is being used?
Answer:The technology used
is Bluetooth. It transfers data wirelessly over a short distance using
radio waves.
10. A family has connected several
smartphones, laptops, and a smart TV to one internet connection at home. Which
networking device is mainly responsible for this connection?
Answer:The device is a Router.
It connects multiple devices to the internet and transfers data between them.
Chapter
4: Database Management System
1.
A
school stores the names, roll numbers, classes, and marks of all students in a
computerized system. Which type of software is used to manage this information,
and why?
Answer:A Database
Management System (DBMS) is used because it stores, manages, and
retrieves data efficiently.
2.
A
hospital keeps patient details, doctor information, and treatment records in a
computer. Why is using a DBMS better than storing the information in separate
files?
Answer:A DBMS reduces
data duplication, provides easy access, and improves data security.
3.
A
librarian wants to quickly find the details of a book by entering its book ID.
Which feature of a DBMS makes this possible?
Answer:The search
and retrieval feature of a DBMS allows records to be found quickly.
4.
A
bank stores customer names, account numbers, balances, and transaction details.
Which object in a database stores this information in rows and columns?
Answer:A Table
stores the information in rows and columns.
5.A company assigns a unique Employee ID
to every employee so that no two employees have the same ID. Which database key
is being used?
Answer:A Primary
Key is being used because it uniquely identifies each record.
6.A teacher wants to display only the
students who scored more than 80 marks from the student database. Which
database operation should be used?
Answer:A Query
should be used to retrieve the required records.
7.
During
admission, a college enters student information into a database. Later, one
student changes their phone number. Which database operation is performed?
Answer:The Update
operation is performed to change the existing data.
8.
An
online shopping website stores product names, prices, and stock details. When a
new product is added, which database operation is used?
Answer:The Insert
operation is used to add a new record.
9.
Only
the manager is allowed to delete employee records from the company's database.
Which feature of a DBMS helps provide this protection?
Answer:Data Security provides access
control and protects the database from unauthorized users.
10.
A
school uses a database to calculate and print fee receipts for students every
month. Mention one advantage of using a DBMS in this situation.
Answer:A DBMS provides fast
processing, reduces errors, and makes record management easy.