Q. The relational model consists of:

View solution

Q. A primary key is which of the following?

View solution

Q. A foreign key is which of the following?

View solution

Q. Relations are:

View solution

Q. A relation has which of the following properties?

View solution

Q. The entity integrity rule states that:

View solution

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