Question 1

The largest databases in e-commerce are the order entry databases.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

A database system as typically defined can be modified to include CODASYL.

Accepted Answer

A) True 
 B)False

Question 4

A sales contact manager used by a salesperson is an example of a(n)________.

Accepted Answer

A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) A or B 
E) Any of A,B or C 
A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) A or B 
E) Any of A,B or C

Question 5

In an enterprise-class database system,the database application ________.

Accepted Answer

A) creates queries 
B) creates forms 
C) creates reports 
D) A and B 
E) B and C 
A) creates queries 
B) creates forms 
C) creates reports 
D) A and B 
E) B and C

Question 6

What components are included in a database?

Accepted Answer

The database contains user data,metadata

Question 7

Microsoft Access is a low-end product intended for individuals and small workgroups.

Accepted Answer

A) True 
 B)False

Question 8

The 1977 edition of this text contained a chapter on the relational model,and that chapter was reviewed by E.F.Codd.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A database designed to combine two databases used by the Sales department is a database being designed ________.

Accepted Answer

A) from existing data 
B) as a new systems development project 
C) as a redesign of an existing database 
D) A and B 
E) A,B,and C 
A) from existing data 
B) as a new systems development project 
C) as a redesign of an existing database 
D) A and B 
E) A,B,and C

Question 11

A very popular development technique used by database professionals for database design is known as ________.

Accepted Answer

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

Question 12

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

Accepted Answer

A) file managers 
B) hierarchical models 
C) network models 
D) relational data model 
E) All of the above were predecessors of database processing. 
A) file managers 
B) hierarchical models 
C) network models 
D) relational data model 
E) All of the above were predecessors of database processing.

Question 13

Database professionals use ________ as specific data sources for studies and analyses.

Accepted Answer

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

Question 14

In an Enterprise-class database system,a database application interacts with the DBMS.

Accepted Answer

A) True 
 B)False

Question 15

What are the three types of database design situations?

Accepted Answer

Database designs can be based on (1)exis

Question 16

Data is recorded facts and figures;information is knowledge derived from data.

Accepted Answer

A) True 
 B)False

Question 17

The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database.

Accepted Answer

A) True 
 B)False

Question 18

A database records:

Accepted Answer

A) facts. 
B) figures. 
C) information. 
D) A and B 
E) A,B and C 
A) facts. 
B) figures. 
C) information. 
D) A and B 
E) A,B and C

Question 19

The database management system (DBMS)is responsible for enforcing referential integrity constraints.

Accepted Answer

A) True 
 B)False

Question 20

The industry standard supported by all major DBMSs that allows tables to be joined together is called ________.

Accepted Answer

A) Sequential Query Language (SQL) 
B) Structured Question Language (SQL) 
C) Structured Query Language (SQL) 
D) Relational Question Language (RQL) 
E) Relational Query Language (RQL) 
A) Sequential Query Language (SQL) 
B) Structured Question Language (SQL) 
C) Structured Query Language (SQL) 
D) Relational Question Language (RQL) 
E) Relational Query Language (RQL)

Exam 1: Introduction

The largest databases in e-commerce are the order entry databases.

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

A database system as typically defined can be modified to include CODASYL.

A sales contact manager used by a salesperson is an example of a(n)________.

In an enterprise-class database system,the database application ________.

What components are included in a database?

Microsoft Access is a low-end product intended for individuals and small workgroups.

The 1977 edition of this text contained a chapter on the relational model,and that chapter was reviewed by E.F.Codd.

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

A database designed to combine two databases used by the Sales department is a database being designed ________.

A very popular development technique used by database professionals for database design is known as ________.

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

Database professionals use ________ as specific data sources for studies and analyses.

In an Enterprise-class database system,a database application interacts with the DBMS.

What are the three types of database design situations?

Data is recorded facts and figures;information is knowledge derived from data.

The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database.

A database records:

The database management system (DBMS)is responsible for enforcing referential integrity constraints.

The industry standard supported by all major DBMSs that allows tables to be joined together is called ________.

Introduction to Structured Query Language SQL

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 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters