(Grade X) Exam time

Full Marks: 50

Chapter 2-DBMS, Chapter 4 (Part 1) and (Part 2), Chapter 1- Computer Network and Communication

Question Pattern

MCQsà 10QX1=10

Short Q/A à10QX2=20

5 Q/A, 3 case study, 2 (UDF)

Long Q/A à5QX4=20

2 Q/A, 1 study the program, 1 dry run output, 1 UDF

1.      Differentiate between the Internet, extranet and Intranet. Also explain components of data communication

2.      Differentiate between LAN, MAN and WAN. Also explain transmission mode.

3.      Differentiate between client server network and peer to peer network. 

4.      List different type of topology and explain them with labeled diagram.   

5.      Differentiate between DDL and DML with any two examples.

6.      A school assigns a unique student ID to every student so that no two students have the same ID. Which database key is being used? Mention two advantages of it.

7.      Explain different types of relationship in dbms.

8.        Explain local and global variable with example.  

9.      What do you mean by bandwidth, throughput, and broadband in data communication?

10.   What are the different types of broadband connections? Explain their main features and uses.

Type of Broadband Connection	Main Features	Uses
DSL (Digital Subscriber Line)	Uses telephone lines, always connected, faster than dial-up.	Home Internet, web browsing, email, online learning.
Cable Broadband	Uses cable TV network, provides high-speed Internet.	Streaming videos, online gaming, downloading large files.
Fiber Optic Broadband	Uses optical fiber cables, offers the fastest speed, reliable connection.	Video conferencing, cloud computing, business, HD/4K streaming.
Wireless Broadband (Wi-Fi/Mobile Broadband)	Uses radio signals through mobile towers or wireless devices, no cables required.	Internet on smartphones, laptops, remote areas, travel.
Satellite Broadband	Uses satellites to provide Internet, available in places without cable or fiber.	Rural and mountainous areas, remote communication, disaster management.

11.   Write a Python function returns the area of a circle.

12.   Write a Python function returns the area of a rectangle.

13.   Write a Python program to display factor of a given number using function.  

14.   Write a Python program to display factorial of a given number using function.  

15.   Write a Python program to display smallest among given two/three number using function.  

16.   Write a program to count the number of characters R/r present in the given word by using function.  

17.   Write a program to count the number of vowel/consonant present in the given word by using function.  

Please explain the answers to the following case studies in detail, as only the key points have been provided below:

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

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

20.  A 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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