Chapter 10 Questions

True/False

Indicate whether the sentence or statement is true or false.

1. Computers process information in a database into data.

2. For a computer to produce correct information, the data that is input into a database must have integrity.

3. Most information gains value with time.

4. Eight bytes grouped together in a unit comprise a bit.

5. In a file processing system, the records in one file always relate to the records in other files.

6. Data in a database is more vulnerable than data in file processing systems.

7. For each field, a data dictionary stores details such as the field name, description, field type, field size, default value, validation rules, and the field’s relationship to other fields.

8. QBEs have a graphical user interface that assists users with retrieving data.

9. Today, a relational database is a rarely used type of database.

10. In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

11. Few personal computer databases include SQL.

12. A Web database never resides on a database server.

13. The maintenance of a database is an ongoing task that companies measure constantly against their overall goals.

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

14. _____ is a computer phrase that points out the accuracy of a computer’s output depends on the accuracy of its input.

a.	Nothing ventured, nothing gained (NVNG)
b.	Bad data, bad info (BDBI)
c.	Garbage in, garbage out (GIGO)
d.	What you see is what you get (WYSIWYG)

15. Verifiable information _____.

a.	gives more value than it costs to produce
b.	is arranged to suit the needs and requirements of a decision maker
c.	has meaning to the person who receives it
d.	can be proven as correct or incorrect

16. Useful information _____.

a.	is available when a decision maker needs it
b.	has an age suited to its use
c.	can be proven as correct or incorrect
d.	has meaning to the person who receives it

17. _____ is a common data type that consists of dollar and cent amounts or numbers containing decimal values.

a.	AutoNumber	c.	Currency
b.	Text	d.	Object

18. Generally, users change records in a file _____.

a.	when they obtain new data and to correct inaccurate data
b.	to correct inaccurate data and to update old data with new data
c.	to update old data with new data and when a record no longer is needed
d.	when a record no longer is needed and when they obtain new data

19. If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) _____ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

a.	range check	c.	consistency check
b.	completeness check	d.	alphabetic/numeric check

20. A major weakness of a lot of file processing systems is that _____.

a.	they have redundant data and they isolate data
b.	they are much more complex than a database
c.	data is more vulnerable than data in a database
d.	all of the above

21. Although a query language can be used for other purposes, most users only _____ data with a query language.

a.	retrieve	c.	change
b.	add	d.	delete

22. To ensure privacy, members would have _____ privileges to the data in a fitness club database.

a.	read-only	c.	full-update
b.	write-only	d.	no access

23. In a relational database, each row _____.

a.	and each column has a primary key
b.	has a unique name and each column has a primary key
c.	has a primary key and each column has a unique name
d.	and each column has a unique name

24. Many e-commerce sites use _____ to determine customer preferences.

a.	data checking	c.	data sorting
b.	data mining	d.	data serving

25. The DBA does all of the following except _____.

a.	manage security of the database	c.	check backup and recovery procedures
b.	monitor the performance of the database	d.	decide on the proper placement of fields