CSE MCQs :: DBMS MCQs
- To include integrity constraint in a existing relation use :
- Which of the following is not a integrity constraint ?
- Foreign key is the one in which the ________ of one relation is referenced in another relation.
- Domain constraints, functional dependency and referential integrity are special forms of _________.
- Which of the following is the right syntax for assertion?
- Data integrity constraints are used to:
- Which of the following can be addressed by enforcing a referential integrity constraint?
- _____________, express the number of entities to which another entity can be associated via a relationship set.
- An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as
- An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.
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 custome
|
D.
When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than 'a dozen')
|
A.
Mapping Cardinality
|