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. False True TRUE ANSWER : ? YOUR ANSWER : ?
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true? All fields are stored in one relation. All fields are stored in two relations. All fields are stored in four relations. All fields are stored in three relations. TRUE ANSWER : ? YOUR ANSWER : ?
Sequential retrieval on a primary key for sequential file storage has which of the following features? Impractical Slow Moderately fast Very fast TRUE ANSWER : ? YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? LONG VARCHAR2 NUMBER CHAR TRUE ANSWER : ? YOUR ANSWER : ?
The blocking factor is: attributes grouped together by the same primary key. attributes grouped together by the same secondary key. the number of physical records per page. a group of fields stored in adjacent memory. TRUE ANSWER : ? YOUR ANSWER : ?
A multidimensional database model is used most often in which of the following models? Relational Network Data warehouse Hierarchical TRUE ANSWER : ? YOUR ANSWER : ?
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process. False True TRUE ANSWER : ? YOUR ANSWER : ?
Selecting a data type involves which of the following? Represent most values Improve data integrity All of these Maximize storage space TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not a factor to consider when switching from small to large block size? The length of all of the fields in a table row Block contention Random row access speed The number of columns TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following are integrity controls that a DBMS may support? Limit the set of permissible values that a field may assume. All of these Assume a default value in a field unless a user enters a value for that field. Limit the use of null values in some fields. TRUE ANSWER : ? YOUR ANSWER : ?