Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
Physical Database Design
Which of the following is an advantage of partitioning?
Complexity
Inconsistent access speed
Extra space
Security
Correct Answer:
Security
← Previous Question
Next Question→
More Questions from
Physical Database Design
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.
The three newest database architectures in use today are relational, multidimensional and hierarchical.
A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Hashing algorithm converts a primary key value into a record address.
Some advantages of partitioning include: efficiency, security, and load balancing.
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Denormalization and clustering can work well to minimize data access time for small records.
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments