1 tom.com



chapter 11

Databases and

True-False Questions

1. A record in a database can contain multiple fields.

Answer: True Level: Easy

Section: 11-1 Page: 287

2. A field in a database can contain multiple tables.

Answer: False Level: Easy

Section: 11-1 Page: 287

3. A table in a database can contain multiple records.

Answer: True Level: Easy

Section: 11-1 Page: 287

4. A relational database model specifies the relationship between records.

Answer: False Level: Moderate

Section: 11-1 Page: 287

5. The foreign key in a table uniquely identifies each row.

Answer: False Level: Moderate

Section: 11-1 Page: 287

6. The primary and foreign keys identify the relationship between tables.

Answer: True Level: Moderate

Section: 11-1 Page: 287

7. One example of a relationship between tables is the one to many relationship.

Answer: True Level: Moderate

Section: 11-1 Page: 289

8. The primary and foreign keys are the only fields in most tables.

Answer: False Level: Moderate

Section: 11-1 Page: 287

9. Microsoft Access is the only program available to create a database.

Answer: False Level: Easy

Section: 11-1 Page: 288

10. The normalization process is used to eliminate data redundancy.

Answer: True Level: Easy

Section: 11-1 Page: 289

11. Information is retrieved from the database using the Structured Query Language.

Answer: True Level: Easy

Section: 11-2 Page: 290

12. The SELECT clause of an SQL query specifies which fields are retrieved.

Answer: True Level: Easy

Section: 11-2 Page: 290

13. The FROM clause of an SQL query specifies which rows are retrieved.

Answer: False Level: Easy

Section: 11-2 Page: 290

14. The # symbol in an SQL query is a wildcard, which retrieves all fields in a table.

Answer: False Level: Easy

Section: 11-2 Page: 290

15. Square brackets [ ] must surround any database field name that has a space in it.

Answer: True Level: Moderate

Section: 11-2 Page: 290

16. The WHERE clause must have criteria for restricting a subset of the data.

Answer: True Level: Easy

Section: 11-2 Page: 291

17. The four relational operators allowed in the WHERE clause are >, , =, ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download