NEW
Font size
WorksheetsIT12 (Finals) - Quiz 1
Total questions: 15
Worksheet time: 5mins
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.
In an ERD, how are real-world objects or concepts (entities) typically represented?
A. As diamonds labeled with verb phrases.
B. As ovals connected to other shapes.
C. As rectangles, labeled with the entity name.
D. As lines connecting different attributes.
How are attributes, which represent properties or characteristics of an entity, typically shown in an ERD?
A. As rectangles within other rectangles.
B. As diamonds, often underlined.
C. As ovals connected to their respective entity, with key attributes often underlined.
D. As dashed lines extending from entities.
What do relationships in an ERD signify?
A. The physical storage location of data.
B. The data types of various attributes.
C. Associations between two or more entities, indicating how they interact or are connected.
D. The access permissions for different users.
What does 'Cardinality' specify in the context of ERDs?
A. The data type of an attribute.
B. The number of instances of one entity that can be associated with instances of another entity.
C. Whether a relationship is optional or mandatory.
D. The order in which entities are processed.
In ERDs, what concept indicates whether a relationship between entities is optional or mandatory?
A. Cardinality.
B. Modality.
C. Normal Form.
D. Association.
