Database - Physical Database Design

Database - Physical Database Design
1. If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
  • All fields are stored in one relation.
  • All fields are stored in two relations.
  • All fields are stored in three relations.
  • All fields are stored in four relations.
Show Answer
2. Selecting a data type involves which of the following?
  • Maximize storage space
  • Represent most values
  • Improve data integrity
  • All of the above.
Show Answer
3. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
  • VARCHAR2
  • CHAR
  • LONG
  • NUMBER
Show Answer
4. If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
  • All fields are stored in one relation.
  • All fields are stored in two relations.
  • All fields are stored in three relations.
  • All fields are stored in four relations.
Show Answer
5. Which of the following is an advantage of partitioning?
  • Complexity
  • Inconsistent access speed
  • Extra space
  • Security
Show Answer
6. The blocking factor is:
  • a group of fields stored in adjacent memory.
  • the number of physical records per page.
  • attributes grouped together by the same primary key.
  • attributes grouped together by the same secondary key.
Show Answer
7. Which of the following improves a query's processing time?
  • Write complex queries.
  • Combine a table with itself.
  • Query one query within another.
  • Use compatible data types.
Show Answer
8.  Which of the following are integrity controls that a DBMS may support?
  • Assume a default value in a field unless a user enters a value for that field.
  • Limit the set of permissible values that a field may assume.
  • Limit the use of null values in some fields.
  • All of the above.
Show Answer
9. Which of the following is not a factor to consider when switching from small to large block
size?
  • The length of all of the fields in a table row.
  • The number of columns
  • Block contention
  • Random row access speed
Show Answer
10. What is the best data type definition for Oracle when a field is alphanumeric and has a fixed
length?
  • VARCHAR2
  • CHAR
  • LONG
  • NUMBER
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test