Question 1

In an Enterprise-class database system,business users interact directly with the DBMS,which directly accesses the database data.

Accepted Answer

A) True 
 B)False

Question 2

The database application is responsible for concurrency control.

Accepted Answer

A) True 
 B)False

Question 3

Microsoft Access may use which of the following DBMS engines?

Accepted Answer

A) ADE 
B) SQL Server 
C) Oracle 
D) A and B 
E) A,B and C 
A) ADE 
B) SQL Server 
C) Oracle 
D) A and B 
E) A,B and C

Question 4

What are the four components of a database system?

Accepted Answer

The four components in a database system

Question 5

Bill Gates has said that "XML is the lingua-franca of the Internet Age."

Accepted Answer

A) True 
 B)False

Question 6

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

Paradox is the only major survivor of the "bloodbath of PC DBMS products."

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

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

For database development,a challenge to the relational model and the use of SQL has recently developed.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 14

Which of the following are basic components of an enterprise-class database system?

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 15

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

Accepted Answer

A database is considered self-describing

Question 16

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 17

Modern microcomputer personal DBMS products ________.

Accepted Answer

A) are supplied by several well-established manufacturers 
B) were essentially killed off 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 killed off 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 18

Referential integrity constraints are rules about what data values are allowed in certain columns.

Accepted Answer

A) True 
 B)False

Question 19

In database systems,the DBMS enforces rules about which data can be written in certain columns.The rules are know 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

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

Accepted Answer

A) True 
 B)False

Exam 1: Introduction

In an Enterprise-class database system,business users interact directly with the DBMS,which directly accesses the database data.

The database application is responsible for concurrency control.

Microsoft Access may use which of the following DBMS engines?

What are the four components of a database system?

Bill Gates has said that "XML is the lingua-franca of the Internet Age."

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

Paradox is the only major survivor of the "bloodbath of PC DBMS products."

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

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

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

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

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

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

Which of the following are basic components of an enterprise-class database system?

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

In database systems,the DBMS ________.

Modern microcomputer personal DBMS products ________.

Referential integrity constraints are rules about what data values are allowed in certain columns.

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

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

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