Multiple Choice Questions

1. The columns of data in a database are often known as:

1. fields
2. records
3. tables
4. tuples

ANSWER:

2. The type of information stored in a field in a database is described by the:

1. tuple
2. field_name
3. data_format
4. record

ANSWER:

3. The primary key field for the student database on a campus is probably the student:

1. address
2. ID
3. phone
4. last name

ANSWER:

4. Which of the following fields could not be a primary key field?

1. Driver License number
2. student ID number
3. last name
4. Web address

ANSWER:

5. The SELECT COLUMN operation is used to:

1. create a new table from existing rows in a table
2. create a logical table from existing fields in a table
3. exclude specific rows from a table
4. remove existing fields from a table

ANSWER:

6. A logical table:

1. is created from existing information
2. is created fresh each time it is needed
3. may combine information from multiple tables
4. all of the above

ANSWER:

7. What operation takes rows from one table to create a new table?

1. Project
2. Union
3. Select row
4. Difference

ANSWER:

8. In database terminology, a set of entity instances refers to:

1. fields
2. columns
3. tables
4. rows

ANSWER:

9. The definition of a database includes all of the following except:

1. tuples
2. name
3. field specifiers
4. primary key

ANSWER:

10. Which is true about a row in a table?

1. A technical term for a row is a couple.
2. A row is often called a record.
3. A row is an entity, defining one particular object.
4. All of the above

ANSWER: