A field represents each component of a composite attribute. True False TRUE ANSWER : ? YOUR ANSWER : ?
Selecting a data type involves which of the following? Maximize storage space Improve data integrity Represent most values All of these TRUE ANSWER : ? YOUR ANSWER : ?
Distributing the columns of a table into several separate physical records is known as horizontal partitioning. False True TRUE ANSWER : ? YOUR ANSWER : ?
Some advantages of partitioning include: efficiency, security, and load balancing. True False TRUE ANSWER : ? YOUR ANSWER : ?
The blocking factor is: attributes grouped together by the same primary key. the number of physical records per page. attributes grouped together by the same secondary key. a group of fields stored in adjacent memory. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following improves a query's processing time? Write complex queries. Use compatible data types. Query one query within another. Combine a table with itself. TRUE ANSWER : ? YOUR ANSWER : ?
A multidimensional database model is used most often in which of the following models? Data warehouse Hierarchical Relational Network TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following are integrity controls that a DBMS may support? All of these Limit the set of permissible values that a field may assume. Limit the use of null values in some fields. Assume a default value in a field unless a user enters a value for that field. TRUE ANSWER : ? YOUR ANSWER : ?
A pointer is a detailed coding scheme recognized by system software for representing organizational data. False True TRUE ANSWER : ? YOUR ANSWER : ?
The three newest database architectures in use today are relational, multidimensional and hierarchical. True False TRUE ANSWER : ? YOUR ANSWER : ?