Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Partial dependency
Transitive dependency
Multi-valued dependency
Join dependency
You are designing a schema to represent a relationship between 'Students' and 'Courses'. What type of relationship best describes this scenario?
Many-to-many
One-to-one
One-to-many
Many-to-one
What is the primary difference between a Star Schema and a Snowflake Schema?
Star Schemas have more joins.
Snowflake Schemas don't use fact tables.
Snowflake Schemas normalize dimension tables.
Star Schemas are used for real-time analytics.
What does the 'ON DELETE CASCADE' constraint do?
It sets the foreign key values in the child table to NULL when a record in the parent table is deleted.
It has no impact on 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 automatically deletes matching records in the child table when a record in the parent table is deleted.
Which SQL statement is used to create a new table in a database?
NEW TABLE
CREATE TABLE
INSERT TABLE
MAKE TABLE
In a Star Schema, what is the central table called that contains the key performance indicators (KPIs)?
Lookup Table
Fact Table
Dimension Table
Entity Table
Which of the following relationships is typically NOT implemented directly in a database but is often represented using an intermediary table?
One-to-One
One-to-Many
Many-to-Many
All of the above
Which of the following is a key benefit of using a well-designed schema for a data warehouse?
Simplified data loading from various sources
Increased data redundancy for backups
Reduced need for data modeling and analysis
Improved query performance and efficiency
Which of the following is NOT a valid SQL data type for storing numerical values?
VARCHAR
FLOAT
INTEGER
DECIMAL
Which of the following is NOT a common SQL data type?
ARRAY
BOOLEAN