Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Modern microcomputer personal DBMS products ________.

Accepted Answer

A) are supplied by several well-established manufacturers 
B) were essentially made obsolete by Microsoft Access 
C) have poor response time 
D) are not true DBMS products 
E) are really just programming languages with generalized file-processing capabilities 
A) are supplied by several well-established manufacturers 
B) were essentially made obsolete by Microsoft Access 
C) have poor response time 
D) are not true DBMS products 
E) are really just programming languages with generalized file-processing capabilities

Question 3

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

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

Accepted Answer

A) True 
 B)False

Question 5

XML Web services allow database processing to be shared across the Internet.

Accepted Answer

A) True 
 B)False

Question 6

Databases record data in such a way that they can produce information.

Accepted Answer

A) True 
 B)False

Question 7

Applications are computer programs used directly by users.

Accepted Answer

A) True 
 B)False

Question 8

All database applications get and put database data by sending SQL statements to the DBMS.

Accepted Answer

A) True 
 B)False

Question 9

For database development,a challenge to the relational model and the use of SQL.This challenge is known as:

Accepted Answer

A) the Web services movement. 
B) the NoSQL movement. 
C) the SOAP movement. 
D) the NoSOAP movement. 
E) the UDDI movement. 
A) the Web services movement. 
B) the NoSQL movement. 
C) the SOAP movement. 
D) the NoSOAP movement. 
E) the UDDI movement.

Question 10

The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The NoSQL movement should really be called a NoRelational movement.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The DBMS ranked as having the "least power and features" in the text is Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 15

What are the four components of a database system?

Accepted Answer

The four components in a database system

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

What are "referential integrity constraints"? Give an example.

Accepted Answer

A referential integrity constraint is a

Question 19

In database systems,the DBMS enforces rules about which user can perform which action when.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 20

In a database,each row in a spreadsheet has data about a particular instance.

Accepted Answer

A) True 
 B)False

Exam 1: Introduction

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

Modern microcomputer personal DBMS products ________.

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

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

XML Web services allow database processing to be shared across the Internet.

Databases record data in such a way that they can produce information.

Applications are computer programs used directly by users.

All database applications get and put database data by sending SQL statements to the DBMS.

For database development,a challenge to the relational model and the use of SQL.This challenge is known as:

The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database.

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

The NoSQL movement should really be called a NoRelational movement.

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

The DBMS ranked as having the "least power and features" in the text is Microsoft Access.

What are the four components of a database system?

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

A database may contain ________.

What are "referential integrity constraints"? Give an example.

In database systems,the DBMS enforces rules about which user can perform which action when.The rules are known as ________.

In a database,each row in a spreadsheet has data about a particular instance.

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