Question 1

What are the three types of database design situations?

Accepted Answer

Database designs can be based on (1)exis

Question 2

A database stores ________.

Accepted Answer

A) data 
B) relationships 
C) applications 
D) Both A and B are correct 
A) data 
B) relationships 
C) applications 
D) Both A and B are correct

Question 3

Which of the following statements is not true for primary keys in a relational database system?

Accepted Answer

A) They can be used to create relationships between tables. 
B) They must contain numeric data. 
C) They uniquely identify a row in a table. 
D) They can be part of relational integrity constraints. 
A) They can be used to create relationships between tables. 
B) They must contain numeric data. 
C) They uniquely identify a row in a table. 
D) They can be part of relational integrity constraints.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A database system is typically defined as its four components: users,database applications,the DBMS and the databases.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

This database component can be used as part of applications and for administration tasks.

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

In an Enterprise-class database system,a database application interacts with the DBMS.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Business organizations have resisted adopting object-oriented database management systems because ________.

Accepted Answer

A) the cost of purchasing OODBMS packages is prohibitively high 
B) the cost of converting data from relational databases to OODBMSs is too high 
C) most large organizations have older applications that are not based on object oriented programming 
D) Both B and C are correct 
A) the cost of purchasing OODBMS packages is prohibitively high 
B) the cost of converting data from relational databases to OODBMSs is too high 
C) most large organizations have older applications that are not based on object oriented programming 
D) Both B and C are correct

Question 14

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

Accepted Answer

A) referential integrity constraints 
B) data modification control 
C) data reading control 
D) concurrency control 
A) referential integrity constraints 
B) data modification control 
C) data reading control 
D) concurrency control

Question 15

A database designed using spreadsheets from the Sales department is a database being designed ________.

Accepted Answer

A) from existing data 
B) as a new systems development project 
C) as a redesign of an existing database 
D) as a NoSQL database 
A) from existing data 
B) as a new systems development project 
C) as a redesign of an existing database 
D) as a NoSQL database

Question 16

In Microsoft Access,you can use ODBC to connect to SQL Server in place of the ADE database engine.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Applications usually write data directly to the database.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

What components are included in a database?

Accepted Answer

The database contains user data,metadata

Exam 1: Introduction

What are the three types of database design situations?

A database stores ________.

Which of the following statements is not true for primary keys in a relational database system?

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

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

A database system is typically defined as its four components: users,database applications,the DBMS and the databases.

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

This database component can be used as part of applications and for administration tasks.

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

Modern microcomputer personal DBMS products ________.

In an Enterprise-class database system,a database application interacts with the DBMS.

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

Business organizations have resisted adopting object-oriented database management systems because ________.

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

A database designed using spreadsheets from the Sales department is a database being designed ________.

In Microsoft Access,you can use ODBC to connect to SQL Server in place of the ADE database engine.

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

Applications usually write data directly to the database.

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

What components are included in a database?

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