Question
a.
no primary key attribute may be null.
b.
no primary key can be composite.
c.
no primary key may be unique.
d.
no primary key may be equal to a value in a foreign key.
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The entity integrity rule states that:
Similar Questions
Discover Related MCQs
Q. When mapping a multivalued attribute into a relation which of the following is true?
View solution
Q. When mapping a regular entity into a relation which of the following is true?
View solution
Q. When mapping a binary many-to-many relationship into a relation which of the following is true?
View solution
Q. When mapping a many-to-many unary relationship into a relation which of the following is true?
View solution
Q. When mapping a ternary relationship with an associative entity into a relation which of the following is true?
View solution
Q. When mapping a supertype/subtype relationship which of the following is true?
View solution
Q. If no multivalued attributes exist in a relation, then the relation is in what normal form?
View solution
Q. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
View solution
Q. A transitive dependency is which of the following?
View solution
Q. What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
View solution
Q. If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
View solution
Q. Which of the following is an advantage of partitioning?
View solution
Q. Sequential retrieval on a primary key for sequential file storage has which of the following features?
View solution
Q. A rule of thumb for choosing indexes for a relational database includes which of the following?
View solution
Q. Which of the following are integrity controls that a DBMS may support?
View solution
Q. A secondary key is which of the following?
View solution
Q. The fastest read/write time and most efficient data storage of any disk array type is:
View solution
Q. Which of the following improves a query's processing time?
View solution
Q. The blocking factor is:
View solution
Q. Which of the following is not a relational database?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!