FC0-U61 · Question #519
Which of the following are database constraints? (Choose two.)
The correct answer is C. Not null D. Primary key. This question asks to identify two common types of database constraints used to enforce data integrity and rules within a database.
Question
Which of the following are database constraints? (Choose two.)
Options
- AColumn
- BRow
- CNot null
- DPrimary key
- EField
- FTable
How the community answered
(54 responses)- A6% (3)
- B4% (2)
- C89% (48)
- F2% (1)
Why each option
This question asks to identify two common types of database constraints used to enforce data integrity and rules within a database.
A Column is a fundamental structural component of a table that holds data of a specific type, not a constraint itself.
A Row represents a single record or entry in a table, not a constraint.
A 'Not null' constraint ensures that a column cannot have a NULL value, meaning every row must have a value for that specific column. This enforces data completeness.
A 'Primary key' constraint uniquely identifies each record in a table and ensures that the column (or set of columns) designated as the primary key contains unique values and no NULL values. This is crucial for data integrity and relationships between tables.
A Field is another term for a column, referring to a specific attribute or piece of data within a record, not a constraint.
A Table is a collection of related data organized in rows and columns, serving as a storage unit, not a constraint.
Concept tested: Database integrity constraints
Source: https://learn.microsoft.com/sql/relational-databases/tables/unique-and-check-constraints-for-sql-server?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.