Physical Database Design Questions and Answers

Practice Mode
Showing 10 of 18 questions
Q11
 A secondary key is which of the following?
  • A Nonunique key
  • B Primary key
  • C Useful for denormalization decisions
  • D Determines the tablespace required
Answer: Option A
Q12
The fastest read/write time and most efficient data storage of any disk array type is:
  • A RAID-0.
  • B RAID-1.
  • C RAID-2.
  • D RAID-3.
Answer: Option A
Q13
A rule of thumb for choosing indexes for a relational database includes which of the following?
  • A Indexes are more useful on smaller tables.
  • B Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
  • C Do not specify a unique index for the primary key of each table.
  • D Be careful indexing attributes that have null values.
Answer: Option D
Q14
Sequential retrieval on a primary key for sequential file storage has which of the following features?
  • A Very fast
  • B Moderately fast
  • C Slow
  • D Impractical
Answer: Option A
Q15
A multidimensional database model is used most often in which of the following models?
  • A Data warehouse
  • B Relational
  • C Hierarchical
  • D Network
Answer: Option A
Q16
What type of join is needed when you wish to include rows that do not have matching values?
  • A Equi-join
  • B Natural join
  • C Outer join
  • D All of the above.
Answer: Option C
Q17
What type of join is needed when you wish to return rows that do have matching values?
  • A Equi-join
  • B Natural join
  • C Outer join
  • D All of the above.
Answer: Option D
Q18
Which of the following is true concerning a procedure?
  • A You do not create them with SQL.
  • B They do not need to have a unique name.
  • C They include procedural and SQL statements.
  • D They are the same thing as a function.
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test