Microsoft SQL Server Database Quiz Questions

A business key is often used to identify a record in a way that is meaningful to the business, whereas a primary key is a unique identifier used by the database system.

Natural keys are derived from real-world data rather than being generated by the system. Examples include Social Security numbers or email addresses.

A candidate key must be unique and minimal, meaning it should have no unnecessary attributes.

A surrogate key is a unique identifier that is not derived from application data, but a candidate key is derived from application data.

Surrogate keys are often preferred for performance reasons because they are typically shorter and simpler than natural keys.

Business keys are used to uniquely identify records in a way that is meaningful to the business, not just for internal database operations.

Candidate keys are potential primary keys, but only one candidate key is selected to be the primary key of the table.

Surrogate keys are often used instead of natural keys to avoid issues with changes in business data and to improve performance.

A primary key can indeed be a composite key, meaning it can consist of multiple columns that together uniquely identify a record.

A candidate key must be both unique and minimal, meaning it should have no unnecessary attributes.

A surrogate key is not a modified natural key; it is a new, unique identifier created specifically for the database, usually without business meaning.

Business keys are typically used in business contexts and may change, which can complicate their use as primary keys.

The primary key can be either a surrogate key or a natural key depending on the design and requirements of the database.

Natural keys can be problematic if the data they represent changes frequently. Surrogate keys can be more stable in such cases.

A business key is not always chosen as the primary key. Sometimes surrogate keys are preferred for their stability and simplicity.

The primary key is used to ensure that each record in a table is unique.

A natural key is derived from real-world data, whereas a surrogate key is an artificial key created for database purposes.

A surrogate key is used as an alternative to a natural key to avoid issues with changes in business data.

A candidate key must be unique and minimal, so it cannot be non-unique or composite without being minimal.

Using a business key as a primary key can lead to issues if the business data changes frequently or if the key is not stable.

The primary key is a unique identifier for each record in a table, ensuring that no two records have the same key value.

A primary key is used to uniquely identify records in a table.

Surrogate keys are used to avoid issues with natural key changes and improve performance.

Foreign keys are used to link records between different tables.

A surrogate key is designed to be stable and not subject to changes, unlike natural keys which may change.

A candidate key can be used to enforce uniqueness alongside a business key.

Both primary keys and foreign keys can be used to ensure data integrity in relational databases.

Surrogate keys are preferable when natural keys are prone to changes or are not stable over time.

Candidate keys must be unique and minimal, and may include composite keys.

Foreign keys are primarily involved in enforcing referential integrity, but primary keys are also crucial.

Primary keys and unique constraints can enforce uniqueness in a table, but primary keys are a type of candidate key.

Surrogate keys are used to maintain simplicity and stability in database design, especially when natural keys are complex or unstable.

Primary keys and unique constraints are typically considered to ensure data uniqueness in a database schema.

Natural keys are less ideal when they are prone to changes or are complex, making surrogate keys preferable in such situations.

If a business key is unsuitable, surrogate keys and candidate keys are considered as alternatives for primary key usage.

Primary keys and unique constraints are used to enforce uniqueness in relational database tables.

Foreign keys are used to establish relationships between tables, while primary keys ensure uniqueness within a table.

Primary keys are used to uniquely identify records within a table.

Primary keys and unique constraints ensure that no duplicate data exists in a table.

Surrogate keys are beneficial when natural keys are complex, unstable, or when a simplified key structure is preferred.

Primary keys and foreign keys are used to enforce data uniqueness and maintain referential integrity.

Primary keys and foreign keys are critical for ensuring data consistency and accuracy in database design.

Surrogate keys are used to simplify key management and avoid issues related to changes in natural keys.

Primary keys and unique constraints uniquely identify records and enforce data integrity.

Surrogate keys offer simplicity and stability, avoiding issues with natural key changes and reducing complexity.