What is a potential drawback of using a Snowflake Schema compared to a Star Schema?
More complex queries due to normalization
Slower query performance due to denormalization
Limited ability to model complex relationships
Increased data redundancy
What is the purpose of a referential integrity constraint in a relational database?
To ensure that all data in a table is unique
To speed up data retrieval queries
To prevent unauthorized access to sensitive data
To enforce relationships between tables by ensuring that related data exists
What is the primary benefit of using cascading actions in database design?
Enhanced security
Improved query performance
Simplified data manipulation
Reduced storage space
What type of relationship typically exists between a fact table and a dimension table in a Star Schema?
Many-to-many
One-to-many
One-to-one
Many-to-one
In which scenario might denormalization be considered acceptable in database design?
To improve query performance by reducing joins
To simplify the database schema
To enforce strict data integrity
To increase data redundancy
In a database table, what does a 'row' represent?
A specific attribute or characteristic of an entity.
A relationship between two different tables.
A unique record or instance within the table.
A column header describing the data type.
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Transitive dependency
Join dependency
Partial dependency
Multi-valued dependency
What is the PRIMARY purpose of using indexes in a database?
To reduce disk space consumption
To enforce data integrity constraints
To speed up data retrieval operations
To improve data security
Which of the following is NOT a common SQL data type?
ARRAY
VARCHAR
BOOLEAN
INTEGER
Which of the following best describes a partial dependency in a database table?
A non-key attribute is dependent on only part of a composite primary key
A non-key attribute is dependent on another non-key attribute
A foreign key is dependent on the primary key of the same table
A primary key is dependent on a foreign key