QUESTION 1. The word ________ indicates that the facts have not yet been processed to reveal their meaning. (0.25 points)
QUESTION 2. What type of relationship is expressed with the phrase "Student takes Class"? (0.25 points)
QUESTION 3. ________ is the de facto query language and data access standard supported by the majority of DBMS vendors. (0.25 points)
- Structured Query Language
- Access Query Language
QUESTION 4. The most widely used conceptual model is the ________ model. (0.25 points)
QUESTION 5. Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________. (0.25 points)
QUESTION 6. Processed data, or ________, can be used as the foundation for decision making. (0.25 points)
- raw data
QUESTION 7. A record consists of a ________. (0.25 points)
- collection of related records
- group of files
- set of one or more fields
QUESTION 8. Which data model contains the most semantics? (0.25 points)
QUESTION 9. A(n) ________ allows the user to specify what must be done without specifying how it must be done. (0.25 points)
- nonprocedural language
- procedural language
- object-oriented language
QUESTION 10. From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ________. (0.25 points)
- relationships between the tables
- business rules
- SQL engine
QUESTION 11. What is a benefit of using a DBMS? (0.25 points)
- It provides full security to data using private/public key encryption.
- It creates automatic backups.
- It helps create an environment for end users to have access to more data.
- It provides seamless Internet access to database data.
QUESTION 12. A ________ is the equivalent of a file system`s record type. (0.25 points)
QUESTION 13. The network database models have ________. (0.25 points)
- an owner/member relationship that promotes database integrity
- a simple system that promotes efficiency
- a navigational system that yields simple design
- a great deal of structural independence
QUESTION 14. The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________. (0.25 points)
- table generator
- security system
- query language
- access control
QUESTION 15. Which of the following products do not provide an enterprise database? (0.25 points)
- IBM DB2
- MS SQL Server
- MS Access
- Oracle RDBMS
QUESTION 16. What modern development gave the use of complex objects a boost? (0.25 points)
- the Internet
- object-oriented programming
QUESTION 17. Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program`s ability to access the data. (0.25 points)
QUESTION 18. What is a key characteristic of knowledge? (0.25 points)
- It exists in a vacuum.
- "new" Knowledge can be derived from "old" knowledge.
- It cannot be duplicated.
- It is assembled from raw data.
QUESTION 19. A CUSTOMER ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit. (0.25 points)
QUESTION 20. The design of a ________ database recognizes the use of historical and aggregated data. (0.25 points)
- data warehouse