Question 1

Microsoft Access may use which of the following DBMS engines?

Accepted Answer

A) ADE 
B) SQL Server 
C) Oracle 
D) Both A and B are correct 
A) ADE 
B) SQL Server 
C) Oracle 
D) Both A and B are correct

Question 2

Briefly describe the history of database processing.

Accepted Answer

The predecessor of database processing w

Question 3

Microsoft Access includes ________.

Accepted Answer

A) a DBMS 
B) an application generator 
C) a Web server 
D) Both A and B are correct 
A) a DBMS 
B) an application generator 
C) a Web server 
D) Both A and B are correct

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

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

Question 6

A database is called self-describing because it reduces data duplication.

Accepted Answer

A) True 
 B)False

Question 7

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) enterprise resource planning system 
A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) enterprise resource planning system

Question 8

A Customer Resource Management (CRM)system is an example of a(n)________.

Accepted Answer

A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) digital dashboard 
A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) digital dashboard

Question 9

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

Accepted Answer

The application program is responsible f

Question 10

Which of the following statements is true about Web 2.0?

Accepted Answer

A) It requires the Android Operating System. 
B) It allows users to add content to Web sites. 
C) Twitter and Facebook are examples of Web 2.0 sites. 
D) Both B and C are correct 
A) It requires the Android Operating System. 
B) It allows users to add content to Web sites. 
C) Twitter and Facebook are examples of Web 2.0 sites. 
D) Both B and C are correct

Question 11

This database component is used to maintain database accuracy and enforce data constraints.

Accepted Answer

A) Tables 
B) Metadata 
C) Triggers 
D) Stored procedures 
A) Tables 
B) Metadata 
C) Triggers 
D) Stored procedures

Question 12

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 
A) the user 
B) the database application 
C) the database management system (DBMS) 
D) the database

Question 13

The database management system (DBMS)is responsible for enforcing referential integrity constraints.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

Metadata is data about the structure of

Question 15

For database development,the most important Web-related technology to emerge in recent years is ________.

Accepted Answer

A) FTP 
B) HTTP 
C) XML 
D) OODBMS 
A) FTP 
B) HTTP 
C) XML 
D) OODBMS

Question 16

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 
A) Database Modeling System 
B) Database Management System 
C) Data Business Model System 
D) Relational Model Manager

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

The 1977 edition of this text contained a chapter on the relational model,and that chapter was reviewed by E.F.Codd.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The NoSQL movement should really be called a NoRelational movement.

Accepted Answer

A) True 
 B)False

Exam 1: Introduction

Microsoft Access may use which of the following DBMS engines?

Briefly describe the history of database processing.

Microsoft Access includes ________.

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

The purpose of a database is to ________.

A database is called self-describing because it reduces data duplication.

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

A Customer Resource Management (CRM)system is an example of a(n)________.

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

Which of the following statements is true about Web 2.0?

This database component is used to maintain database accuracy and enforce data constraints.

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

The database management system (DBMS)is responsible for enforcing referential integrity constraints.

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

For database development,the most important Web-related technology to emerge in recent years is ________.

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

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

The 1977 edition of this text contained a chapter on the relational model,and that chapter was reviewed by E.F.Codd.

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

The NoSQL movement should really be called a NoRelational movement.

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