What element in an ER diagram describes the properties or characteristics of an entity?
Entity
Cardinality
Relationship
Attribute
What is the primary benefit of using cascading actions in database design?
Enhanced security
Reduced storage space
Improved query performance
Simplified data manipulation
In a table with a composite key, a non-key attribute depends on only one part of the key. Which normal form is violated?
First Normal Form (1NF)
None of the above
Second Normal Form (2NF)
Third Normal Form (3NF)
Which of the following is a characteristic of a Dimension table in a Star Schema?
Provides descriptive attributes about business entities
Contains highly transactional data
Typically has a small number of rows
Focuses on storing calculated metrics
In which scenario might denormalization be considered acceptable in database design?
To increase data redundancy
To enforce strict data integrity
To simplify the database schema
To improve query performance by reducing joins
Which of the following is NOT a common SQL data type?
INTEGER
BOOLEAN
VARCHAR
ARRAY
What is the purpose of a referential integrity constraint in a relational database?
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
To prevent unauthorized access to sensitive data
In which scenario might a Snowflake Schema be preferred over a Star Schema?
When dealing with small datasets
When data integrity is critical, and redundancy needs to be minimized
When storage space is a major concern
When query performance is the top priority
What is the key difference between a database and a schema?
A database stores the actual data, while a schema defines the rules for accessing that data.
A database is a collection of tables, while a schema defines the structure of a single table.
There is no difference; the terms are interchangeable.
A database is a broader concept encompassing one or more schemas, each defining a logical structure within the database.
Which of the following relationships is typically NOT implemented directly in a database but is often represented using an intermediary table?
One-to-One
Many-to-Many
All of the above
One-to-Many