Which of the following is NOT a characteristic of a table in First Normal Form (1NF)?
Each column contains atomic values
The table contains a foreign key referencing another table
A primary key uniquely identifies each row
There are no repeating groups of columns
Which of the following is NOT a common SQL data type?
VARCHAR
BOOLEAN
INTEGER
ARRAY
Which SQL keyword is used to establish a relationship between two entities by referencing the primary key of one table in another table?
PRIMARY KEY
RELATIONSHIP
FOREIGN KEY
JOIN
What is the primary benefit of using cascading actions in database design?
Simplified data manipulation
Reduced storage space
Enhanced security
Improved query performance
What potential drawback might arise from over-normalizing a database?
Improved data integrity
Increased data redundancy
Reduced query complexity
Increased difficulty in data retrieval and updates
Which normal form acts as the foundation for higher levels of normalization?
Boyce-Codd Normal Form (BCNF)
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
What happens to records in the 'Orders' table with 'ON UPDATE CASCADE' if a customer's ID is updated in the 'Customers' table?
The corresponding customer IDs in the 'Orders' table are automatically updated.
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 orders are deleted from the 'Orders' table.
What type of relationship typically exists between a fact table and a dimension table in a Star Schema?
One-to-many
Many-to-one
One-to-one
Many-to-many
Which of the following is NOT a valid action for cascading actions in SQL?
ON UPDATE CASCADE
ON SELECT CASCADE
ON DELETE CASCADE
ON INSERT CASCADE
What is a potential drawback of using a Snowflake Schema compared to a Star Schema?
Slower query performance due to denormalization
More complex queries due to normalization
Limited ability to model complex relationships