, TESTBANK FOR Databases Illuminated Fourth Edition Ricardo
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
Quizzes, Midterm and final exams are included (if available in the original resources).
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Import Settings:
Base Settings: Brownstone Default
Information Field: Complexity
Information Field: Ahead
Information Field: Subject
Information Field: Title
Highest Answer Letter: D
Multiple Keywords in Same Paragraph: No
NAS ISBN13: 9781284236354, add to Ahead, Title tags
Chapter: Chapter 01 – Quiz
Multiple Choice
1. The technology that uses distributed peer-to-peer computing to securely manage transactions using
distributed ledgers is called:
A) cloud computing.
B) blockchain.
C) object-oriented.
D) the Internet of Things.
Ans: B
Complexity: Easy
Ahead: Uses of Databases
Subject: Chapter 1
Title: Introductory Database Concepts
2. In a database system, a question such as "Find the names of all students who take class ENG210" is
called a:
A) report.
B) form.
C) statement.
D) query.
Ans: D
Complexity: Easy
Ahead: A Sample Database
Subject: Chapter 1
Title: Introductory Database Concepts
3. The software that controls the database is called the:
A) DBMS.
B) DBA.
C) file controller.
D) MIS.
Ans: A
Complexity: Easy
Ahead: The Integrated Database Environment
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,Subject: Chapter 1
Title: Introductory Database Concepts
4. All of the following are functions performed by a DBMS except:
A) performing updates.
B) spell checking.
C) formatting data for users.
D) controlling concurrency.
Ans: B
Complexity: Moderate
Ahead: The Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
5. Information about the structure of database records and the logical connections between the data
items and records is called:
A) big data.
B) traffic data.
C) enterprise data.
D) metadata.
Ans: D
Complexity: Moderate
Ahead: The Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
6. Since database data items are stored in compatible formats and logical connections among them are
also stored, we describe database data as:
A) independent.
B) integrated.
C) redundant.
D) isolated.
Ans: B
Complexity: Moderate
Ahead: The Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
7. Database users who enter their own queries are called:
A) casual users.
B) naïve users.
C) programmers.
D) DBAs.
Ans: A
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,8. Database users who access data only through application programs are called:
A) casual users.
B) naïve users.
C) programmers.
D) DBAs.
Ans: B
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
9. The person who designs, creates, and manages the database is the:
A) end user.
B) sophisticated user.
C) DBMS.
D) DBA.
Ans: D
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
10. All of the following are responsibilities of the database administrator except:
A) designing the database.
B) creating the database.
C) writing application programs for the database.
D) maintaining the database.
Ans: C
Complexity: Moderate
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
11. Data professionals who work with DBAs to create data pipelines are called:
A) data engineers.
B) data managers.
C) information specialists.
D) systems programmers.
Ans: A
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
12. Automated processes for moving data between databases are called:
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,A) data streams.
B) data pipelines.
C) data lakes.
D) data warehouses.
Ans: B
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
13. The portion of the database that a user is authorized to see is called a:
A) table.
B) subdatabase.
C) tree.
D) view.
Ans: D
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
14. In a bank, all of the following are examples of end users except a:
A) loan administrator.
B) database administrator.
C) teller.
D) bank manager.
Ans: B
Complexity: Moderate
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
15. Sophisticated users are also called:
A) naïve users.
B) casual users.
C) programmers.
D) clerks.
Ans: B
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
16. Which of the following is an advantage of a database compared to a file processing system?
A) Fast processing of sequential data
B) Lower cost
C) Sharing of data
D) Simpler recovery
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,Ans: C
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
17. All of the following are potential advantages of using a database except:
A) control of redundancy.
B) improved data integrity.
C) lower cost.
D) better data consistency.
Ans: C
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
18. Having multiple copies of the same data is called:
A) data redundancy.
B) data integrity.
C) data consistency.
D) data standards.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
19. Database access by two or more users at the same time is described as:
A) concurrent.
B) independent.
C) dependent.
D) serial.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
20. All of the following are examples of data standards except:
A) data naming conventions.
B) update procedures.
C) documentation rules.
D) query optimization.
Ans: D
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,Title: Introductory Database Concepts
21. Protecting the database from unauthorized access or modification is called:
A) data security.
B) user authorization.
C) data backup.
D) data recovery.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
22. Data consistency means:
A) all users see exactly the same data.
B) all data is shared.
C) all occurrences of the same data item agree.
D) there is no redundancy of data.
Ans: C
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
23. Having consistency rules that the database must obey is called:
A) data integrity.
B) data standards.
C) data backup.
D) data security.
Ans: A
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
24. All of the following are data security techniques except:
A) passwords.
B) data encryption.
C) views.
D) windows.
Ans: D
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,25. Faster development of new applications is often possible in a database environment because:
A) no file creation phase is needed.
B) new applications are independent of old ones.
C) no program planning is required.
D) the database administrator does all programming.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
26. A copy of the database made to be used in case of failure is called a:
A) recovery log.
B) security system.
C) transaction log.
D) backup.
Ans: D
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
27. The data storage technology used in the 1890 census was:
A) punched cards.
B) punched paper tape.
C) magnetic tape.
D) magnetic disk.
Ans: A
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
28. The Census Bureau employee who proposed the use of punched cards for data storage was:
A) Thomas Watson.
B) Thomas Edison.
C) John von Neumann.
D) Herman Hollerith.
Ans: D
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
29. Prior to their use for processing data, punched cards were used in which of the following fields?
A) Education
B) Weaving
C) Agriculture
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
, D) Astronomy
Ans: B
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
30. The old master/new master system of processing is described as:
A) interactive.
B) concurrent.
C) batch.
D) direct.
Ans: C
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
31. Which of the following storage technologies first offered direct access to stored records?
A) Paper tape
B) Magnetic tape
C) Magnetic disk
D) Punched cards
Ans: C
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
32. The IMS database management system from IBM used which of the following data models?
A) Hierarchical
B) Network
C) Functional
D) Relational
Ans: A
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
33. The IDS database management system developed by Charles Bachman used which of the following
data models?
A) Hierarchical
B) Network
C) Functional
D) Relational
Ans: B
Complexity: Easy
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
Quizzes, Midterm and final exams are included (if available in the original resources).
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Import Settings:
Base Settings: Brownstone Default
Information Field: Complexity
Information Field: Ahead
Information Field: Subject
Information Field: Title
Highest Answer Letter: D
Multiple Keywords in Same Paragraph: No
NAS ISBN13: 9781284236354, add to Ahead, Title tags
Chapter: Chapter 01 – Quiz
Multiple Choice
1. The technology that uses distributed peer-to-peer computing to securely manage transactions using
distributed ledgers is called:
A) cloud computing.
B) blockchain.
C) object-oriented.
D) the Internet of Things.
Ans: B
Complexity: Easy
Ahead: Uses of Databases
Subject: Chapter 1
Title: Introductory Database Concepts
2. In a database system, a question such as "Find the names of all students who take class ENG210" is
called a:
A) report.
B) form.
C) statement.
D) query.
Ans: D
Complexity: Easy
Ahead: A Sample Database
Subject: Chapter 1
Title: Introductory Database Concepts
3. The software that controls the database is called the:
A) DBMS.
B) DBA.
C) file controller.
D) MIS.
Ans: A
Complexity: Easy
Ahead: The Integrated Database Environment
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,Subject: Chapter 1
Title: Introductory Database Concepts
4. All of the following are functions performed by a DBMS except:
A) performing updates.
B) spell checking.
C) formatting data for users.
D) controlling concurrency.
Ans: B
Complexity: Moderate
Ahead: The Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
5. Information about the structure of database records and the logical connections between the data
items and records is called:
A) big data.
B) traffic data.
C) enterprise data.
D) metadata.
Ans: D
Complexity: Moderate
Ahead: The Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
6. Since database data items are stored in compatible formats and logical connections among them are
also stored, we describe database data as:
A) independent.
B) integrated.
C) redundant.
D) isolated.
Ans: B
Complexity: Moderate
Ahead: The Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
7. Database users who enter their own queries are called:
A) casual users.
B) naïve users.
C) programmers.
D) DBAs.
Ans: A
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,8. Database users who access data only through application programs are called:
A) casual users.
B) naïve users.
C) programmers.
D) DBAs.
Ans: B
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
9. The person who designs, creates, and manages the database is the:
A) end user.
B) sophisticated user.
C) DBMS.
D) DBA.
Ans: D
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
10. All of the following are responsibilities of the database administrator except:
A) designing the database.
B) creating the database.
C) writing application programs for the database.
D) maintaining the database.
Ans: C
Complexity: Moderate
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
11. Data professionals who work with DBAs to create data pipelines are called:
A) data engineers.
B) data managers.
C) information specialists.
D) systems programmers.
Ans: A
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
12. Automated processes for moving data between databases are called:
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,A) data streams.
B) data pipelines.
C) data lakes.
D) data warehouses.
Ans: B
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
13. The portion of the database that a user is authorized to see is called a:
A) table.
B) subdatabase.
C) tree.
D) view.
Ans: D
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
14. In a bank, all of the following are examples of end users except a:
A) loan administrator.
B) database administrator.
C) teller.
D) bank manager.
Ans: B
Complexity: Moderate
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
15. Sophisticated users are also called:
A) naïve users.
B) casual users.
C) programmers.
D) clerks.
Ans: B
Complexity: Easy
Ahead: Roles in the Integrated Database Environment
Subject: Chapter 1
Title: Introductory Database Concepts
16. Which of the following is an advantage of a database compared to a file processing system?
A) Fast processing of sequential data
B) Lower cost
C) Sharing of data
D) Simpler recovery
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,Ans: C
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
17. All of the following are potential advantages of using a database except:
A) control of redundancy.
B) improved data integrity.
C) lower cost.
D) better data consistency.
Ans: C
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
18. Having multiple copies of the same data is called:
A) data redundancy.
B) data integrity.
C) data consistency.
D) data standards.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
19. Database access by two or more users at the same time is described as:
A) concurrent.
B) independent.
C) dependent.
D) serial.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
20. All of the following are examples of data standards except:
A) data naming conventions.
B) update procedures.
C) documentation rules.
D) query optimization.
Ans: D
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,Title: Introductory Database Concepts
21. Protecting the database from unauthorized access or modification is called:
A) data security.
B) user authorization.
C) data backup.
D) data recovery.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
22. Data consistency means:
A) all users see exactly the same data.
B) all data is shared.
C) all occurrences of the same data item agree.
D) there is no redundancy of data.
Ans: C
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
23. Having consistency rules that the database must obey is called:
A) data integrity.
B) data standards.
C) data backup.
D) data security.
Ans: A
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
24. All of the following are data security techniques except:
A) passwords.
B) data encryption.
C) views.
D) windows.
Ans: D
Complexity: Moderate
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
,25. Faster development of new applications is often possible in a database environment because:
A) no file creation phase is needed.
B) new applications are independent of old ones.
C) no program planning is required.
D) the database administrator does all programming.
Ans: A
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
26. A copy of the database made to be used in case of failure is called a:
A) recovery log.
B) security system.
C) transaction log.
D) backup.
Ans: D
Complexity: Easy
Ahead: Advantages of the Integrated Database Approach
Subject: Chapter 1
Title: Introductory Database Concepts
27. The data storage technology used in the 1890 census was:
A) punched cards.
B) punched paper tape.
C) magnetic tape.
D) magnetic disk.
Ans: A
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
28. The Census Bureau employee who proposed the use of punched cards for data storage was:
A) Thomas Watson.
B) Thomas Edison.
C) John von Neumann.
D) Herman Hollerith.
Ans: D
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
29. Prior to their use for processing data, punched cards were used in which of the following fields?
A) Education
B) Weaving
C) Agriculture
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
, D) Astronomy
Ans: B
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
30. The old master/new master system of processing is described as:
A) interactive.
B) concurrent.
C) batch.
D) direct.
Ans: C
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
31. Which of the following storage technologies first offered direct access to stored records?
A) Paper tape
B) Magnetic tape
C) Magnetic disk
D) Punched cards
Ans: C
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
32. The IMS database management system from IBM used which of the following data models?
A) Hierarchical
B) Network
C) Functional
D) Relational
Ans: A
Complexity: Easy
Ahead: Historical Developments in Information Systems
Subject: Chapter 1
Title: Introductory Database Concepts
33. The IDS database management system developed by Charles Bachman used which of the following
data models?
A) Hierarchical
B) Network
C) Functional
D) Relational
Ans: B
Complexity: Easy
Copyright © 2017 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
