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

Q. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

View solution

Q. When the primary key is null of the new tuple then the constraint violated is

View solution