81. | In the data model schemas, the constraints that are can not be expressed directly are classified as |
a. | application based constraints |
b. | semantic constraints |
c. | business rules |
d. | all of above |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (d).all of above
|
82. | The cardinality in relational data model is considered as |
a. | total number of values |
b. | limited number of values |
c. | two numbers from set |
d. | three numbers from set |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (a).total number of values
|
83. | The constraint violated when the given value of attribute is not included in the corresponding domain is |
a. | domain constraint |
b. | attribute constraint |
c. | key constraint |
d. | lock constraint |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (a).domain constraint
|
84. | If two or more constraints are violated by using insert operation then by default the |
a. | insert is accepted |
b. | insert is rejected |
c. | insertion permanently blocked |
d. | none of above |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (b).insert is rejected
|
85. | In the data model, the inherent constraints are classified as |
a. | flat constraints |
b. | parallel constraints |
c. | explicit constraints |
d. | implicit constraints |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (d).implicit constraints
|
86. | The multi-valued dependencies and functional dependencies are classified as category of |
a. | relation dependencies |
b. | data dependencies |
c. | entity dependencies |
d. | attribute dependencies |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (b).data dependencies
|
87. | The model in which the multi-valued and composite attributes is considered as |
a. | reverse relational model |
b. | flat relational model |
c. | parallel relational model |
d. | circular relational model |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (b).flat relational model
|
88. | The type of constraint in which value of each attribute (X) must be an indivisible value from domain (X) is classified as |
a. | explicit constraint |
b. | implicit constraint |
c. | domain constraint |
d. | range constraint |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (c).domain constraint
|
89. | The constraints which deals with the changes in the database are classified as |
a. | assertion constraints |
b. | trigger constraints |
c. | specified constraints |
d. | transition constraints |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (d).transition constraints
|
90. | The multivalued dependencies used to develop relational design theory of database is classified as |
a. | amortization |
b. | normalization |
c. | conceptualization |
d. | depreciation |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (b).normalization
|