| FIT100 Miniquiz #10 3/7/2005 Closed Book, Closed Notes Scoring: 1 pt. per question |
Name: _____________________________
Section: ________ |
| 1. In a database table, a "key" is |
A. a password
B. a unique value C. a data type |
| 2. In a relational database, three of the terms
listed are synonyms; which one is not? |
A. relation B. row C. tuple D. record |
| 3. Table A shows first name, last name, salary,
and address. Table B shows only last name and salary.
What is a plausible operation that might have created B from A? |
A.
selection
B. projection C. difference D. join |
| 4. Suppose table A has 3 columns and 4 rows;
table B has 5 columns and 6 rows. Consider the PRODUCT of A and
B. How many rows does it have? |
A. 4 B. 6 C. 10 D. 20 E. 24 |
| 5. Suppose table A has 3 columns and 4 rows; table B has 5 columns and 6 rows. Consider the PRODUCT of A and B. How many columns does it have? | A. 3 B. 5 C. 8 D. 15 E. 18 |
| 6. Between a form and a report, which one is more likely to show multiple records per screen? | A. a form B. a report |