Quiz Jan 21 Flashcards by Hannah Feragen

In a database, each table stores data about a different type of thing

True

How well did you know this?

Not at all

Perfectly

The purpose of a data base is to help people keep track of things

True

How well did you know this?

Not at all

Perfectly

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

False

How well did you know this?

Not at all

Perfectly

In every database, not just the database discussed in this book, tables names are capitalized

False

How well did you know this?

Not at all

Perfectly

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

True

How well did you know this?

Not at all

Perfectly

Data is recorded facts figures; information is knowledge derived from data

True

How well did you know this?

Not at all

Perfectly

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

True

How well did you know this?

Not at all

Perfectly

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

False

How well did you know this?

Not at all

Perfectly

Databases are a key component of e-commerce order entry, billing, shipping and customer support

True

How well did you know this?

Not at all

Perfectly

The largest database in e-commerce are the order entry databases

False

How well did you know this?

Not at all

Perfectly

The e-commerce companies use Web activity database to determine which items on a Web page are popular and successful

True

How well did you know this?

Not at all

Perfectly

Small databases typical have simple structures

False

How well did you know this?

Not at all

Perfectly

A database system is typical defined as the four components users, database applications, the DBMS and databases

True

How well did you know this?

Not at all

Perfectly

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

False

How well did you know this?

Not at all

Perfectly

Applications are computer programs used directly by users

True

How well did you know this?

Not at all

Perfectly

In a database system, applications write data to the database

False

How well did you know this?

Not at all

Perfectly

Secondary Query Language (SQL) is an international recognized standard language that is understood by all commercial database management system products

False

How well did you know this?

Not at all

Perfectly

In database systems, indexes are held by the database

True

How well did you know this?

Not at all

Perfectly

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

True

How well did you know this?

Not at all

Perfectly

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

True

How well did you know this?

Not at all

Perfectly

The database application is responsible for concurrency control

False

How well did you know this?

Not at all

Perfectly

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

True

How well did you know this?

Not at all

Perfectly

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

True

How well did you know this?

Not at all

Perfectly

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

False

How well did you know this?

Not at all

Perfectly

Integrated tables store both data and the relationship among the data

True

Microsoft Access is just a DBMS

False

Microsoft Access is a low-end product intended for individuals and small workgroups

True

The current DBMS engine in Microsoft Access is called ADE

True

In Microsoft Access, you can use the Oracle DBMS in place of the ADE DBMS

False

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

True

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

False

The description of the database's structure that stores within the database itself is called the "metadata"

True

In a database processing system, indexes are held by the database management system (DBMS)

True

The purpose of a database is to:

Help people keep track of things

A database stores

Data, relationship and metadata

A database records:

Facts and figures

A sales contact manager used by a salesperson is an example of a

Single -user database application

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

Multiuser database application

An online drugstore such as Drugstore.com is an example of a

E-commerce database application

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

Structured Query Language (SQL)

A program whose job it is to create, process and administer databases is called the

Database Management System

Microsoft Access includes

A DBMS and an application generator

Microsoft Access may use which of the following DBMS engines?

ADE and SQL Server

In database systems, the DBMS

Inserts data, modifies data, deletes data

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

Referential integrity constraints

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

Referential integrity constraints

A database is considered "self-describing" because

In contains a description of its own structure

A database consists of integrated tables, which store

Data and relationships among the data

In database systems, the database

Holds user data, holds metadata, holds indexes, holds stored procedures

A database may contain

Tables, megadata, triggers, stored procedures

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

True

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

False

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

False

The DBMS ranked as having the "most power and features" in the text us IBM's DB2

False

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

False

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

True

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

True

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

False

A database deaf in may be a new systems development project

True

A database design is rarely a redesign of an existing database

False

Information systems that stored groups if records in separate files were called the file processing systems

True

Data Language/I (DL/I) structured data relationships as a tree structure

True

The CODASYL DBTG mode structured data relationships as a tree structure

False

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

True

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

True

dBase was the first PC-based DBMS to implement true relational algebra on a PC

False

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

False

Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high

False

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

True

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

True

The NoSQL movement should really be called a NoRelational Movement

True

Twitter and Facebook use NoSQL databases

True

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

The user, the database application, the database management system (DBMS), the database

In an enterprise-class database system

The database application(s) interact(s) with the DBMS, and the DBMS accesses the database data

In an enterprise-class database system, the database application

Creates forums, creates reports

In dan enterprise-class database system, reports are created by

The database application

A database may be designed

From existing data, as a new systems development project, as a redesign of an existing database

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

From existing data

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

As a new systems development project

A database designed to combine two databases used by the Sales department is a database being deigned

As a redesign of an existing database

Database professionals use _____ as specific data sources for studies and analyses

Data marts

Database professionals use a set of principles called ____ to guide and assess database design

Normalization

A very popular development technique used by database professionals for database design is known as

Entity-relationship data modeling

A very popular development technique is used. Y database professionals to adopt a database design to a new or changing requirement is know as

Data migration

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

File managers

The relational model

Was first proposed in 1970, was developed by E.F. Codd, was developed at IBM, ears ultra in the DBMS product DB2

Modern microcomputer personal DBMS products

We're essentially killed off by Microsoft Access

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

The cost of converting data from relational databases to OODBMSs is too high, most large organizations have older applications that are not based on object orientated programming

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

XML

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

The SOAP movement