One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

Related MCQs

• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• The disk controller uses                  at each sector to ensure that the data is not corrupted on data retrieval.
• A                    integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• Each of a pair of transactions has read data that is written by the other, but there is no data written by both transactions, is referred to as
• ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
• Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
•                      are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.
• Which of the following can be used to supplement declarative referential integrity, to enforce complex business rules or to audit changes to data?