What is the main advantage of achieving higher normal forms in database design?
Slower query processing
Improved data integrity and reduced anomalies
More complex database structure
Increased data redundancy
Which of these is crucial to consider when choosing data types for columns?
The type of storage device used by the database server.
The kind of data the column will store and its expected size.
The color scheme of the user interface.
The username of the person creating the table.
What is a potential drawback of using a Snowflake Schema compared to a Star Schema?
Slower query performance due to denormalization
Limited ability to model complex relationships
More complex queries due to normalization
What potential drawback might arise from over-normalizing a database?
Increased difficulty in data retrieval and updates
Improved data integrity
Reduced query complexity
Which of the following is NOT a valid SQL data type for storing numerical values?
VARCHAR
DECIMAL
FLOAT
INTEGER
What does the 'ON DELETE CASCADE' constraint do?
It has no impact on the child table when a record in the parent table is deleted.
It automatically deletes matching records in the child table when a record in the parent table is deleted.
It prevents deletion of records in the parent table if there are matching records in the child table.
It sets the foreign key values in the child table to NULL when a record in the parent table is deleted.
Which normal form acts as the foundation for higher levels of normalization?
Boyce-Codd Normal Form (BCNF)
Third Normal Form (3NF)
First Normal Form (1NF)
Second Normal Form (2NF)
What is the primary goal of database normalization?
Enhancing data security
Reducing data redundancy and anomalies
Improving query performance
Minimizing storage space
What is the PRIMARY purpose of using indexes in a database?
To reduce disk space consumption
To improve data security
To enforce data integrity constraints
To speed up data retrieval operations
How is a one-to-many relationship represented in an ER diagram?
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
A single line connecting two entities