 |
| 1 | |
Which tool is used to help an organization build and use business intelligence? |
| | A) | Data warehouse |
| | B) | Data mining tools |
| | C) | Database management systems |
| | D) | All of the above |
|
|
|
| 2 | |
What does the data dictionary identify? |
| | A) | Field names |
| | B) | Field types |
| | C) | Field formats |
| | D) | All of the above |
|
|
|
| 3 | |
Which of the following is a data manipulation tool? |
| | A) | File generators |
| | B) | Query by example tool |
| | C) | Structure question language |
| | D) | Report generators |
|
|
|
| 4 | |
What data manipulation tool is a standardized fourth-generation query language found in most DBMSs? |
| | A) | Report generator |
| | B) | Query-by-example tool |
| | C) | Statistical tool |
| | D) | None of the above |
|
|
|
| 5 | |
What DBMS component contains facilities to help you develop transaction-intensive applications? |
| | A) | DBMS engine |
| | B) | Data definition subsystem |
| | C) | Application generation subsystem |
| | D) | Data administration subsystem |
|
|
|
| 6 | |
The data administration subsystem helps you perform all of the following, except: |
| | A) | Create, change, and delete information |
| | B) | Query optimization |
| | C) | Security management |
| | D) | Backups and recovery |
|
|
|
| 7 | |
Which data administration subsystem periodically backs up information contained in a database? |
| | A) | Concurrency control facilities |
| | B) | Backup and recovery facilities
Reorganization facilities |
| | C) | Reorganization facilities |
| | D) | Security management facilities |
|
|
|
| 8 | |
To centralize all and make sense out of all of the data they were collecting, Future Shop implemented this type of system: |
| | A) | CRM |
| | B) | SCM |
| | C) | Relational database |
| | D) | Data warehouse |
|
|
|
| 9 | |
Who is the person responsible for the more technical and operational aspects of managing the information contained in organizational databases? |
| | A) | Chief information officer |
| | B) | Data administrator |
| | C) | Database administrator |
| | D) | Programmer
|
|
|
|
| 10 | |
One easy way to determine information ownership is to think in terms of CRUD – an acronym for: |
| | A) | Create, read, update, and detect |
| | B) | Changes, relations, update, and define |
| | C) | Changes, report, update, and define |
| | D) | Create, read, update, and delete |
|
|
.