91. | In the data model schemas, the constraints that are expressed directly are classified as |
a. | explicit constraints |
b. | implicit constraints |
c. | flat constraints |
d. | parallel constraints |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (a).explicit constraints
|
92. | In relational database schemas, the transition constraints are also known as |
a. | static constraints |
b. | dynamic constraints |
c. | implicit constraints |
d. | explicit constraints |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (b).dynamic constraints
|
93. | A row of table in relational model terminology is classified as |
a. | range |
b. | domain |
c. | relation |
d. | tuple |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (d).tuple
|
94. | The constraint which is used to specify the consistency in two or more relations among tuples is classified as |
a. | primary integrity constraint |
b. | entity integrity constraint |
c. | referential integrity constraint |
d. | null integrity constraint |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (b).entity integrity constraint
|
95. | The ordered list of all the n-values is classified as |
a. | n-tuple |
b. | l-tuple |
c. | v-tuple |
d. | all of above |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (d).all of above
|
96. | The state in which the database follows all the integrity constraints is classified as |
a. | valid state |
b. | candidate state |
c. | parallel state |
d. | invalid state |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (a).valid state
|
97. | The column header of table in relational model terminology is classified as |
a. | attribute |
b. | table starter |
c. | table ender |
d. | entity domain |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (a).attribute
|
98. | The operation which violates only one constraint called referential integrity when it is performed is called |
a. | New operation |
b. | Modify operation |
c. | Delete operation |
d. | Insert operation |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (c).Delete operation
|
99. | The distribution in which each row denote some related values collection is classified as |
a. | record |
b. | entity |
c. | concept |
d. | table |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (d).table
|
100. | When the foreign key refers to a tuple which does not exists in subjected relation then the constraint violated is |
a. | modify integrity |
b. | referential integrity |
c. | inferential integrity |
d. | insert integrity |
View Answer Report Discuss Too Difficult! Search Google |
Answer: (b).referential integrity
|