Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high.

Accepted Answer

A) True 
 B)False

Question 4

In database systems,indexes are held by the database.

Accepted Answer

A) True 
 B)False

Question 5

The current DBMS engine in Microsoft Access is called ADE.

Accepted Answer

A) True 
 B)False

Question 6

A database design may be a new systems development project.

Accepted Answer

A) True 
 B)False

Question 7

The CODASYL DBTG mode structured data relationships as a tree structure.

Accepted Answer

A) True 
 B)False

Question 8

The NoSQL movement should really be called a NoRelational movement.

Accepted Answer

A) True 
 B)False

Question 9

Integrated tables store both data and the relationships among the data.

Accepted Answer

A) True 
 B)False

Question 10

Small databases typically have simple structures.

Accepted Answer

A) True 
 B)False

Question 11

A database designed to implement requirements for a reporting application needed by the Sales department is a database being designed ________.

Accepted Answer

A) from existing non-database 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 non-database 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 12

In a database system,applications write data to the database.

Accepted Answer

A) True 
 B)False

Question 13

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 14

A database may contain ________.

Accepted Answer

A) tables 
B) metadata 
C) triggers 
D) stored procedures 
E) All of the above. 
A) tables 
B) metadata 
C) triggers 
D) stored procedures 
E) All of the above.

Question 15

Sequenced Query Language (SQL)is an internationally recognized standard language that is understood by all commercial database management system products.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server.

Accepted Answer

A) True 
 B)False

Question 19

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 20

An online drugstore such as Drugstore.com 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

Exam 1: Introduction

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

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

Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high.

In database systems,indexes are held by the database.

The current DBMS engine in Microsoft Access is called ADE.

A database design may be a new systems development project.

The CODASYL DBTG mode structured data relationships as a tree structure.

The NoSQL movement should really be called a NoRelational movement.

Integrated tables store both data and the relationships among the data.

Small databases typically have simple structures.

A database designed to implement requirements for a reporting application needed by the Sales department is a database being designed ________.

In a database system,applications write data to the database.

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 may contain ________.

Sequenced Query Language (SQL)is an internationally recognized standard language that is understood by all commercial database management system products.

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

In database systems,the database ________.

The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server.

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

An online drugstore such as Drugstore.com is an example of a(n)________.

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