Question 1

The largest databases in e-commerce are the order entry databases.

Accepted Answer

A) True 
 B)False

Question 2

The industry standard supported by all major DBMSs that allows tables to be joined together is called ________.

Accepted Answer

A) Sequential Query Language (SQL) 
B) Structured Question Language (SQL) 
C) Structured Query Language (SQL) 
D) Standard Question Language (SQL) 
A) Sequential Query Language (SQL) 
B) Structured Question Language (SQL) 
C) Structured Query Language (SQL) 
D) Standard Question Language (SQL)

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

A database consists of integrated tables,which store ________.

Accepted Answer

A) reports 
B) data and relationships among the data 
C) forms 
D) Both A and C are correct 
A) reports 
B) data and relationships among the data 
C) forms 
D) Both A and C are correct

Question 6

In an Enterprise-class database system,a database application accesses the database data.

Accepted Answer

A) True 
 B)False

Question 7

Microsoft Access is a low-end product intended for individuals and small workgroups.

Accepted Answer

A) True 
 B)False

Question 8

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

Question 9

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) Both A and B are correct 
A) from existing data 
B) as a new systems development project 
C) as a redesign of an existing database 
D) Both A and B are correct

Question 10

Which of the following is not an XML Web service standard?

Accepted Answer

A) SOAP 
B) WSDL 
C) Ethernet 
D) UDDI 
A) SOAP 
B) WSDL 
C) Ethernet 
D) UDDI

Question 11

dBase was the first PC-based DBMS to implement true relational algebra on a PC.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

In database systems,the DBMS enforces rules about which data can be written in certain columns.The rules are known as ________.

Accepted Answer

A) data insertion control 
B) data modification control 
C) concurrency control 
D) referential integrity constraints 
A) data insertion control 
B) data modification control 
C) concurrency control 
D) referential integrity constraints

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which statement is not true about the relational model?

Accepted Answer

A) It was first proposed in 1970. 
B) It was developed by E.F.Codd. 
C) It was developed at Oracle. 
D) It resulted in the DBMS product DB2. 
A) It was first proposed in 1970. 
B) It was developed by E.F.Codd. 
C) It was developed at Oracle. 
D) It resulted in the DBMS product DB2.

Question 17

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) data mining application 
A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) data mining application

Question 18

A database design is rarely a redesign of an existing database.

Accepted Answer

A) True 
 B)False

Question 19

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 20

A database management system (DBMS)creates,processes and administers databases.

Accepted Answer

A) True 
 B)False

Exam 1: Introduction

The largest databases in e-commerce are the order entry databases.

The industry standard supported by all major DBMSs that allows tables to be joined together is called ________.

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

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

A database consists of integrated tables,which store ________.

In an Enterprise-class database system,a database application accesses the database data.

Microsoft Access is a low-end product intended for individuals and small workgroups.

A database is considered self-describing because ________.

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

Which of the following is not an XML Web service standard?

dBase was the first PC-based DBMS to implement true relational algebra on a PC.

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

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

In database systems,the DBMS enforces rules about which data can be written in certain columns.The rules are known as ________.

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

Which statement is not true about the relational model?

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

A database design is rarely a redesign of an existing database.

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

A database management system (DBMS)creates,processes and administers databases.

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters