Computer Science
…………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
- Column
- Constraint
- Index
- Trigger
DDL & DML
1 Like
Answer
Constraint
Reason — Constraint defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. Once an integrity constraint is enabled, all data in the table must confirm to the rule that it specifies.
Answered By
2 Likes
Related Questions
In SQL, which command(s) is(are) used to change a table's structure / characteristics ?
- ALTER TABLE
- MODIFY TABLE
- CHANGE TABLE
- All of these
Which of the following commands will delete the table from MYSQL database ?
- DELETE TABLE
- DROP TABLE
- REMOVE TABLE
- ALTER TABLE
Fill in the blank :
…………… command is used to remove primary key from a table in SQL.
- update
- remove
- alter
- drop
Which command defines its columns, integrity constraint in create table :
- Create table command
- Drop table command
- Alter table command
- All of these