 |
1 | |
Which one of the following is not an example of information as defined by the text? |
| | A) | The fact that Mr. Smith's account balance is $118.25. |
| | B) | The economics professor's social security number is 456-78-1234. |
| | C) | The retail price of blue widgets is $29.88. |
| | D) | The numbers 12345678, 18901234, 56789012. |
|
|
2 | |
You have created your own personal database of all the courses, course numbers, and professors' names you have this semester. Last names, office numbers, and phone numbers would be ________ in your database. |
| | A) | records |
| | B) | files |
| | C) | fields |
| | D) | characters |
|
|
3 | |
When you bring together logically associated files, you create a: |
| | A) | Database. |
| | B) | Field. |
| | C) | Character. |
| | D) | File. |
|
|
4 | |
This database model has become the most popular database model, as it is used by most microcomputer DBMS packages: |
| | A) | Object-oriented database model. |
| | B) | Relational database model. |
| | C) | Network database model. |
| | D) | Hierarchical database model. |
|
|
5 | |
You need to create a database for the local hospital. It is critical that the data organization be flexible. What type of database is the most common and flexible model today? |
| | A) | Hierarchical database. |
| | B) | Object-oriented database. |
| | C) | Relational database. |
| | D) | Network database. |
|
|
6 | |
A(n) ________ database uses tables to show the relationships among the fields in the files. |
| | A) | hierarchical |
| | B) | network. |
| | C) | object-oriented |
| | D) | relational |
|
|
7 | |
Which of the following is a term for a field (or group of fields) that uniquely describes each record in a database table? |
| | A) | Entity class. |
| | B) | Primary key. |
| | C) | Entity-relationship diagram. |
| | D) | Object. |
|
|
8 | |
A primary key that uses more than one field to create a unique description is called a(n): |
| | A) | Compound primary key. |
| | B) | Intersection primary key. |
| | C) | Interaction primary key. |
| | D) | Atomic primary key. |
|
|
9 | |
What is a primary key of one file that appears in another file? |
| | A) | Intersection relation. |
| | B) | Composite primary key. |
| | C) | Foreign key. |
| | D) | None of the above. |
|
|
10 | |
Rules that help ensure the quality of information in a database are called: |
| | A) | Integrity constraints. |
| | B) | E-R rules. |
| | C) | Data subsystems. |
| | D) | Foreign keys. |
|
|
11 | |
A graphic method of representing tables in a database and the relationships among the tables is a(n): |
| | A) | Query-by-example tool. |
| | B) | Entity-relationship diagram. |
| | C) | Intersection relation diagram. |
| | D) | Flowchart. |
|
|
12 | |
What symbol is used in an E-R diagram to denote a multiple relationship? |
| | A) | Rectangle. |
| | B) | Dotted line. |
| | C) | Crow's foot. |
| | D) | Circle. |
|
|
13 | |
A(n) ________ database is organized into parent and child nodes, with each child having only one parent. |
| | A) | hierarchical |
| | B) | network |
| | C) | object-oriented |
| | D) | relational |
|
|
14 | |
A(n) ________ database can handle unstructured data like graphics and video. |
| | A) | hierarchical |
| | B) | relational |
| | C) | object-oriented |
| | D) | network |
|
|
15 | |
A DBMS allows you to: |
| | A) | Arrange information in a database. |
| | B) | Modify information in a database. |
| | C) | Extract information from a database. |
| | D) | Perform all of the above. |
|
|
16 | |
In a DBMS, this subsystem helps you enter information into a database, query it to find information, and obtain the results: |
| | A) | Data definition subsystem. |
| | B) | Data manipulation subsystem. |
| | C) | Application generation subsystem. |
| | D) | Data administration subsystem. |
|
|
17 | |
Responsibility for the more technical aspects of designing, implementing, and maintaining corporate databases falls on this individual: |
| | A) | Database administrator. |
| | B) | Programmer. |
| | C) | Chief information officer. |
| | D) | Analysts. |
|
|
18 | |
A Web page for which you can define the content that you want to see is called a personal: |
| | A) | Protocol. |
| | B) | Bookmark. |
| | C) | Portal. |
| | D) | Link. |
|
|
19 | |
The process of exploring information electronically in a data warehouse to discover new information and relationships is called: |
| | A) | Data exploring. |
| | B) | Data mining. |
| | C) | Data retrieving. |
| | D) | Data modeling. |
|
|
20 | |
This set of tools would be used to help you apply various mathematical models to the information stored in a data warehouse to discover new information: |
| | A) | Query-and-reporting. |
| | B) | Multidimensional analysis. |
| | C) | Statistical. |
| | D) | Data-mining. |
|