Question 1

Microsoft Access is just a DBMS.

Accepted Answer

A) True 
 B)False

Question 2

A database system is typically defined as the four components users,database applications,the DBMS and the databases.

Accepted Answer

A) True 
 B)False

Question 3

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.

Question 4

A database stores:

Accepted Answer

A) data. 
B) relationships. 
C) metadata. 
D) A and B 
E) A,B and C 
A) data. 
B) relationships. 
C) metadata. 
D) A and B 
E) A,B and C

Question 5

In an enterprise-class database system,reports are created by ________.

Accepted Answer

A) the user 
B) the database application 
C) the database management system (DBMS) 
D) the database 
E) All of the above. 
A) the user 
B) the database application 
C) the database management system (DBMS) 
D) the database 
E) All of the above.

Question 6

A database consists of integrated tables,which store ________.

Accepted Answer

A) data 
B) relationships among the data 
C) forms 
D) A and B 
E) All of the above. 
A) data 
B) relationships among the data 
C) forms 
D) A and B 
E) All of the above.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In every database,not just the databases discussed in this book,table names are capitalized.

Accepted Answer

A) True 
 B)False

Question 9

A database is considered "self-describing" because ________.

Accepted Answer

A) all the users' data is in one place 
B) it reduces data duplication 
C) it contains a description of its own structure 
D) it contains a listing of all the programs that use it 
E) All of the above. 
A) all the users' data is in one place 
B) it reduces data duplication 
C) it contains a description of its own structure 
D) it contains a listing of all the programs that use it 
E) All of the above.

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Applications are computer programs used directly by users.

Accepted Answer

A) True 
 B)False

Question 12

The e-commerce companies use Web activity database to determine which items on a Web page are popular and successful.

Accepted Answer

A) True 
 B)False

Question 13

The purpose of a database is to:

Accepted Answer

A) help people keep track of things. 
B) store data in tables. 
C) create tables of rows and columns. 
D) maintain data on different things in different tables. 
E) All of the above. 
A) help people keep track of things. 
B) store data in tables. 
C) create tables of rows and columns. 
D) maintain data on different things in different tables. 
E) All of the above.

Question 14

What are "referential integrity constraints"? Give an example.

Accepted Answer

A referential integrity constraint is a

Question 15

A program whose job is to create,process and administer databases is called the ________.

Accepted Answer

A) Database Modeling System 
B) Database Management System 
C) Data Business Model System 
D) Relational Model Manager 
E) Data Business Management Service 
A) Database Modeling System 
B) Database Management System 
C) Data Business Model System 
D) Relational Model Manager 
E) Data Business Management Service

Question 16

The relational model was first proposed in 1970 by E.F.Codd at IBM.

Accepted Answer

A) True 
 B)False

Question 17

Briefly describe the function of the DBMS in a database system.

Accepted Answer

The DBMS creates the database and the ta

Question 18

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

Accepted Answer

The application program is responsible f

Question 19

Data Language/I (DL/I)structured data relationships as a tree structure.

Accepted Answer

A) True 
 B)False

Question 20

Twitter and Facebook use NoSQL databases.

Accepted Answer

A) True 
 B)False

Exam 1: Introduction

Microsoft Access is just a DBMS.

A database system is typically defined as the four components users,database applications,the DBMS and the databases.

The relational model ________.

A database stores:

In an enterprise-class database system,reports are created by ________.

A database consists of integrated tables,which store ________.

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

In every database,not just the databases discussed in this book,table names are capitalized.

A database is considered "self-describing" because ________.

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

Applications are computer programs used directly by users.

The e-commerce companies use Web activity database to determine which items on a Web page are popular and successful.

The purpose of a database is to:

What are "referential integrity constraints"? Give an example.

A program whose job is to create,process and administer databases is called the ________.

The relational model was first proposed in 1970 by E.F.Codd at IBM.

Briefly describe the function of the DBMS in a database system.

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

Data Language/I (DL/I)structured data relationships as a tree structure.

Twitter and Facebook use NoSQL databases.

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