Question 1

Briefly describe the history of database processing.

Accepted Answer

The predecessor of database processing w

Question 2

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 3

In database systems,the database ________.

Accepted Answer

A) holds user data 
B) holds metadata 
C) holds indexes 
D) holds stored procedures 
E) All of the above 
A) holds user data 
B) holds metadata 
C) holds indexes 
D) holds stored procedures 
E) All of the above

Question 4

Why do we say a database is "self-describing" and why is this an advantage?

Accepted Answer

A database is considered self-describing

Question 5

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

Accepted Answer

The DBMS creates the database and the ta

Question 6

In a database processing system,indexes are held by the database management system (DBMS).

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Twitter and Facebook use NoSQL databases.

Accepted Answer

A) True 
 B)False

Question 10

What is the purpose of a database,and how does the database accomplish this purpose?

Accepted Answer

The purpose of a database is to help peo

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Business organizations have resisted adopting object-oriented database management systems because ________.

Accepted Answer

A) object-oriented programming uses simplified data structures that fit easily into relational databases 
B) the cost of purchasing OODBMS packages is prohibitively high 
C) the cost of converting data from relational databases to OODBMSs is too high 
D) most large organizations have older applications that are not based on object oriented programming 
E) C and D 
A) object-oriented programming uses simplified data structures that fit easily into relational databases 
B) the cost of purchasing OODBMS packages is prohibitively high 
C) the cost of converting data from relational databases to OODBMSs is too high 
D) most large organizations have older applications that are not based on object oriented programming 
E) C and D

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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) 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 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which of the following are basic components of an enterprise-class database system?

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

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 19

The purpose of a database is to help people keep track of things.

Accepted Answer

A) True 
 B)False

Question 20

In Microsoft Access,you can use the Oracle DBMS in place of the ADE DBMS.

Accepted Answer

A) True 
 B)False

Exam 1: Introduction

Briefly describe the history of database processing.

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

In database systems,the database ________.

Why do we say a database is "self-describing" and why is this an advantage?

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

In a database processing system,indexes are held by the database management system (DBMS).

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

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

Twitter and Facebook use NoSQL databases.

What is the purpose of a database,and how does the database accomplish this purpose?

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

Business organizations have resisted adopting object-oriented database management systems because ________.

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

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

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

Which of the following are basic components of an enterprise-class database system?

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

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

The purpose of a database is to help people keep track of things.

In Microsoft Access,you can use the Oracle DBMS in place of the ADE DBMS.

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