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

Q. A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

View solution

Q. A number of related records that are treated as a unit is called

View solution

Q. If you want to group the records in the abc database, you could use the Jobcode as the _____.

View solution

Q. Which of the following is not characteristic of a relational database model?

View solution

Q. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

View solution

Q. A compound key

View solution

Q. If a piece of data is stored in two places in the database, then

View solution