Question 1

The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server.

Accepted Answer

A) True 
 B)False  False

Question 2

The database application is responsible for concurrency control.

Accepted Answer

A) True 
 B)False  False

Question 3

What are the four components of a database system?

Accepted Answer

The four components in a database system are: the user,the database application,the database management system (DBMS)and the database.The user interacts with the database application,which interacts with the DBMS,which controls the database.The functions of the database application include creating and processing forms,creating and transmitting queries and creating and processing reports.The DBMS creates databases,tables and supporting structures,manages database data,enforces rules and provides security.The database stores the user data,the database metadata,indexes,triggers,stored procedures and application metadata.

Question 4

In a database,each table stores data about a different type of thing.

Accepted Answer

A) True 
 B)False

Question 5

Microsoft Access is just a DBMS.

Accepted Answer

A) True 
 B)False

Question 6

Database professionals use a set of principles called ________ to guide and assess database design.

Accepted Answer

A) database extraction 
B) normalization 
C) data models 
D) entity-relationship data modeling 
A) database extraction 
B) normalization 
C) data models 
D) entity-relationship data modeling

Question 7

For database development,a challenge to the relational model and the use of SQL is known as ________.

Accepted Answer

A) the Web services movement 
B) the NoSQL movement 
C) the SOAP movement 
D) the XML movement 
A) the Web services movement 
B) the NoSQL movement 
C) the SOAP movement 
D) the XML movement

Question 8

A very popular development technique used by database professionals to adopt a database design to a new or changing requirement is known as ________.

Accepted Answer

A) normalization 
B) data models 
C) entity-relationship data modeling 
D) database migration 
A) normalization 
B) data models 
C) entity-relationship data modeling 
D) database migration

Question 9

Databases are a key component of e-commerce order entry,billing,shipping and customer support.

Accepted Answer

A) True 
 B)False

Question 10

Referential integrity constraints are rules about what data values are allowed in certain columns.

Accepted Answer

A) True 
 B)False

Question 11

The predecessor(s)of database processing was (were)________.

Accepted Answer

A) file managers 
B) hierarchical models 
C) network models 
D) the relational data model 
A) file managers 
B) hierarchical models 
C) network models 
D) the relational data model

Question 12

Small databases typically have simple structures.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following statements is not true for an enterprise-class database system?

Accepted Answer

A) The database application(s)interact(s)with the DBMS. 
B) The database application(s)directly access(es)the database data. 
C) The DBMS accesses the database data. 
D) The application generates SQL statements. 
A) The database application(s)interact(s)with the DBMS. 
B) The database application(s)directly access(es)the database data. 
C) The DBMS accesses the database data. 
D) The application generates SQL statements.

Question 14

Like a database table,a spreadsheet has rows and columns.

Accepted Answer

A) True 
 B)False

Question 15

Each row in a database table is also known as a record.

Accepted Answer

A) True 
 B)False

Question 16

The DBMS ranked as having the "least power and features" in the text is Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 17

Twitter and Facebook use NoSQL databases.

Accepted Answer

A) True 
 B)False

Question 18

The description of a database's structure that is stored within the database itself is called the metadata.

Accepted Answer

A) True 
 B)False

Question 19

In an Enterprise-class database system,business users interact directly with the DBMS,which directly accesses the database data.

Accepted Answer

A) True 
 B)False

Question 20

Paradox is the only major survivor of the "bloodbath of PC DBMS products."

Accepted Answer

A) True 
 B)False

Exam 1: Introduction

The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server.

The database application is responsible for concurrency control.

What are the four components of a database system?

In a database,each table stores data about a different type of thing.

Microsoft Access is just a DBMS.

Database professionals use a set of principles called ________ to guide and assess database design.

For database development,a challenge to the relational model and the use of SQL is known as ________.

A very popular development technique used by database professionals to adopt a database design to a new or changing requirement is known as ________.

Databases are a key component of e-commerce order entry,billing,shipping and customer support.

Referential integrity constraints are rules about what data values are allowed in certain columns.

The predecessor(s)of database processing was (were)________.

Small databases typically have simple structures.

Which of the following statements is not true for an enterprise-class database system?

Like a database table,a spreadsheet has rows and columns.

Each row in a database table is also known as a record.

The DBMS ranked as having the "least power and features" in the text is Microsoft Access.

Twitter and Facebook use NoSQL databases.

The description of a database's structure that is stored within the database itself is called the metadata.

In an Enterprise-class database system,business users interact directly with the DBMS,which directly accesses the database data.

Paradox is the only major survivor of the "bloodbath of PC DBMS products."

Introduction to Structured Query Language

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

E-R Diagrams and the UML Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Business Intelligence Systems

Big Data

Filters