 |
1 | |
Operational management would be mostly interested in the following type of data: |
| | A) | Economic forecasts |
| | B) | Supplier performance |
| | C) | Industry reports |
| | D) | Employee schedules |
|
|
2 | |
Which is the correct order of some of the stages of the information life cycle? |
| | A) | Storage, acquisition, dissemination, usage |
| | B) | Acquisition, storage, dissemination, usage |
| | C) | Dissemination, usage, storage, acquisition |
| | D) | Storage, dissemination, acquisition, usage |
|
|
3 | |
The distinction between data administration and database administration: |
| | A) | Is usually well-defined in small organizations |
| | B) | Is always well-defined in all organizations |
| | C) | Is rarely well-defined in large organizations |
| | D) | Is usually well-defined in large organizations |
|
|
4 | |
Which of the following is not used in a SQL statement used for security control statement? |
| | A) | GRANT DELETE ON CUSTOMER TO userx |
| | B) | SELECT NAME FROM CUSTOMER |
| | C) | REVOKE SELECT ON CUSTOMER FROM usery |
| | D) | GRANT SELECT ON CUSTOMER TO userz |
|
|
5 | |
In a DBMS using encryption: |
| | A) | data is stored as plaintext |
| | B) | data is stored as ciphertext |
| | C) | special integrity constraint rules apply |
| | D) | none of the above |
|
|
6 | |
Which of the following is not a responsibility of a DBA? |
| | A) | setting standards for stored procedure and trigger coding practices |
| | B) | monitoring object dependencies |
| | C) | writing stored procedures and triggers |
| | D) | understanding trigger interactions |
|
|
7 | |
"Data dictionary" refers to: |
| | A) | A large collection of catalog tables provided by the DBMS |
| | B) | An information resource dictionary provided by CASE tool vendors |
| | C) | Either one of the above |
| | D) | None of the above |
|
|
8 | |
The persons playing the most important role in the selection of a DBMS are: |
| | A) | Database administrators |
| | B) | Data administrators |
| | C) | Application programmers |
| | D) | Database designers |
|
|
9 | |
The analytic hierarchy process: |
| | A) | Assigns individual weights to DBMS requirements |
| | B) | Assigns weights to pairs of DBMS requirements |
| | C) | Directly ranks DBMS requirements |
| | D) | All of the above |
|
|
10 | |
Which of the following data would be part of the data in a data warehouse (after possible cleaning and aggregation)? |
| | A) | Previous year sales data |
| | B) | Sales data from two years ago |
| | C) | Market data bought from a specialized company |
| | D) | All of the above |
|