CSE MCQs :: DBMS MCQs
- Data integrity constraints are used to
- Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
- Which of the following can be addressed by enforcing a referential integrity constraint?
- ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
- Which one of the following uniquely identifies the elements in the relation?
- Drop Table cannot be used to drop a table referenced by a _________ constraint.
- ____________ is preferred method for enforcing data integrity
Whatsapp
Facebook
|
A.
All phone numbers must include the area code
|
|
B.
Certain fields are required (such as the email address, or phone number) before the record is accepted
|
|
C.
Information on the customer must be known before anything can be sold to that customer
|
|
D.
Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than 'a dozen')
|