IT12 (Finals) - Quiz 1

Which of the following is a key reason why databases are essential for modern web applications?

• A. They exclusively handle front-end UI interactions.

• B. They serve as persistent storage for application data.

• C. They compile server-side code into executables.

• D. They are only used for static content delivery.

What is the primary goal of database normalization?

• A. To increase data redundancy for faster retrieval.

• B. To organize columns and tables to reduce data redundancy and improve integrity.

• C. To simplify complex queries by merging all tables into one.

• D. To convert relational databases into NoSQL databases.

A table is in First Normal Form (1NF) if, among other things, each table cell contains what kind of value?

• A. A list of values.

• B. An array of related data.

• C. A single, atomic value.

• D. A composite key value.

What additional condition must be met for a table in 1NF to be in Second Normal Form (2NF)?

• A. All non-key attributes must be dependent on a non-key attribute.

• B. It must contain only auto-incrementing primary keys.

• C. No non-key attribute is dependent on only a part of the composite primary key.

• D. All attributes must be stored in separate tables.

Third Normal Form (3NF) requires a table to be in 2NF and eliminate what type of dependency?

• A. Functional dependencies.

• B. Transitive dependencies.

• C. Partial dependencies.

• D. Multi-valued dependencies.

Which characteristic is mandatory for a Primary Key?

• A. It can contain NULL values if the record is incomplete.

• B. It must be an auto-incrementing integer.

• C. It must contain unique values for each row.

• D. It is used to link to multiple other tables exclusively.

What is the primary role of a Foreign Key in a database schema?

• A. To define a secondary index for faster searches.

• B. To enforce referential integrity and establish relationships between tables.

• C. To uniquely identify each record within its own table.

• D. To store large binary objects (BLOBs).

In a One-to-Many (1:M) relationship, how do records in Table A typically relate to records in Table B?

• A. One record in Table A relates to exactly one record in Table B.

• B. Many records in Table A relate to many records in Table B.

• C. One record in Table A can relate to many records in Table B, but one record in Table B relates to only one record in Table A.

• D. One record in Table B can relate to many records in Table A, but one record in Table A relates to only one record in Table B.

What is generally required to resolve a Many-to-Many (M:N) relationship in a relational database?

• A. A direct link using a foreign key in one of the tables.

• B. An intermediary 'junction' or 'associative' table.

• C. Converting one of the entities into an attribute.

• D. Denormalizing the database entirely.

What is an Entity-Relationship Diagram (ERD) primarily used for?

• A. Executing database queries.

• B. Visualizing database performance metrics.

• C. Providing a visual representation of entities within a database and their relationships.

• D. Automating database migrations.