Which of the following is a characteristic of a Dimension table in a Star Schema?
Focuses on storing calculated metrics
Provides descriptive attributes about business entities
Typically has a small number of rows
Contains highly transactional data
Which of these is crucial to consider when choosing data types for columns?
The kind of data the column will store and its expected size.
The type of storage device used by the database server.
The username of the person creating the table.
The color scheme of the user interface.
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 automatically deletes matching records in the child table 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.
In a Star Schema, what is the central table called that contains the key performance indicators (KPIs)?
Lookup Table
Dimension Table
Fact Table
Entity Table
When designing a schema for a library, what is the most appropriate primary key for the 'Books' table?
Author Name
Book Title
ISBN
Publication Year
What is the main advantage of achieving higher normal forms in database design?
Slower query processing
Improved data integrity and reduced anomalies
More complex database structure
Increased data redundancy
Which statement is TRUE regarding the different normal forms?
1NF is the most desirable normal form for all databases
A table in 3NF is also automatically in 2NF and 1NF
2NF automatically implies 3NF
Normalization guarantees perfect database design
What is the role of a column in a database table?
To represent a specific attribute or characteristic of an entity.
To store the entire dataset of the table.
To define a row in the table.
To link the table to another table.
What is the primary purpose of a Primary Key in a database table?
To uniquely identify each row within the table.
To ensure that all columns in the table have a value.
To define the order in which data is stored.
To establish a relationship with another table.
To change the data type of a column in an existing table, which clause should be used with the ALTER TABLE statement?
TRANSFORM COLUMN
MODIFY COLUMN
CHANGE COLUMN
UPDATE COLUMN