Database Concepts Quiz

In a database, how is a many-to-many (N:N) relationship between two entities typically resolved?

• By creating a composite entity (junction table) with foreign keys to both entities

• By combining the attributes of both entities into a single entity

• By denormalizing the database structure for better performance

• By using a one-to-many (1:N) relationship between the entities

Which database model stores data in objects with attributes and methods, similar to object-oriented programming?

• Hierarchical Database Model

• Object-Oriented Database Model

• Network Database Model

• Relational Database Model

What is the highest level of data abstraction in a database system?

• Physical level

• Logical level

• External level

• Conceptual level

How is the result set sorted in ascending order using a SELECT statement?

• ASC

• DESC

• ORDER BY

• SORT ASCENDING

When creating a foreign key relationship, which of the following statements is true?

• The foreign key must have the same name as the primary key in the referencing table.

• The foreign key and primary key must be of different data types.

• The foreign key must have a unique index applied to it.

• The foreign key can be null in the referencing table.

At which level of data abstraction is the database schema defined?

• Physical level

• Logical level

• External level

• Conceptual level

What does ACID stand for in the context of database transactions?

• Atomicity, Consistency, Isolation, Durability

• Aggregate, Commit, Isolate, Distribute

• Association, Constraint, Index, Data

• All Columns In Database

Which of the following activities is NOT part of the requirements gathering process for database design?

• Creating Entity-Relationship Diagrams (ERDs)

• Conducting interviews with key stakeholders

• Analyzing existing data and systems

• Implementing database security measures

Why is it important to accurately map entities, columns, and data types in a database?

• It simplifies the process of creating primary keys for each table.

• It ensures that data can be retrieved and stored correctly in the database.

• It eliminates the need for creating relationships between tables.

• It guarantees that the database can handle a large number of concurrent users.

When should a composite unique identifier be used in a database design?

• When there is a one-to-one (1:1) relationship between two entities

• When an entity has a many-to-many (N:N) relationship with another entity

• When there are multiple attributes that together uniquely identify an entity

• When a foreign key is used to link two entities together