|
1 | | Which of the following rules states that a database must not contain any unmatched foreign keys? |
| | A) | entity integrity |
| | B) | database integrity |
| | C) | referential integrity |
| | D) | key integrity |
| | E) | field integrity |
|
|
2 | | Which of the following is false for a many-to-many relationship between two tables? |
| | A) | The connecting table contains the primary key fields of the original tables. |
| | B) | The two tables should have a one-to-many relationship to the connecting table. |
| | C) | The connecting table should have a one-to-one relationship with the other two. |
| | D) | both A and B are false statements |
| | E) | A, B, and C are all true statements |
|
|
3 | | Which of the following SQL commands will specify the tables to be used? |
| | A) | SELECT |
| | B) | WHERE |
| | C) | ORDER BY |
| | D) | FROM |
| | E) | AS |
|
|
4 | | For a selected query in the Design view, which of the following will display the five cheapest products? The field name for the product's prices is PRICE. |
| | A) | choose descending for sort order for PRICE, click (14.0K) , select 5 |
| | B) | choose ascending for sort order for PRICE, click (14.0K) , select 5 |
| | C) | choose descending for sort order for PRICE, click (14.0K) , select 5% |
| | D) | choose ascending for sort order for PRICE, click (14.0K) , select 5% |
| | E) | None of these will work |
|
|
5 | | In creating a query expression, quotation marks, colons, and asterisks would be classified as: |
| | A) | symbols |
| | B) | values |
| | C) | strings |
| | D) | identifiers |
| | E) | operators |
|