Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

The storage level is close to:
A)Hardware and operating system
B)User interface
C)Application programs
D)All of the above
2

When a logical record requested by an application is already in memory, which of the following is not true?
A)A transfer from storage into memory will take place anyway
B)There will be no need to transfer again from storage into memory
C)Avoiding transfer from storage into memory increases performance
D)Avoiding transfer from storage into memory may make physical design more complex
3

In a DBMS environment, which of the following is a usually critical factor in disk access time?
A)Mounting the disk
B)Changing sides on disk
C)Magnetic head movement
D)Starting to rotate the disk
4

Which of the following is not typically used in establishing application profiles?
A)Number of "insert" performed by the subform of a form
B)Number of "drop" performed by the subform of a form
C)Number of "delete" performed by a form
D)Number of "update" performed by a form
5

Assume each node of the B-tree is full. The number of disk accesses to retrieve a record will approximately be:
A)50,000,000
B)5
C)100
D)1000
6

Assume each node of the B-tree is half-full (m = number of keys per node = 50). The number of disk access to retrieve a record will approximately be:
A)one more than for m = 99
B)twice the value for m = 99
C)50 times the value for m = 99
D)100 times the value for m = 100
7

Which of the following will usually not result in a faster execution of an SQL query?
A)Perform projections after expensive joins
B)Combine restrictions operation to perform them together
C)Perform restrictions before expensive join
D)Replace cross products by joins whenever possible
8

Which of the following does not improve execution of SQL queries?
A)If there is a condition on a join column, make the condition on the table on the "one" side of 1-M relationship
B)Move simple comparisons from the "WHERE" clause to the "HAVING" clause
C)Avoid Type II queries
D)Avoid aggregation computations in nested queries
9

Which of the following is not a good candidate for a clustering index?
A)A primary key
B)A column with unique values used in equality conditions
C)A foreign key for which a join with the related table yields most rows and the primary key of the related table is a clustering index
D)A column used in very nonselective conditions
10

Which of the following statements is incorrect about RAID technology?
A)RAID-5 is preferred to RAID-1 when the database requires frequent data modifications
B)RAID-1 requires more storage than RAID-5
C)RAID-1 requires less write time than RAID-5
D)RAID-5 does not duplicate the data themselves





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 8 > Multiple Choice Quiz