Question 1

Bill Gates has said that "XML is the lingua-franca of the Internet Age."

Accepted Answer

A) True 
 B)False  True

Question 2

The relational model ________.

Accepted Answer

A) was first proposed in 1970 
B) was developed by E.F.Codd 
C) was developed at IBM 
D) resulted in the DBMS product DB2 
E) All of the above 
A) was first proposed in 1970 
B) was developed by E.F.Codd 
C) was developed at IBM 
D) resulted in the DBMS product DB2 
E) All of the above E

Question 3

Small databases typically have simple structures.

Accepted Answer

A) True 
 B)False  False

Question 4

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 5

A database may be 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 6

A database shows data in tables and the relationships among the rows in those tables.

Accepted Answer

A) True 
 B)False

Question 7

A database designed using spreadsheets from 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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

The DBMS ranked as having the "most power and features" in the text is IBM's DB2.

Accepted Answer

A) True 
 B)False

Question 12

A database is a self-describing collection of non-integrated tables.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

Information systems that stored groups of records in separate files were called file processing systems.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Microsoft Access includes:

Accepted Answer

A) a DBMS. 
B) an application generator. 
C) a Web server. 
D) A and B 
E) A,B,and C 
A) a DBMS. 
B) an application generator. 
C) a Web server. 
D) A and B 
E) A,B,and C

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Briefly describe the function of an application program in a database system.

Accepted Answer

The application program is responsible f

Question 20

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

Exam 1: Introduction

Bill Gates has said that "XML is the lingua-franca of the Internet Age."

The relational model ________.

Small databases typically have simple structures.

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

A database may be designed ________.

A database shows data in tables and the relationships among the rows in those tables.

A database designed using spreadsheets from the Sales department is a database being designed ________.

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

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

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

The DBMS ranked as having the "most power and features" in the text is IBM's DB2.

A database is a self-describing collection of non-integrated tables.

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

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

Information systems that stored groups of records in separate files were called file processing systems.

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

Microsoft Access includes:

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

Briefly describe the function of an application program in a database system.

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

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

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 Eclipse PDT

Business Intelligence Systems

Filters