ExamVeda
Login
Home

Physical Database Design - Database MCQ Questions and answers- Technical Aptitude

Physical Database Design(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-2 section-1

11
A secondary key is which of the following?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
12
The fastest read/write time and most efficient data storage of any disk array type is:
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
13
A rule of thumb for choosing indexes for a relational database includes which of the following?
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
14
Sequential retrieval on a primary key for sequential file storage has which of the following features?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
15
A multidimensional database model is used most often in which of the following models?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
16
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
17
Denormalization and clustering can work well to minimize data access time for small records.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
18
Hashing algorithm converts a primary key value into a record address.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
19
The primary goal of physical database design is data processing efficiency.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
20
A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board