What issue does Third Normal Form (3NF) primarily address?
Transitive dependencies between non-key attributes
Lack of a primary key
Partial dependencies on the primary key
Repeating groups of data
What happens to records in the 'Orders' table with 'ON UPDATE CASCADE' if a customer's ID is updated in the 'Customers' table?
An error occurs, and the update operation on the 'Customers' table is rolled back.
The 'Orders' table is unaffected, and the old customer ID remains.
The corresponding customer IDs in the 'Orders' table are automatically updated.
The corresponding orders are deleted from the 'Orders' table.
Why is data redundancy undesirable in a database?
It complicates data retrieval and manipulation
It can lead to data inconsistencies and anomalies
All of the above
It increases storage space requirements
What type of relationship typically exists between a fact table and a dimension table in a Star Schema?
Many-to-many
One-to-one
Many-to-one
One-to-many
What is the primary difference between a Star Schema and a Snowflake Schema?
Snowflake Schemas normalize dimension tables.
Snowflake Schemas don't use fact tables.
Star Schemas are used for real-time analytics.
Star Schemas have more joins.
How is a one-to-many relationship represented in an ER diagram?
A single line connecting two entities
A diamond connecting two entities
Two lines connecting two entities
A line with a crow's foot symbol on one end and a single line on the other
Which data validation technique prevents invalid data from being entered into the database by checking it against predefined rules?
Check Constraints
Data Scrubbing
Data Transformation
Data Masking
Which of the following is NOT a common SQL data type?
ARRAY
INTEGER
VARCHAR
BOOLEAN
Referential integrity ensures that...
relationships between tables remain consistent.
data is backed up regularly.
all columns in a table have unique values.
queries are optimized for performance.
Which of the following is NOT a valid SQL data type for storing numerical values?
DECIMAL
FLOAT