Test Bank for Database Concepts 9th Edition by David Kroenke, David Auer, Chapter 1-7 | All Chapters

TEST BANK
Database Concepts, 9th edition
by David Kroenke, David Auer
LU
XE
LI
BR
AR
Y

, TABLE OF CONTENT

PART 1: DATABASE FUNDAMENTALS

Getting Started

The Relational Model
Structured Query Language

PART 2: DATABASE DESIGN

Data Modeling and the Entity-Relationship Model

Database Design
LU
PART 3: DATABASE MANAGEMENT

Database Administration
Data Warehouses, Business Intelligence Systems, and Big Data
XE
ONLINE EXTENSIONS

Extension A: Working with MySQL

Extension B: Advanced SQL
LI
Extension C: Advanced Business Intelligence and Big Data
BR
AR
Y

, lkjhgfdsa
All Chapters Included


Database Concepts, 9e (Kroenke) All Answers Included
Chapter 1 Getting Started

1) Regarding Big Data, what does the term NoSQL really mean?
A) No SQL used
B) NortonOS Query Language
C) Notational Query Language
D) Non-Blocking Query Language
E) Nonrelational Database
Answer: E
LU
Diff: 2 Page Ref: 29
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept

2) What is the name of Microsoft's cloud services?
XE
Answer: Azure
Diff: 2 Page Ref: 31
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
LI
3) What role does the Web browser play in a Web database application?
A) Hardware support
B) Microchip accelerator
BR
C) Web user interface
D) Back-end Database Management System
E) Bug-reporting System
Answer: C
Diff: 1 Page Ref: 28
AACSB: Information Technology
Chapter Obj: Introduce Web database applications
AR
Classification: Concept

4) For efficiency purposes, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 29
AACSB: Information Technology
Y
Chapter Obj: Introduce data warehouses and business intelligence (BI) systems
Classification: Concept

5) Although users use database systems, they are not considered part of a database system.
Answer: FALSE
Diff: 1 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept


kjhgfdsa

, lkjhgfdsa



6) A database is a set of one or more computer programs that serves as an intermediary between
the users and the database management system (DBMS).
Answer: FALSE
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept

7) Which of the following is not a basic component of a database system?
A) Database
LU
B) User
C) ERD
D) DBMS
E) Database applications
Answer: C
Diff: 2 Page Ref: 18
XE
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept

8) A relational database is .
A) a self-describing collection of related tables
LI
B) a collection of forms and reports that support a given purpose
C) a library of queries and data files for querying
D) a set of applications and the data sets for those applications
BR
E) a set of metadata
Answer: A
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
AR
9) The component of a database that makes it self-describing is the .
A) related tables
B) applications
C) library
D) data set
E) metadata
Y
Answer: E
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept




kjhgfdsa