Deck 1: Introduction

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

In database systems,indexes are held by the database.

Question 5

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

Question 6

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

Question 7

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

Question 8

In every database,not just the databases discussed in this book,table names are capitalized.

Question 9

Applications are computer programs used directly by users.

Question 10

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

Question 11

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

Question 12

Small databases typically have simple structures.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

Sequenced Query Language (SQL)is an internationally recognized standard language that is understood by all commercial database management system products.

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

The database application is responsible for concurrency control.

Question 25

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

Question 26

Microsoft Access is just a DBMS.

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

The current DBMS engine in Microsoft Access is called ADE.

Question 41

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

Question 42

The purpose of a database is to:

A)help people keep track of things.
B)store data in tables.
C)create tables of rows and columns.
D)maintain data on different things in different tables.
E)All of the above.

Question 43

Twitter and Facebook use NoSQL databases.

Question 44

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

Question 45

A sales contact manager used by a salesperson is an example of a(n)________.

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 46

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

Question 47

Information systems that stored groups of records in separate files were called file processing systems.

Question 48

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

Question 49

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

Question 50

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

Question 51

The NoSQL movement should really be called a NoRelational movement.

Question 52

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

Question 53

A database stores:

A)data.
B)relationships.
C)metadata.
D)A and B
E)A,B,and C

Question 54

A database records:

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

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 59

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

Question 60

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

Question 61

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

A)from existing 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 62

In an enterprise-class database system,________.

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 63

An online drugstore such as Drugstore.com is an example of a(n)________.

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 64

A database consists of integrated tables,which store ________.

A)data
B)relationships among the data
C)forms
D)A and B
E)All of the above

Question 65

In database systems,the database ________.

A)holds user data
B)holds metadata
C)holds indexes
D)holds stored procedures
E)All of the above

Question 66

In an enterprise-class database system,reports are created by ________.

A)the user
B)the database application
C)the database management system (DBMS)
D)the database
E)All of the above

Question 67

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

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 68

A database is considered "self-describing" because ________.

A)all the users' data is in one place
B)it reduces data duplication
C)it contains a description of its own structure
D)it contains a listing of all the programs that use it
E)All of the above

Question 69

A program whose job is to create,process and administer databases is called a ________.

A)Database Modeling System
B)Database Management System
C)Data Business Model System
D)Relational Model Manager
E)Data Business Management Service

Question 70

In an enterprise-class database system,the database application ________.

A)creates queries
B)creates forms
C)creates reports
D)A and B
E)B and C

Question 71

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

A)The user
B)The database application
C)The database management system (DBMS)
D)The database
E)All of the above

Question 72

Microsoft Access includes:

A)a DBMS.
B)an application generator.
C)a Web server.
D)A and B
E)A,B,and C

Question 73

Microsoft Access may use which of the following DBMS engines?

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

Question 74

A database may be designed ________.

A)from existing 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 75

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

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 76

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

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

Question 77

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

A)from existing 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 78

In database systems,the DBMS ________.

A)inserts data
B)modifies data
C)reads data
D)deletes data
E)All of the above

Question 79

A database may contain ________.

A)tables
B)metadata
C)triggers
D)stored procedures
E)All of the above

Question 80

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

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