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.
What is the key difference between a database and a schema?
There is no difference; the terms are interchangeable.
A database is a collection of tables, while a schema defines the structure of a single table.
A database stores the actual data, while a schema defines the rules for accessing that data.
A database is a broader concept encompassing one or more schemas, each defining a logical structure within the database.
In a normalized database, what is the typical relationship between tables?
Tables are organized alphabetically
Tables are connected through foreign keys
One table contains all the data, while others are empty
Tables are completely independent
Referential integrity ensures that...
queries are optimized for performance.
relationships between tables remain consistent.
all columns in a table have unique values.
data is backed up regularly.
Which of the following is a key benefit of using a well-designed schema for a data warehouse?
Simplified data loading from various sources
Increased data redundancy for backups
Improved query performance and efficiency
Reduced need for data modeling and analysis
Which statement is TRUE regarding the different normal forms?
Normalization guarantees perfect database design
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
Which of the following is NOT a valid SQL data type for storing numerical values?
VARCHAR
INTEGER
DECIMAL
FLOAT
What issue does Third Normal Form (3NF) primarily address?
Transitive dependencies between non-key attributes
Partial dependencies on the primary key
Repeating groups of data
Lack of a primary key
What is the primary goal of database normalization?
Improving query performance
Minimizing storage space
Enhancing data security
Reducing data redundancy and anomalies
Which of the following is NOT a valid action for cascading actions in SQL?
ON SELECT CASCADE
ON DELETE CASCADE
ON INSERT CASCADE
ON UPDATE CASCADE