ITSS 3300 EXAM 2 UPDATED ACTUAL QUESTIONS AND CORRECT ANSWERS

ITSS 3300 EXAM 2 UPDATED ACTUAL QUESTIONS AND
CORRECT ANSWERS

Question:
1. Database Management System (DBMS)
Answer:
A software that enables organizations to centralize data, manage it efficiently, and provide access to stored
data

Question:
2. Data Redundancy
Answer:
The presence of duplicate data in multiple files, leading to inefficiency

Question:
3. Data Inconsistency
Answer:
Different versions of the same data across systems

Question:
4. Relational Database
Answer:
A database organized into tables (relations) with rows and columns

Question:
5. Primary Key
Answer:
A unique identifier for each record in a table

Question:
6. Foreign Key
Answer:
A field that links to the primary key in another table

Question:
7. SQL (Structured Query Language)
Answer:
A language used to manage and query data in relational databases

Question:
8. Data Warehouse
Answer:
A centralized repository storing historical and current data for analysis

, Question:
9. Data Mining
Answer:
The process of discovering patterns and relationships in large datasets

Question:
10. Big Data
Answer:
Datasets with high volume, velocity, and variety requiring advanced tools

Question:
11. Hadoop
Answer:
An open-source framework for distributed data processing

Question:
12. NoSQL Database
Answer:
A non-relational database designed for scalability and flexibility

Question:
13. TCP/IP
Answer:
The suite of communication protocols used for the internet

Question:
14. Packet Switching
Answer:
A method of breaking data into packets for transmission

Question:
15. DNS (Domain Name System)
Answer:
Translates domain names into IP addresses

Question:
16. Cloud Computing
Answer:
Delivery of computing services over the internet

Question:
17. IaaS (Infrastructure as a Service)
Answer:
Provides virtualized computing resources over the internet