Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The application program is responsible f...

Question 3

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.

Question 4

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 5

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 6

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.

Question 7

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.

Question 8

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.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A database stores:

Accepted Answer

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

Question 11

Microsoft Access is just a DBMS.

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 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.

Question 14

Applications are computer programs used directly by users.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A referential integrity constraint is a ...

Question 16

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

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

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

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

Twitter and Facebook use NoSQL databases.

Correct AnswerverifiedShow Answer

The relational model ________.

Correct AnswerverifiedShow Answer

A database stores:

Correct AnswerverifiedShow Answer

The purpose of a database is to:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe application program is responsible f...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Microsoft Access is just a DBMS.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA referential integrity constraint is a ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Applications are computer programs used directly by users.

Correct AnswerverifiedShow Answer

A database consists of integrated tables,which store ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe DBMS creates the database and the ta...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The application program is responsible f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A referential integrity constraint is a ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The DBMS creates the database and the ta...
View Answer

Correct Answer
verified