Database Managment

1) A view is an alias of an actual table; all the columns and rows are visible through either the table or the view. a. True b. False 2) One advantage of a view is that it can contain only those fields required by a given user. a. True b. False 3) An index increases the efficiency with which data is retrieved from the database. a. True b. False 4) There is a noticeable increase in efficiency when an index is used on a smaller table. a. True b. False 5) The fields or field on which an index is built is called the primary key. a. True b. False 6) The index key always consists of only one field in the table. a. True b. False 7) Security is the prevention of unauthorized access to the database. a. True b. False 8) Entity integrity is the rule that no field that is part of the primary key may accept null values. a. True b. False 9) Referential integrity is the rule that if table A contains a foreign key that matches the primary key of table B, the values of this foreign key must either match the value of the primary key for some row in table B or be null. a. True b. False 10) Legal-values integrity is the set of rules that governs the values allowed in a field. a. True b. False