Which of the following is NOT a common SQL data type?
BOOLEAN
ARRAY
INTEGER
VARCHAR
What is the PRIMARY purpose of using indexes in a database?
To enforce data integrity constraints
To reduce disk space consumption
To improve data security
To speed up data retrieval operations
Which SQL keyword is used to establish a relationship between two entities by referencing the primary key of one table in another table?
JOIN
FOREIGN KEY
RELATIONSHIP
PRIMARY KEY
Which of the following is NOT a typical example of a dimension in a data warehouse schema?
Time
Product
Customer
Sales Amount
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Multi-valued dependency
Join dependency
Transitive dependency
Partial dependency
What is the primary goal of database normalization?
Reducing data redundancy and anomalies
Minimizing storage space
Improving query performance
Enhancing data security
What is the process of ensuring that data across related tables remains consistent and synchronized called?
Data Validation
Data Normalization
Data Warehousing
Data Integrity
Why is defining a clear and well-structured schema important in database design?
It simplifies data management, improves data integrity, and enhances query efficiency.
It makes the database look visually appealing.
It eliminates the need for using SQL queries.
It automates the process of data entry.
What does the 'ON DELETE CASCADE' constraint do?
It prevents deletion of records in the parent table if there are matching records in the child table.
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.
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)
Third Normal Form (3NF)
Second Normal Form (2NF)
None of the above