Machine-translated by Google. Questions are authored in English.
Top

Discussion

What SQL structure is used to limit column values of a table?

  • A.
    The LIMIT constraint
  • B.The CHECK constraint
  • C.The VALUE constraint
  • D.None of the above is correct.

Answer: B

Correct answer: The CHECK constraint

CHECK attaches a condition to a column or a table that every row must satisfy, so values outside a range, outside a list, or inconsistent with another column in the same row are rejected at the DBMS rather than by the application. Enforcing it in the database means it holds however the data arrives.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.