Deck 1: Introduction

Question 1

Applications usually write data directly to the database.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

Small databases typically have simple structures.

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

In database systems,indexes are held in the database.

Question 15

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

Question 16

Like a database table,a spreadsheet has rows and columns.

Question 17

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

Question 18

Applications are computer programs used directly by users.

Question 19

Databases based on the CODASYL standard are based on the network data model.

Question 20

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

Question 21

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

Question 22

Indexes are data structures that speed searching of database data.

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

The database application is responsible for concurrency control.

Question 30

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

Question 31

Microsoft Access is just a DBMS.

Question 32

The current DBMS engine in Microsoft Access is called ADE.

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

Which of the following statements is true about Web 2.0?

A)It requires the Android Operating System.
B)It allows users to add content to Web sites.
C)Twitter and Facebook are examples of Web 2.0 sites.
D)Both B and C are correct

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

Question 43

Twitter and Facebook use NoSQL databases.

Question 44

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

Question 45

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

Question 46

Each row in a database table is also known as a record.

Question 47

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)digital dashboard

Question 48

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

Question 49

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

Question 50

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)data mining application

Question 51

A database stores ________.

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

The NoSQL movement should really be called a NoRelational movement.

Question 59

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

Question 60

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

Question 61

Microsoft Access may use which of the following DBMS engines?

A)ADE
B)SQL Server
C)Oracle
D)Both A and B are correct

Question 62

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)Both A and B are correct

Question 63

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

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

Question 64

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

Question 65

This database component is used to maintain database accuracy and enforce data constraints.

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

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

Question 67

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

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

Question 68

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

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 69

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)enterprise resource planning system

Question 70

Microsoft Access includes ________.

A)a DBMS
B)an application generator
C)a Web server
D)Both A and B are correct

Question 71

Which of the following statements is not true about client-server architecture?

A)The client initiates a request.
B)The server is usually a tablet or smartphone.
C)The server usually runs the DBMS on it.
D)Most Web applications are supported by client-server.

Question 72

Which of the following database systems is not enterprise-class?

A)Microsoft SQL Server
B)Microsoft Access
C)Oracle Database
D)IBM DB2

Question 73

Which of the following statements is not true for an enterprise-class database system?

A)The database application(s)interact(s)with the DBMS.
B)The database application(s)directly access(es)the database data.
C)The DBMS accesses the database data.
D)The application generates SQL statements.

Question 74

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

Question 75

A database consists of integrated tables,which store ________.

A)reports
B)data and relationships among the data
C)forms
D)Both A and C are correct

Question 76

Which of the following is not an XML Web service standard?

A)SOAP
B)WSDL
C)Ethernet
D)UDDI

Question 77

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)Standard Question Language (SQL)

Question 78

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)Both A and B are correct

Question 79

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)as a NoSQL database

Question 80

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)concurrency control
D)referential integrity constraints