 |
| 1 | |
Which of the following places the common data elements in order from smallest to largest? |
| | A) | Character, file, record, field, database. |
| | B) | Character, record, field, file, database. |
| | C) | Character, field, record, file, database. |
| | D) | Bit, byte, character, record, field, file, database. |
|
|
|
| 2 | |
Which of the statements below best describes a database? |
| | A) | Contains data elements describing entities and relationships among entities. |
| | B) | Contains files and fields. |
| | C) | Contains the hierarchy. |
| | D) | None of the choices are correct. |
|
|
|
| 3 | |
In which of the following database structures do the relationships NOT have to be specified in advance? |
| | A) | Hierarchical. |
| | B) | Network. |
| | C) | Relational. |
| | D) | Operational. |
|
|
|
| 4 | |
Using a relational database of students at a university, which database operation could be used to create a subset of records that includes only computer information systems majors? |
| | A) | Project. |
| | B) | Select. |
| | C) | Join. |
| | D) | Report. |
|
|
|
| 5 | |
During data planning and database design, data models that support business processes are used to develop databases that meet the information needs of users. These models are called: |
| | A) | Association diagrams. |
| | B) | Data dictionaries. |
| | C) | Data manipulation language. |
| | D) | Entity relationship diagrams. |
|
|
|
| 6 | |
Distributed databases: |
| | A) | Can be on intranets and other networks. |
| | B) | Can be copies of operational databases or any other type of database. |
| | C) | Need to be replicated or duplicated so that the end users at any site have access to correct data. |
| | D) | All of the choices are correct. |
|
|
|
| 7 | |
Companies have found key value in using data warehouses for data mining, because they can: |
| | A) | Analyze static data to reveal hidden patterns and trends. |
| | B) | Analyze dynamic data to reveal hidden patterns and trends. |
| | C) | Transform the data. |
| | D) | None of the choices are correct. |
|
|
|
| 8 | |
Which of the following is not a benefit a company should experience when it moves away from traditional file processing systems to a database management approach? |
| | A) | More flexibility. |
| | B) | More data redundancy. |
| | C) | More data integration. |
| | D) | More data integrity. |
|
|
|
| 9 | |
Database development includes which of the following? |
| | A) | Using a DBMS to develop prototypes of queries, forms, reports, and Web pages for a business application. |
| | B) | Using transaction processing systems and other tools to add, delete, update, and correct the data in a database. |
| | C) | Defining and organizing the content, relationships, and structure of the data needed to build a database. |
| | D) | All of the choices are correct. |
|
|
|
| 10 | |
An international standard query language found in many DBMS packages is: |
| | A) | Access. |
| | B) | Structured Query Language. |
| | C) | Select Report. |
| | D) | Graphical User Interface. |
|
|
.