Database, Networks, and Cybersecurity Concepts

Front

What is a DBMS?

Back

Software that creates, manages and controls access to databases (e.g., Oracle, MySQL)

Front

What problem does normalization solve?

Back

Reduces data redundancy and inconsistency by organizing data into tables

Front

What are the first three normal forms?

Back

1NF: Eliminate repeating groups, 2NF: Remove partial dependencies, 3NF: Remove transitive dependencies

Front

What's the difference between a primary key and foreign key?

Back

Primary key: Unique identifier for a table; Foreign key: References primary key in another table

Front

What is NoSQL used for?

Back

Handling unstructured data and big data applications

Front

What are the 4Vs of Big Data?

Back

Volume, Velocity, Variety, Veracity

Front

What does OLAP stand for?

Back

Online Analytical Processing - used for complex queries and trend analysis

Front

What is a data warehouse?

Back

Central repository for analytical data from multiple sources

Front

What is the difference between a data warehouse and data mart?

Back

Data warehouse: Enterprise-wide; Data mart: Department-specific subset

Front

What is data mining?

Back

Process of discovering patterns in large datasets