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-3 section-1

21
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
22
A field represents each component of a composite attribute.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
23
Some advantages of partitioning include: efficiency, security, and load balancing.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
24
A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
25
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
26
An extent is a contiguous section of disk storage space.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
27
The three newest database architectures in use today are relational, multidimensional and hierarchical.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
28
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
29
In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
30
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board