ITSS 3300 Exam 2 UPDATED
QUESTIONS AND CORRECT ANSWERS
Database Management System (DBMS) - CORRECT ANSWER A software that enables
organizations to centralize data, manage it efficiently, and provide access to stored data
Data Redundancy - CORRECT ANSWER The presence of duplicate data in multiple files,
leading to inefficiency
Data Inconsistency - CORRECT ANSWER Different versions of the same data across systems
Relational Database - CORRECT ANSWER A database organized into tables (relations) with
rows and columns
Primary Key - CORRECT ANSWER A unique identifier for each record in a table
Foreign Key - CORRECT ANSWER A field that links to the primary key in another table
SQL (Structured Query Language) - CORRECT ANSWER A language used to manage and
query data in relational databases
Data Warehouse - CORRECT ANSWER A centralized repository storing historical and current
data for analysis
Data Mining - CORRECT ANSWER The process of discovering patterns and relationships in
large datasets
Big Data - CORRECT ANSWER Datasets with high volume, velocity, and variety requiring
advanced tools
Hadoop - CORRECT ANSWER An open-source framework for distributed data processing
, NoSQL Database - CORRECT ANSWER A non-relational database designed for scalability
and flexibility
TCP/IP - CORRECT ANSWER The suite of communication protocols used for the internet
Packet Switching - CORRECT ANSWER A method of breaking data into packets for
transmission
DNS (Domain Name System) - CORRECT ANSWER Translates domain names into IP
addresses
Cloud Computing - CORRECT ANSWER Delivery of computing services over the internet
IaaS (Infrastructure as a Service) - CORRECT ANSWER Provides virtualized computing
resources over the internet
PaaS (Platform as a Service) - CORRECT ANSWER Provides platforms for developing
applications
SaaS (Software as a Service) - CORRECT ANSWER Delivers software applications over the
internet
Edge Computing - CORRECT ANSWER Processing data near its source instead of centralized
servers
Content Delivery Network (CDN) - CORRECT ANSWER Distributed servers delivering web
content efficiently
Information Systems Security - CORRECT ANSWER Policies and controls to protect
information assets
Malware - CORRECT ANSWER Malicious software designed to harm systems
QUESTIONS AND CORRECT ANSWERS
Database Management System (DBMS) - CORRECT ANSWER A software that enables
organizations to centralize data, manage it efficiently, and provide access to stored data
Data Redundancy - CORRECT ANSWER The presence of duplicate data in multiple files,
leading to inefficiency
Data Inconsistency - CORRECT ANSWER Different versions of the same data across systems
Relational Database - CORRECT ANSWER A database organized into tables (relations) with
rows and columns
Primary Key - CORRECT ANSWER A unique identifier for each record in a table
Foreign Key - CORRECT ANSWER A field that links to the primary key in another table
SQL (Structured Query Language) - CORRECT ANSWER A language used to manage and
query data in relational databases
Data Warehouse - CORRECT ANSWER A centralized repository storing historical and current
data for analysis
Data Mining - CORRECT ANSWER The process of discovering patterns and relationships in
large datasets
Big Data - CORRECT ANSWER Datasets with high volume, velocity, and variety requiring
advanced tools
Hadoop - CORRECT ANSWER An open-source framework for distributed data processing
, NoSQL Database - CORRECT ANSWER A non-relational database designed for scalability
and flexibility
TCP/IP - CORRECT ANSWER The suite of communication protocols used for the internet
Packet Switching - CORRECT ANSWER A method of breaking data into packets for
transmission
DNS (Domain Name System) - CORRECT ANSWER Translates domain names into IP
addresses
Cloud Computing - CORRECT ANSWER Delivery of computing services over the internet
IaaS (Infrastructure as a Service) - CORRECT ANSWER Provides virtualized computing
resources over the internet
PaaS (Platform as a Service) - CORRECT ANSWER Provides platforms for developing
applications
SaaS (Software as a Service) - CORRECT ANSWER Delivers software applications over the
internet
Edge Computing - CORRECT ANSWER Processing data near its source instead of centralized
servers
Content Delivery Network (CDN) - CORRECT ANSWER Distributed servers delivering web
content efficiently
Information Systems Security - CORRECT ANSWER Policies and controls to protect
information assets
Malware - CORRECT ANSWER Malicious software designed to harm systems
