Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

Database professionals use ________ as specific data sources for studies and analyses.

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

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 7

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 8

In database systems,indexes are held by the database.

Accepted Answer

A) True 
 B)False

Question 9

In database systems,the DBMS ________.

Accepted Answer

A) inserts data 
B) modifies data 
C) reads data 
D) deletes data 
E) All of the above 
A) inserts data 
B) modifies data 
C) reads data 
D) deletes data 
E) All of the above

Question 10

The database management system (DBMS)is responsible for inserting,modifying,reading,and deleting data.

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

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) data reading control 
D) concurrency control 
E) referential integrity constraints 
A) data insertion control 
B) data modification control 
C) data reading control 
D) concurrency control 
E) referential integrity constraints

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

What are the three types of database design situations?

Accepted Answer

Database designs can be based on (1)exis

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The current DBMS engine in Microsoft Access is called ADE.

Accepted Answer

A) True 
 B)False

Question 18

Database design is important,and fortunately it is simple to do.

Accepted Answer

A) True 
 B)False

Question 19

What is "metadata" and how does it relate to the definition of a database?

Accepted Answer

Metadata is data about the structure of

Question 20

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

Exam 1: Introduction

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

The purpose of a database is to:

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

Database professionals use ________ as specific data sources for studies and analyses.

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

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

A database consists of integrated tables,which store ________.

In database systems,indexes are held by the database.

In database systems,the DBMS ________.

The database management system (DBMS)is responsible for inserting,modifying,reading,and deleting data.

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

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

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

What are the three types of database design situations?

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

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

The current DBMS engine in Microsoft Access is called ADE.

Database design is important,and fortunately it is simple to do.

What is "metadata" and how does it relate to the definition of a database?

A database stores:

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