1. An appropriate datatype for adding a sound clip would be:

A	B	C	D
VARCHAR	CHAR	DATE	BLOB

2. Designing physical files requires ________ of where and when data are used in various ways.

A	B	C	D
maps	descriptions	keys	hints

3. The value a field will assume unless the user enters an explicit value for an instance of that field is called a:

A	B	C	D
default value	null value.	range control.	gurand.

4. A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.

A	B	C	D
physical pointer	retrieval program	file organization	update program

5. Distributing the rows of data into separate files is called:

A	B	C	D
normalization	horizontal partitioning	vertical partitioning	file allocation

6. Which of the following is a principal type of authorization table?

A	B	C	D
Subject	Transaction	View	Index

7. A(n) ________ is a routine that converts a primary key value into a record address.

A	B	C	D
record index calculator	index pointer program	hashing algorithm	pointing algorithm

8. SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.

A	B	C	D
grouping	joining	union	subquery

9. Which of the following is an objective of selecting a data type?

A	B	C	D
Represent a small number of possible values	Maximize storage space	Limit security	Improve data integrity