What is the role of a column in a database table?
To define a row in the table.
To represent a specific attribute or characteristic of an entity.
To link the table to another table.
To store the entire dataset of the table.
Which of the following is NOT a valid SQL data type for storing numerical values?
VARCHAR
INTEGER
FLOAT
DECIMAL
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
Focuses on storing calculated metrics
Typically has a small number of rows
What is the role of cardinality in an ER diagram?
It determines the primary key of an entity
It defines the data type of an attribute
It specifies the name of the relationship between entities
It indicates the number of instances of one entity that can be associated with instances of another entity
What is the process of ensuring that data across related tables remains consistent and synchronized called?
Data Integrity
Data Validation
Data Warehousing
Data Normalization
How is a one-to-many relationship represented in an ER diagram?
A single line connecting two entities
A line with a crow's foot symbol on one end and a single line on the other
A diamond connecting two entities
Two lines connecting two entities
Which SQL keyword is used to establish a relationship between two entities by referencing the primary key of one table in another table?
RELATIONSHIP
PRIMARY KEY
FOREIGN KEY
JOIN
Which of the following is NOT a common SQL data type?
BOOLEAN
ARRAY
In which scenario might denormalization be considered acceptable in database design?
To improve query performance by reducing joins
To simplify the database schema
To increase data redundancy
To enforce strict data integrity
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 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.
It sets the foreign key values in the child table to NULL when a record in the parent table is deleted.