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
Diff: 2 Page Ref: 29
N
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
U
2) What is the name of Microsoft's cloud services?
Answer: Azure
R
Diff: 2 Page Ref: 31
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
SE
3) What role does the Web browser play in a Web database application?
A) Hardware support
B) Microchip accelerator
C) Web user interface
D) Back-end Database Management System
D
E) Bug-reporting System
Answer: C
Diff: 1 Page Ref: 28
O
AACSB: Information Technology
Chapter Obj: Introduce Web database applications
Classification: Concept
C
4) For efficiency purposes, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 29
S
AACSB: Information Technology
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
B) User
N
C) ERD
D) DBMS
E) Database applications
U
Answer: C
Diff: 2 Page Ref: 18
AACSB: Information Technology
R
Chapter Obj: Know the components of a database system
Classification: Concept
8) A relational database is .
SE
A) a self-describing collection of related tables
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
E) a set of metadata
Answer: A
D
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Know the components of a database system
O
Classification: Concept
9) The component of a database that makes it self-describing is the .
A) related tables
C
B) applications
C) library
D) data set
S
E) metadata
Answer: E
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
kjhgfdsa
, lkjhgfdsa
10) Which of the following would not be an example of database metadata?
A) Names of tables in a database
B) Properties of tables in a database
C) Names of columns in a database and their associated tables
D) Properties of columns
E) Queries against records in the database tables
Answer: E
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
N
11) In relational databases, query requests use a language called .
Answer: Structured Query Language (SQL); Structured Query Language; SQL
U
Diff: 1 Page Ref: 16-17
AACSB: Information Technology
Chapter Obj: Know the components of a database system
R
Classification: Concept
12) Briefly describe the four components of a database system.
Answer: The components of a database system are: (1) the users, (2) the application programs,
SE
(3) the DBMS, and (4) the database. The users are the people that will employ the system to
input new data, modify existing data, and delete data in order to perform their jobs. The
application programs are computer programs that act as intermediaries between the users and the
DBMS. The application programs produce forms, reports, and queries; they also translate user
actions into data management requests for the DBMS. The DBMS manipulates the database. It
receives data management requests from the computer applications and translates them into read
D
and write commands for the database. The database contains the actual user data that the users
need to perform their jobs.
Diff: 2 Page Ref: 18-21
O
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
C
13) What components are included in a database?
Answer: The database contains user data, metadata, indexes and other overhead data, and
application metadata. User data is the data from the users' environment that they want to track.
S
Metadata is data about the structure of the database. Indexes and other overhead data are
structures that the database uses to improve performance. Finally, the application metadata is
data about forms, reports, and other application components that some databases, particularly
those created with desktop DBMS products, store with the database.
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
kjhgfdsa
, lkjhgfdsa
14) What is "metadata," and how does it relate to the definition of a database?
Answer: Metadata is data about the structure of the database itself. This includes data about the
names of all the tables in the database, the names of all the columns in each of the tables, the data
type of each column in each table, the properties of the tables and the columns, etc. Metadata
accounts for the "self-describing" aspect of the definition of a database as a "self-describing
collection of integrated tables."
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
N
15) A relational database can be defined as a self-describing collection of related tables.
Answer: TRUE
Diff: 1 Page Ref: 18
U
AACSB: Information Technology
Chapter Obj: Learn the elements of a database
Classification: Concept
R
16) A database is self-describing because the user maintains a record of the database structure
outside the database itself.
Answer: FALSE
SE
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Learn the elements of a database
Classification: Concept
17) Metadata is the user data stored in the database.
D
Answer: FALSE
Diff: 1 Page Ref: 19
AACSB: Information Technology
O
Chapter Obj: Learn the elements of a database
Classification: Concept
18) Data that the database keeps about its own structure is called .
C
Answer: metadata
Diff: 1 Page Ref: 19
AACSB: Information Technology
S
Chapter Obj: Learn the elements of a database
Classification: Concept
kjhgfdsa
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
Diff: 2 Page Ref: 29
N
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
U
2) What is the name of Microsoft's cloud services?
Answer: Azure
R
Diff: 2 Page Ref: 31
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
SE
3) What role does the Web browser play in a Web database application?
A) Hardware support
B) Microchip accelerator
C) Web user interface
D) Back-end Database Management System
D
E) Bug-reporting System
Answer: C
Diff: 1 Page Ref: 28
O
AACSB: Information Technology
Chapter Obj: Introduce Web database applications
Classification: Concept
C
4) For efficiency purposes, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 29
S
AACSB: Information Technology
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
B) User
N
C) ERD
D) DBMS
E) Database applications
U
Answer: C
Diff: 2 Page Ref: 18
AACSB: Information Technology
R
Chapter Obj: Know the components of a database system
Classification: Concept
8) A relational database is .
SE
A) a self-describing collection of related tables
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
E) a set of metadata
Answer: A
D
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Know the components of a database system
O
Classification: Concept
9) The component of a database that makes it self-describing is the .
A) related tables
C
B) applications
C) library
D) data set
S
E) metadata
Answer: E
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
kjhgfdsa
, lkjhgfdsa
10) Which of the following would not be an example of database metadata?
A) Names of tables in a database
B) Properties of tables in a database
C) Names of columns in a database and their associated tables
D) Properties of columns
E) Queries against records in the database tables
Answer: E
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
N
11) In relational databases, query requests use a language called .
Answer: Structured Query Language (SQL); Structured Query Language; SQL
U
Diff: 1 Page Ref: 16-17
AACSB: Information Technology
Chapter Obj: Know the components of a database system
R
Classification: Concept
12) Briefly describe the four components of a database system.
Answer: The components of a database system are: (1) the users, (2) the application programs,
SE
(3) the DBMS, and (4) the database. The users are the people that will employ the system to
input new data, modify existing data, and delete data in order to perform their jobs. The
application programs are computer programs that act as intermediaries between the users and the
DBMS. The application programs produce forms, reports, and queries; they also translate user
actions into data management requests for the DBMS. The DBMS manipulates the database. It
receives data management requests from the computer applications and translates them into read
D
and write commands for the database. The database contains the actual user data that the users
need to perform their jobs.
Diff: 2 Page Ref: 18-21
O
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
C
13) What components are included in a database?
Answer: The database contains user data, metadata, indexes and other overhead data, and
application metadata. User data is the data from the users' environment that they want to track.
S
Metadata is data about the structure of the database. Indexes and other overhead data are
structures that the database uses to improve performance. Finally, the application metadata is
data about forms, reports, and other application components that some databases, particularly
those created with desktop DBMS products, store with the database.
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
kjhgfdsa
, lkjhgfdsa
14) What is "metadata," and how does it relate to the definition of a database?
Answer: Metadata is data about the structure of the database itself. This includes data about the
names of all the tables in the database, the names of all the columns in each of the tables, the data
type of each column in each table, the properties of the tables and the columns, etc. Metadata
accounts for the "self-describing" aspect of the definition of a database as a "self-describing
collection of integrated tables."
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
N
15) A relational database can be defined as a self-describing collection of related tables.
Answer: TRUE
Diff: 1 Page Ref: 18
U
AACSB: Information Technology
Chapter Obj: Learn the elements of a database
Classification: Concept
R
16) A database is self-describing because the user maintains a record of the database structure
outside the database itself.
Answer: FALSE
SE
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Learn the elements of a database
Classification: Concept
17) Metadata is the user data stored in the database.
D
Answer: FALSE
Diff: 1 Page Ref: 19
AACSB: Information Technology
O
Chapter Obj: Learn the elements of a database
Classification: Concept
18) Data that the database keeps about its own structure is called .
C
Answer: metadata
Diff: 1 Page Ref: 19
AACSB: Information Technology
S
Chapter Obj: Learn the elements of a database
Classification: Concept
kjhgfdsa
