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

What components are included in a database?

Accepted Answer

The database contains user data,metadata

Question 3

The database application is responsible for concurrency control.

Accepted Answer

A) True 
 B)False

Question 4

Enterprise Resource Planning (ERP)is an example of a data mining application.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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. 
E) All of the above. 
A) FTP. 
B) HTTP. 
C) XML. 
D) OODBMS. 
E) All of the above.

Question 9

A database design may be part of a new systems development project.

Accepted Answer

A) True 
 B)False

Question 10

Integrated tables store both data and the relationships among the data.

Accepted Answer

A) True 
 B)False

Question 11

The description of a database's structure that is stored within the database itself is called the "metadata."

Accepted Answer

A) True 
 B)False

Question 12

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 13

A database records:

Accepted Answer

A) facts. 
B) figures. 
C) information. 
D) A and B 
E) A,B,and C 
A) facts. 
B) figures. 
C) information. 
D) A and B 
E) A,B,and C

Question 14

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) Relational Question Language (RQL) 
E) Relational Query Language (RQL) 
A) Sequential Query Language (SQL) 
B) Structured Question Language (SQL) 
C) Structured Query Language (SQL) 
D) Relational Question Language (RQL) 
E) Relational Query Language (RQL)

Question 15

The predecessor(s)of database processing was (were)________.

Accepted Answer

A) file managers 
B) hierarchical models 
C) network models 
D) the relational data model 
E) All of the above were predecessors of database processing. 
A) file managers 
B) hierarchical models 
C) network models 
D) the relational data model 
E) All of the above were predecessors of database processing.

Question 16

A database system as typically defined can be modified to include CODASYL.

Accepted Answer

A) True 
 B)False

Question 17

The relational model was first proposed in 1970 by E.F.Codd at IBM.

Accepted Answer

A) True 
 B)False

Question 18

A database designed to implement requirements for a reporting application needed by the Sales department is a database being designed ________.

Accepted Answer

A) from existing non-database data 
B) as a new systems development project 
C) as a redesign of an existing database 
D) A and B 
E) A,B,and C 
A) from existing non-database data 
B) as a new systems development project 
C) as a redesign of an existing database 
D) A and B 
E) A,B,and C

Question 19

In an enterprise-class database system,________.

Accepted Answer

A) the database application(s)interact(s)with the DBMS 
B) the database application(s)access(es)the database data 
C) the DBMS accesses the database data 
D) A and B 
E) A and C 
A) the database application(s)interact(s)with the DBMS 
B) the database application(s)access(es)the database data 
C) the DBMS accesses the database data 
D) A and B 
E) A and C

Question 20

Microsoft Access is just a DBMS.

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.

What components are included in a database?

The database application is responsible for concurrency control.

Enterprise Resource Planning (ERP)is an example of a data mining application.

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

Microsoft Access may use which of the following DBMS engines?

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

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

A database design may be part of a new systems development project.

Integrated tables store both data and the relationships among the data.

The description of a database's structure that is stored within the database itself is called the "metadata."

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

A database records:

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

The predecessor(s)of database processing was (were)________.

A database system as typically defined can be modified to include CODASYL.

The relational model was first proposed in 1970 by E.F.Codd at IBM.

A database designed to implement requirements for a reporting application needed by the Sales department is a database being designed ________.

In an enterprise-class database system,________.

Microsoft Access is just a DBMS.

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