100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
TEST BANK FOR DATABASE SYSTEMS DESIGN $36.99   Add to cart

Exam (elaborations)

TEST BANK FOR DATABASE SYSTEMS DESIGN

 7 views  0 purchase
  • Course
  • Institution

Chapter 01: Database Systems Copyright Cengage Learning. Po wered by Cognero. Page 1 True / False 1. Data and information are essen tially the same thing. a. True b. False ANSWER: False DIFFICULTY: Easy REFERENCES: 1-2 Data versus Information LEARNING OBJECTIVES: 01.01 - Define th...

[Show more]

Preview 4 out of 137  pages

  • March 26, 2024
  • 137
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
avatar-seller
11/1/23, 4:27 PM - Testbank for Database Systems Design, Implementation, & Manage…



Chapter 01: Database Systems

True / False

1. Data and information are essentially the same thing.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information

2. Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information

3. Data is the result of processing raw facts to reveal its meaning.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information

4. When data are entered into a form and saved, they are placed in the underlying database as knowledge.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information

5. Data constitute the building blocks of information.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information

6. Metadata describe the data characteristics and the set of relationships that links the data found within the database.
a. True
b. False

Copyright Cengage Learning. Powered by Cognero. Page 1




about:blank 1/137

,11/1/23, 4:27 PM - Testbank for Database Systems Design, Implementation, & Manage…



Chapter 01: Database Systems

ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

7. The only way to access the data in a database is through the DBMS.
a. True
b. False
ANSWER: True
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

8. Database programming languages receive all application requests and translate them into the complex operations
required to fulfill those requests.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

9. The DBMS reveals much of the database’s internal complexity to the application programs and users.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

10. One disadvantage of the DBMS is that it increases the risk of data security breaches.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

11. An operational database is sometimes referred to as an enterprise database.
a. True
b. False
Copyright Cengage Learning. Powered by Cognero. Page 2




about:blank 2/137

,11/1/23, 4:27 PM - Testbank for Database Systems Design, Implementation, & Manage…



Chapter 01: Database Systems

ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

12. A data warehouse can store data derived from many sources.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

13. Structure is based on the type of processing to be performed on the data.
a. True
b. False
ANSWER: True
DIFFICULTY: Moderate
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

14. Corporations use only structured data.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making

15. Field refers to a collection of related records.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-5b Computerized File Systems
LEARNING OBJECTIVES: 01.04 - See how modern databases evolved from file systems

16. Structural dependence exists when it is possible to make changes in the file structure without affecting the application
program’s ability to access the data.
a. True
b. False
ANSWER: False
Copyright Cengage Learning. Powered by Cognero. Page 3




about:blank 3/137

, 11/1/23, 4:27 PM - Testbank for Database Systems Design, Implementation, & Manage…



Chapter 01: Database Systems

DIFFICULTY: Moderate
REFERENCES: 1-6a Structural and Data Dependence
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management

17. One disadvantage of a database system over previous data management approaches is increased costs.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management

18. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world
events and conditions.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-6b Data Redundancy
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management

19. An advantage of database systems is that you needn't perform frequent updates and apply latest patches.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system

20. One advantage of a database system over previous data management approaches is that the database system is
considerably less complex.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system

Multiple Choice

21. _____ is the result of revealing the meaning of raw facts.
a. End-user data b. An encoded sample
c. An encrypted bit d. Information
ANSWER: d
DIFFICULTY: Easy

Copyright Cengage Learning. Powered by Cognero. Page 4




about:blank 4/137

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller THEEXCELLENCELIBRARY. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $36.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

72964 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$36.99
  • (0)
  Add to cart