What is the process of ensuring that data across related tables remains consistent and synchronized called?
Data Warehousing
Data Integrity
Data Validation
Data Normalization
Which of the following is NOT a common SQL data type?
VARCHAR
INTEGER
ARRAY
BOOLEAN
What is the PRIMARY purpose of using indexes in a database?
To reduce disk space consumption
To enforce data integrity constraints
To improve data security
To speed up data retrieval operations
Which of the following is a characteristic of a Dimension table in a Star Schema?
Focuses on storing calculated metrics
Contains highly transactional data
Provides descriptive attributes about business entities
Typically has a small number of rows
When converting an ER diagram to a database schema, what does an entity typically become?
A table
A database
A row
A column
What potential drawback might arise from over-normalizing a database?
Reduced query complexity
Increased data redundancy
Improved data integrity
Increased difficulty in data retrieval and updates
Why is data redundancy undesirable in a database?
It can lead to data inconsistencies and anomalies
It increases storage space requirements
All of the above
It complicates data retrieval and manipulation
Which of the following is NOT a typical example of a dimension in a data warehouse schema?
Product
Time
Sales Amount
Customer
Which data validation technique prevents invalid data from being entered into the database by checking it against predefined rules?
Data Masking
Data Scrubbing
Check Constraints
Data Transformation
Which statement is TRUE regarding the different normal forms?
A table in 3NF is also automatically in 2NF and 1NF
1NF is the most desirable normal form for all databases
Normalization guarantees perfect database design
2NF automatically implies 3NF