week 4 -practice quiz Flashcards
How is a horizontal fragmentation of a database table created?
1) Place table attributes in to multiple smaller tables.
2) Place table records in to multiple smaller tables.
3) Place the same table in to multiple databases that are connected horizontally.
4) Place table fields in to multiple smaller tables.
2) Place table records in to multiple smaller tables.
Which table key should be copied to each of the subtables created in a vertical fragmentation?
1) Vertical key
2) Primary key
3) Foreign key
4) Alternating key
2) Primary key
Which of the following is made less efficient when data is replicated across multiple sites?
1) Updating Data
2) Data Redundancy
3) Query Evaluation
4) Information Retrieval
1) Updating Data
The shared memory parallel database architecture is typically seen in which type of network structure?
1) Multiple servers
2) Centralized
3) Multiple clients
4) Distributed
Centralized
Which of the following parallel database architectures is easy to build and scale up?
1) Shared nothing
2) Shared CPU
3) Shared memory
4) Shared disk
1) Shared nothing
In which type of database parallelism do all machines work together to compute a given operation at the same time?
1) Inter-operator parallelism
2) Inter-database parallelism
3) Intra-operator parallelism
4) Inter-query parallelism
3) Intra-operator parallelism
Intra-query parallelism is a form of parallelism in the evaluation of database queries, in which a single query is decomposed into smaller tasks that execute concurrently on multiple processors.
In parallel sorting that uses range partition, which attribute is the range partition based on?
1) Sort attribute
2) Sample attribute
3) Randomize attribute
4) Order attribute
1) Sort attribute
What is the high-level query processing language used by database management systems?
1) SQL
2) XML
3) PL
4) HTML
1) SQL
What is the correct order of tasks in a typical distributed query processing?
1) Localization, Decomposition, Optimization
2) Decomposition, Localization, Optimization
3) Decomposition, Optimization, Localization
4) Optimization, Decomposition, Localization
2) Decomposition, Localization, Optimization
In database terminology, what does the separation of higher level semantics of a database system from the lower level implementation issues refer to?
1) Transparency
2) Fragmentation
3) Parallelism
4) Isolation
1) Transparency
In database terminology, what does the ability of a database system to expand and serve more users refer to?
1) Vertical fragmentation
2) Horizontal fragmentation
3) Integration
4) Scalability
4) Scalability
What kind of data fragmentation is created by placing table rows into multiple smaller tables?
1) Horizontal fragmentation
2) Parallel fragmentation
3) Vertical fragmentation
4) Distributed fragmentation
1) Horizontal fragmentation
What kind of data fragmentation is created by placing table columns into multiple smaller tables?
1) Columnar fragmentation
2) Vertical fragmentation
3) Disjoint fragmentation
4) Horizontal fragmentation
2) Vertical fragmentation
What is the name of the database fragmentation property where each data item in the original database appears in one and only one fragment?
1) Disjointness
2) Uniqueness
3) Isolation
4) Separation
1) Disjointness
For which of the following scenarios would database replication be preferred?
1) Number of update queries = 1000, Number of read-only queries = 10.
2) Number of update queries = 10000, Number of read-only queries = 10000.
3) Number of update queries = 10, Number of read-only queries = 10.
4) Number of update queries = 10, Number of read-only queries = 1000.
4) Number of update queries = 10, Number of read-only queries = 1000.
