Brainscape's Knowledge GenomeTM

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


See full index

INSY 3304 | Exam 1 | Fall 2020 > Chapter 1-2 > Flashcards

Chapter 1-2 Flashcards

1
Q

A noun in a business rule translates to a(n) _____ in the data model.

A) relationship
B) entity
C) constraint
D) attribute

A

B) entity

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

_____ data exist in the format in which they were collected.

a) Unstructured
b) Historical
c) Structured
d) Semistructured

A

a) Unstructured

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

A verb associating two nouns in a business rule translates to a(n) _____ in the data model.

a) relationship
b) attribute
c) entity
d) constraint

A

a) relationship

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

Accurate, relevant, and timely information is the key to ____.

a) good decision making
b) knowledge
c) data management
d) understanding

A

a) good decision making

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

Even when a good database blueprint is available, an applications programmer’s view of the data should match that of the manager and the end user.

A) True
B) False

A

B) False

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

The _____ model is the end users’ view of the data environment.

A) conceptual
B) abstract
C) internal
D) external

A

D) external

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

A(n) _____ is anything about which data are to be collected and stored.

A) relationship
B) constraint
C) entity
D) attribute

A

C) entity

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

_____ provide a description of the data characteristics and the set of relationships that link the data found within the database.

A) Queries
B) End-user data
C) Schemas
D) Metadata

A

D) Metadata

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

The only way to access the data in a database is through the DBMS.

a) true
b) false

A

a) true

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

The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

a) database system
b) transaction
c) management system
d) structured data

A

a) database system

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

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.

A) True
B) False

A

A) True

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

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.

A) True
B) False

A

A) True

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

_____ data exist in a format that does not lend itself to processing that yields information.

A) Unstructured
B) Historical
C) Structured
D) Semistructured

A

A) Unstructured

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

The relational data model was developed in the _____.

a) 1990s
b) 1970s
c) 1980s
d) 1960s

A

b) 1970s

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

Which of the following is true of NoSQL databases?

a) They are geared toward transaction consistency rather than performance.
b) They do not support distributed database architectures.
c) They do not support very large amounts of sparse data.
d) They are not based on the relational model.

A

d) They are not based on the relational model.

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

A(n) _____ database is used by an organization and supports many users across many departments.

a) desktop
b) enterprise
c) workgroup
d) transactional

A

b) enterprise

17
Q

An implementation-ready data model needn’t necessarily contain enforceable rules to guarantee the integrity of the data.

A) True
B) False

A

B) False

18
Q

Data and information are essentially the same thing.

A) True
B) False

A

B) False

19
Q

Data is said to be verifiable if:

a) the data is obtained from trusted sources.
b) the data is stored in different places within the database.
c) the data always yields consistent results.
d) the data cannot be changed or manipulated.

A

c) the data always yields consistent results.

20
Q

Data processing can be as simple as organizing data to reveal patterns.

A) True
B) False

A

A) True

21
Q

The object-oriented data model was developed in the _____.

a) 1970s
b) 1990s
c) 1980s
d) 1960s

A

c) 1980s

22
Q

Which of the following types of HDFS nodes stores all the metadata about a file system?

a) Name node
b) Data node
c) Client node
d) Map node

A

a) Name node

23
Q

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.

A) True
B) False

A

B) False

24
Q

A desktop database is a _____ database.

a) workgroup
b) distributed
c) multiuser
d) single-user

A

d) single-user

25
Q

Which of the following is true of spreadsheet applications?

a) They do not allow manipulation of data once entered.
b) They provide enhanced security and robust data sharing features.
c) They enhance the user’s ability to understand the data.
d) They are a better alternative to databases.

A

c) They enhance the user’s ability to understand the data.

INSY 3304 | Exam 1 | Fall 2020 (5 decks)

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