The three newest database architectures in use today are relational, multidimensional and hierarchical.
Answer: B
Correct answer: False
The hierarchical model is the oldest of the architectures, dating from the 1960s. The three newest in general use are relational, object-oriented and multidimensional. Including hierarchical among the newest inverts the chronology of the whole subject.
Please log in or register to report this question.
A multidimensional database model is used most often in which of the following models?
Answer: A
Correct answer: Data warehouse
The multidimensional model organises data as measures indexed by dimensions - sales by product by region by month - which is exactly how analytical questions are asked. It suits the warehouse for that reason, and suits transaction processing badly, since it is designed to be read rather than updated.
Please log in or register to report this question.
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
Answer: B
Correct answer: False
Response time as the user experiences it is very nearly the point of physical design. The logical design is already correct; what physical design adds is the indexing, organisation and placement that decide whether the system is usable, and user interaction time is the measure that matters most.
Please log in or register to report this question.
Which of the following improves a query's processing time?
Answer: D
Correct answer: Use compatible data types.
Comparing columns of different types forces the database to convert one of them, and a converted column generally cannot use its index - so a query that should have been an index lookup becomes a full scan. The other three options all add work: complexity, self-joins and subqueries each give the optimiser more to do rather than less.
Please log in or register to report this question.
A bitmap index is an index on columns from two or more tables that come from the same domain of values
Answer: B
Correct answer: False
An index on columns from two or more tables drawn from the same domain is a join index, which exists to avoid computing the join at query time. A bitmap index is something else: one bit vector per distinct value, which is compact and fast where a column has few distinct values.
Please log in or register to report this question.
Which of the following is an advantage of partitioning?
Answer: D
Correct answer: Security
Partitioning lets the sensitive rows or columns be placed in their own partition with its own access controls, so a user reaching one part of a table need not be given the whole of it. The other three options are the recognised disadvantages - more complexity, uneven access speed, and extra space for the partitioning structures.
Please log in or register to report this question.
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.
Answer: B
Correct answer: False
The sizes are the other way round. Transaction processing touches few rows at a time and benefits from small blocks, which reduce contention and wasted transfer. Warehousing scans large ranges, so large blocks bring more useful data per read. The statement has the two applications exchanged.
Please log in or register to report this question.
Selecting a data type involves which of the following?
Answer: C
Correct answer: Improve data integrity
Choosing a type that admits only the values the attribute can legitimately take is itself a constraint: a date column will not accept a non-date, and a numeric one will not accept text. The other options are the reverse of what is wanted - storage should be minimised, and a type admitting the widest range of values weakens the check.
Please log in or register to report this question.
The primary goal of physical database design is data processing efficiency.
Answer: A
Correct answer: True
Physical design begins from a logical design that is already correct, so what remains to be decided is how to make it perform: indexes, file organisation, clustering, partitioning and controlled denormalisation. Correctness is settled by then; efficiency is what physical design trades against.
Please log in or register to report this question.
An extent is a contiguous section of disk storage space.
Answer: A
Correct answer: True
An extent is a contiguous run of disk space allocated to a segment in one go. Allocating in extents rather than block by block keeps related data physically together, which matters for sequential reading, and reduces the bookkeeping the storage manager must do.
Please log in or register to report this question.
