a) Constraints b) Stored Procedure c) Triggers d) Cursors
View QuestionDrop Table cannot be used to drop a table referenced by a _________ constraint.
a) Local Key b) Primary Key c) Composite Key d) Foreign Key
View QuestionWhich one of the following uniquely identifies the elements in the relation?
a) Secondary Key b) Primary key c) Foreign key d) Composite key Answer: b Explanation: Primary key ...
View Question______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
a) Entity Integrity Constraints b) Referential Integrity Constraints c) Domain Integrity Constraints d) Domain Constraints
View QuestionWhich of the following can be addressed by enforcing a referential integrity constraint?
a) All phone numbers must include the area code b) Certain fields are required (such as the ...
View QuestionEstablishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
a) Attributes b) Data integrity constraints c) Method constraints d) Referential integrity constraints Answer: b Explanation: Only particular ...
View QuestionData integrity constraints are used to:
a) Control who is allowed access to the data b) Ensure that duplicate records ...
View QuestionAn 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) One-to-many b) One-to-one c) Many-to-many d) Many-to-one Answer: d Explanation: Here more than one entity in one set ...
View QuestionAn 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
a) One-to-many b) One-to-one c) Many-to-many d) Many-to-one Answer: b Explanation: Here one entity in one set ...
View Question_____________ express the number of entities to which another entity can be associated via a relationship set.
a) Mapping Cardinality b) Relational Cardinality c) Participation Constraints d) None of the mentioned Answer: a Explanation: ...
View Question