nerdexam
CompTIA

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.

Database Fundamentals

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)
  • A
    6% (3)
  • B
    4% (2)
  • C
    89% (48)
  • F
    2% (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.

AColumn

A Column is a fundamental structural component of a table that holds data of a specific type, not a constraint itself.

BRow

A Row represents a single record or entry in a table, not a constraint.

CNot nullCorrect

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.

DPrimary keyCorrect

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.

EField

A Field is another term for a column, referring to a specific attribute or piece of data within a record, not a constraint.

FTable

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

#database constraints#primary key#not null

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice