What is the PRIMARY purpose of using indexes in a database?
To improve data security
To speed up data retrieval operations
To enforce data integrity constraints
To reduce disk space consumption
In a table with a composite key, a non-key attribute depends on only one part of the key. Which normal form is violated?
Second Normal Form (2NF)
First Normal Form (1NF)
Third Normal Form (3NF)
None of the above
What is a potential drawback of using a Snowflake Schema compared to a Star Schema?
More complex queries due to normalization
Increased data redundancy
Limited ability to model complex relationships
Slower query performance due to denormalization
Which of the following is a key benefit of using a well-designed schema for a data warehouse?
Reduced need for data modeling and analysis
Simplified data loading from various sources
Improved query performance and efficiency
Increased data redundancy for backups
You have a table with columns for StudentID, StudentName, CourseID, and CourseName. StudentID determines StudentName, and CourseID determines CourseName. What normal form is this table in?
What is the role of a column in a database table?
To represent a specific attribute or characteristic of an entity.
To link the table to another table.
To define a row in the table.
To store the entire dataset of the table.
Which of the following is NOT a characteristic of a table in First Normal Form (1NF)?
A primary key uniquely identifies each row
Each column contains atomic values
The table contains a foreign key referencing another table
There are no repeating groups of columns
What is the primary benefit of using cascading actions in database design?
Enhanced security
Simplified data manipulation
Reduced storage space
Improved query performance
What is the purpose of a referential integrity constraint in a relational database?
To prevent unauthorized access to sensitive data
To enforce relationships between tables by ensuring that related data exists
To ensure that all data in a table is unique
To speed up data retrieval queries
A table has a composite primary key (using two columns). What condition must be met for it to be considered in Second Normal Form (2NF)?
No non-key attribute should be dependent on only part of the primary key
It must already be in 1NF
It must have no transitive dependencies
All columns must have unique values