Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ISE 224 > Quiz Jan 21 > Flashcards

Quiz Jan 21 Flashcards

0
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
1
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Small databases typical have simple structures

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Applications are computer programs used directly by users

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

In a database system, applications write data to the database

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

In database systems, indexes are held by the database

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

The database application is responsible for concurrency control

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Integrated tables store both data and the relationship among the data

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Microsoft Access is just a DBMS

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

The current DBMS engine in Microsoft Access is called ADE

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

The description of the database’s structure that stores within the database itself is called the “metadata”

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

The purpose of a database is to:

A

Help people keep track of things

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

A database stores

A

Data, relationship and metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

A database records:

A

Facts and figures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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

A

Single -user database application

37
Q

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

A

Multiuser database application

38
Q

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

A

E-commerce database application

39
Q

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

A

Structured Query Language (SQL)

40
Q

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

A

Database Management System

41
Q

Microsoft Access includes

A

A DBMS and an application generator

42
Q

Microsoft Access may use which of the following DBMS engines?

A

ADE and SQL Server

43
Q

In database systems, the DBMS

A

Inserts data, modifies data, deletes data

44
Q

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

A

Referential integrity constraints

45
Q

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

A

Referential integrity constraints

46
Q

A database is considered “self-describing” because

A

In contains a description of its own structure

47
Q

A database consists of integrated tables, which store

A

Data and relationships among the data

48
Q

In database systems, the database

A

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

49
Q

A database may contain

A

Tables, megadata, triggers, stored procedures

50
Q

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

51
Q

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

52
Q

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

53
Q

The DBMS ranked as having the “most power and features” in the text us IBM’s DB2

54
Q

The DBMS ranked as being the “easiest to use” in the text is Microsoft’s SQL Server

55
Q

The DBMS ranked as being the “most difficult to use” in the text in Oracle Corporation’s Oracle Database

56
Q

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

57
Q

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

58
Q

A database deaf in may be a new systems development project

59
Q

A database design is rarely a redesign of an existing database

60
Q

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

61
Q

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

62
Q

The CODASYL DBTG mode structured data relationships as a tree structure

63
Q

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

64
Q

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

65
Q

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

66
Q

Paradox is the only major survivor of the “bloodbath of PC DBMS products”

67
Q

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

68
Q

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

69
Q

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

70
Q

The NoSQL movement should really be called a NoRelational Movement

71
Q

Twitter and Facebook use NoSQL databases

72
Q

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

A

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

73
Q

In an enterprise-class database system

A

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

74
Q

In an enterprise-class database system, the database application

A

Creates forums, creates reports

75
Q

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

A

The database application

76
Q

A database may be designed

A

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

77
Q

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

A

From existing data

78
Q

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

A

As a new systems development project

79
Q

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

A

As a redesign of an existing database

80
Q

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

A

Data marts

81
Q

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

A

Normalization

82
Q

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

A

Entity-relationship data modeling

83
Q

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

A

Data migration

84
Q

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

A

File managers

85
Q

The relational model

A

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

86
Q

Modern microcomputer personal DBMS products

A

We’re essentially killed off by Microsoft Access

87
Q

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

A

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

88
Q

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

89
Q

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

A

The SOAP movement

ISE 224 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions