Comptuer network
Comptuer network
Comptuer network
DB
DB
100
What is a computer network?
A computer network is a system of interconnected computing devices (nodes)—such as laptops, servers, and, printers—that exchange data and share resources via wired (fiber optic, cable) or wireless (Wi-Fi) connections.
100
Which topology has no central device and each node is connected in a closed loop?
Ring topology.
100
In which topology is every device connected to a central hub or switch?
Star topology.
100
What is a database?
An organized collection of related data stored electronically.
100
Which database structure stores data in tables with rows and columns?
Relational database.
200
Which component enables devices to communicate using rules and standards?
Network protocols. 
200
Which transmission medium uses light signals for data transfer?
Optical fiber.
200
Why is mesh topology considered highly reliable?
Because multiple paths exist between nodes, ensuring communication even if one link fails.
200
What is the role of a Database Management System (DBMS)?
To create, store, retrieve, and manage data efficiently.
200
Which database structure stores data in parent–child relationships?
Hierarchical database.
300
What type of network covers a small geographical area like an office or campus?
Local Area Network (LAN).
300
Which network connects computers over large geographical distances using public infrastructure?
Wide Area Network (WAN).
300
Which network enables employees to work remotely?
Virtual Private Network (VPN).
300
Explain the role of data integrity in database systems.
Data integrity ensures accuracy, consistency, and reliability of data throughout its lifecycle.
300
What is metadata and why is it important in databases?
Metadata is data about data; it helps in understanding structure, meaning, and usage. Qualitative data.
400
Finding products frequently bought together is an example of which data mining techniqu?.
Association rule mining
400
Banking transactions are to OLTP as business trend analysis is to this system.
OLAP
400
This trend emphasizes high-speed wireless communication for massive device connectivity.
5G networking?
400
Compare centralized and distributed databases.
Centralized databases store data at one location, while distributed databases store data across multiple locations.
400
How does data mining differ from traditional querying?
Data mining discovers hidden patterns, while querying retrieves known information.
500
Clustering differs from classification because it does not require this type of data.
labeled data
500
List the stage in database development.
Planning
Conceptual Design
Logical Design
Physical Design
Development
Testing
Deployment
Monitoring and Maintenance
500
What is the SQL code for CRUD operation in db on table student with attributes ID, Name, Location?
SQL Code for CRUD Operations
1️⃣ CREATE (Insert Data)
INSERT INTO Student (ID, Name, Location)
VALUES (1, 'Amit', 'Delhi');
VALUES (1, 'Amit', 'Delhi');
2️⃣ READ (Retrieve Data)
SELECT * FROM Student;
3️⃣ UPDATE (Modify Data)
UPDATE Student
SET Location = 'Mumbai'
WHERE ID = 1;
SET Location = 'Mumbai'
WHERE ID = 1;
4️⃣ DELETE (Remove Data)
DELETE FROM Student
WHERE ID = 1;
WHERE ID = 1;
500
CREATE Complete ER diagram of School management system.
500
Visualize multidimentional database using cube from following:
Dimensions and Members
Dimension 1: Product
Members:
Laptop
Smartphone
Tablet
Printer
Accessories
Dimension 2: Region
Members:
North
South
East
West
Dimension 3: Time
Members:
Q1
Q2
Q3
Q4