 |
1 | |
The acronym DBMS means: |
| | A) | Database Management System |
| | B) | Detail By Menu Selection |
| | C) | Don't Buy My Software |
| | D) | Doughnuts Bring Me Satisfaction |
|
|
2 | |
Databases exist to organize two basic types of data: ________, the things we are storing information about, and ____________, the connections between the things we store information about. |
| | A) | entities, relationships |
| | B) | variables, statements |
| | C) | Both A and B |
| | D) | None of the above |
|
|
3 | |
An ERD is used in the design of a database to organize what? |
| | A) | Entities |
| | B) | Relationships |
| | C) | Cardinality between entities |
| | D) | All of the above |
|
|
4 | |
An important characteristic of a database table's key is that it identifies a(n) ______ entry in the table. |
| | A) | unique |
| | B) | corrupted |
| | C) | erroneous |
| | D) | empty |
|
|
5 | |
________ ____ are unique identifiers that are created by combining two or more columns of data. |
| | A) | Complex identifiers |
| | B) | Compound keys |
| | C) | Joint columns |
| | D) | Indeterminate Fields |
|
|
6 | |
When one database table contains a key to another table as one of its fields, this field is commonly referred to as a(n) _______ key. |
| | A) | external |
| | B) | secondary |
| | C) | foreign |
| | D) | associated |
|
|
7 | |
When designing a database in which a many-to-many relationship exists between two tables, you must define a(n) ____________ table to map these relationships to each other. |
| | A) | gap |
| | B) | intersection |
| | C) | intermediate |
| | D) | difference |
|
|
8 | |
Database designers use a technique called ______________, introduced by Edgar F. Codd, to help eliminate redundant information, thereby reducing storage space. |
| | A) | differentiation |
| | B) | apportioning |
| | C) | dissemination |
| | D) | normalization |
|
|
9 | |
___ is a language that was developed specifically to address the challenge of selectively running a report on the contents of a database. |
| | A) | JCL |
| | B) | SQL |
| | C) | Visual Basic .NET |
| | D) | COBOL |
|
|
10 | |
A(n) ________ control provides a method of displaying database contents in an organized format. |
| | A) | database |
| | B) | DataGrid |
| | C) | ADO |
| | D) | DataRelation |
|
2003 McGraw-Hill Higher Education