Register

UGC NET CSE | December 2013 | Part 2 | Question: 11

3,068 views
0 votes
0 votes

The student marks should not be greater than 100. This is

  1. Integrity constraint
  2. Referential constraint
  3. Over-defined constraint
  4. Feasible constraint
User Avatar

1 Answer

3 votes
3 votes

Integrity constraint is meant for "integrity" of data and mark <= 100 is part of it. By English meaning D option can be right but in Database, is there something like "Feasible Constraint"?

Integrity Constraint is not meant to avoid data loss.

Ref: http://www2.amk.fi/digma.fi/www.amk.fi/opintojaksot/0303011/1146161367915/1146161783414/1146163065754/1146163167961.html

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

2 votes
2 votes
1 answer
1
go_editor asked Jul 24, 2016
3,851 views
UGC NET CSE | December 2013 | Part 2 | Question: 15
Data Integrity control uses Upper and lower limits on numeric data Passwords to prohibit unauthorized access to files Data dictionary to keep the data Data dictionary to find last access data
Data Integrity control usesUpper and lower limits on numeric dataPasswords to prohibit unauthorized access to filesData dictionary to keep the dataData dictionary to find...
User Avatar
1 votes
1 votes
1 answer
2
go_editor asked Jul 24, 2016
2,933 views
UGC NET CSE | December 2013 | Part 2 | Question: 14
Based on the cardinality ratio and participation ______ associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual Referencing Design. Entity Constraints Rules Keys
Based on the cardinality ratio and participation ______ associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual ...
User Avatar
3 votes
3 votes
1 answer
3
go_editor asked Jul 24, 2016
2,611 views
UGC NET CSE | December 2013 | Part 2 | Question: 13
An E-R model includes An ER diagram portraying entity types. Attributes for each entity type. Relationships among entity types. Semantic integrity constrains that reflects the business rules about data not captured in the ER diagram I, II, III and IV I and IV I, II and IV I and III
An E-R model includesAn ER diagram portraying entity types.Attributes for each entity type.Relationships among entity types.Semantic integrity constrains that reflects th...
User Avatar
3 votes
3 votes
2 answers
4
go_editor asked Jul 24, 2016
2,809 views
UGC NET CSE | December 2013 | Part 2 | Question: 12
GO BOTTOM and SKIP-3 commands are given one after another in a database file of 30 records. It shifts the control to 28-th record 27-th record 3-rd record 4-th record
GO BOTTOM and SKIP-3 commands are given one after another in a database file of 30 records. It shifts the control to28-th record27-th record3-rd record4-th record
User Avatar
Link Copied!