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 > Additional Questions from Test Bank > Flashcards

Additional Questions from Test Bank Flashcards

1
Q

The database structure in a DBMS is stored as a _____.

A. collection of queries
B. collection of files
C. single file
D. set of key/value pairs

A

B. collection of files

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

An XML database supports the storage and management of _____ XML data.

A. fullystructured
B. multistructured
C. structured
D. semistructured

A

D. semistructured

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

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.

A. True
B. False

A

B. False

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

The hierarchical model is software-independent.

A. True
B. False

A

B. False

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

A data warehouse can store data derived from many sources.

A. True
B. False

A

A. True

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

In Chen notation, entities and relationships have to be oriented horizontally; not vertically.

A. True
B. False

A

B. False

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

Data is the result of processing raw facts to reveal its meaning.

A. True
B. False

A

B. False

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

VMS/VSAM is an example of the _____.

A. XML data model
B. relational data model
C. hierarchical model
D. file system data model

A

D. file system data model

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

A(n) _____ is the equivalent of a field in a file system.

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

A

B. attribute

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

The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

A. object-oriented
B. hierarchical
C. entity relationship
D. network

A

C. entity relationship

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

A _____ is a logically connected set of one or more fields that describes a person, place, or thing.

A. database
B. record
C. column
D. file

A

B. record

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

_____ are important because they help to ensure data integrity.

A. Entities
B. Attributes
C. Relationships
D. Constraints

A

D. Constraints

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

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

A. True
B. False

A

A. True

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

_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

A. Data quality
B. Data integrity
C. Data anomaly
D. Data ubiquity

A

B. Data integrity

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

When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be _____.

A. difference-compatible
B. union-compatible
C. select-compatible
D. intersect-compatible

A

B. union-compatible

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

In the entity relationship model, a table row corresponds to an entity instance.

A. True
B. False

A

A. True

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

The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.

A. null
B. entity
C. relational
D. referential

A

B. entity

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

The Crow’s foot symbol with two vertical parallel lines indicates _____ cardinality.

A. (0,1)
B. (1,1)
C. (1,N)
D. (0,N)

A

B. (1,1)

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

To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent _____ relationships whenever possible.

A. weak
B. unary
C. binary
D. strong

A

C. binary

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

A _____ contains at least all of the attribute names and characteristics for each table in the system.

A. relational schema
B. database
C. data dictionary
D. logical schema

A

C. data dictionary

21
Q

The first step in building an entity-relationship diagram (ERD) is _____.

A. identifying the business rules based on the description of operations
B. identifying the attributes and primary keys that adequately describe the entities
C. developing the initial ERD
D. creating a detailed narrative of the organization’s description of operations

A

D. creating a detailed narrative of the organization’s description of operations

22
Q

Character data can contain any character or symbol intended for mathematical manipulation.

A. True
B. False

A

B. False

23
Q

The _____ relationship is the “relational model ideal.”

A. 1:M
B. M:1
C. M:N
D. 1:1

A

A. 1:M

24
Q

A _____ is any key that uniquely identifies each row.

A. candidate key
B. special key
C. foreign key
D. superkey

A

D. superkey

25
Q

_____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.

A. UNION
B. DIFFERENCE
C. INTERSECT
D. SELECT

A

D. SELECT

26
Q

A(n) _____ is the set of possible values for a given attribute.

A. range
B. identifier
C. domain
D. key

A

C. domain

27
Q

Date attributes contain calendar dates stored in a special format known as the _____ date format.

A. logical
B. calendar
C. Epoch
D. Julian

A

D. Julian

28
Q

In organizations that generate large number of transactions, _____ are often a top priority in database design.

A. logical design standards
B. relationships among entities
C. naming conventions
D. high processing speeds

A

D. high processing speeds

29
Q

Referential integrity and participation are both bidirectional, meaning that they must be addressed in both directions along a relationship.

A. True
B. False

A

B. False

30
Q

The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.

A. derived
B. multivalued
C. single-valued
D. composite

A

A. derived

31
Q

In the original Chen notation, each attribute is represented by an oval with the attribute name connected to an entity rectangle with a line.

A. True
B. False

A

A. True

32
Q

At the implementation level, the supertype and its subtype(s) depicted in a specialization hierarchy maintain a(n) _____ relationship.

A. M:N
B. 1:1
C. 1:M
D. self-referencing

A

B. 1:1

33
Q

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the _____ relationship.

A. M:N
B. 1:M
C. 0:1
D. 1:1

A

A. M:N

34
Q

The property of _____ enables an entity subtype to inherit the attributes and relationships of the supertype.

A. inheritance
B. subtype discriminator
C. specialization hierarchy
D. entity supertype

A

A. inheritance

35
Q

Generalization is based on grouping unique characteristics and relationships of the subtypes.

A. True
B. False

A

B. False

36
Q

An entity cluster is formed by combining multiple interrelated entities into _____.

A. a single entity object
B. a single abstract entity object
C. multiple entity objects
D. multiple abstract entity objects

A

B. a single abstract entity object

37
Q

A partial completeness constraint is represented by _____.

A. a dotted line
B. a double horizontal line over a circle
C. two dashed lines
D. a single horizontal line under a circle

A

D. a single horizontal line under a circle

38
Q

The “_____” characteristic of a primary key states that the selected primary key must not be composed of any attribute(s) that might be considered a violation.

A. unique values
B. nonintelligent
C. preferably single-attribute
D. security-compliant

A

D. security-compliant

39
Q

_____ data refer to data whose values change over time and for which one must keep a history of the data changes.

A. Historical
B. Time-sensitive
C. Change-based
D. Time-variant

A

D. Time-variant

40
Q

When designing a database, you should _____.

A. consider more important issues such as performance before normalizing
B. only normalize the database when performance problems occur
C. make sure that entities are in normal form before table structures are created
D. create table structures then normalize the database

A

C. make sure that entities are in normal form before table structures are created

41
Q

Of the following normal forms, _____ is mostly of theoretical interest.

A. BCNF
B. DKNF
C. 1NF
D. 3NF

A

B. DKNF

42
Q

_____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

A. Report
B. Temporary
C. Data warehouse
D. Normalized

A

C. Data warehouse

43
Q

A table where every determinant is a candidate key is said to be in _____.

A. 4NF
B. BCNF
C. 2NF
D. 1NF

A

B. BCNF

44
Q

A table is in 4NF if it is in 3NF, and _____.

A. no column contains the same values
B. all attributes must be dependent on the primary key and must be dependent on each other
C. all attributes are unrelated
D. it has no multivalued dependencies

A

D. it has no multivalued dependencies

45
Q

In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.

A. True
B. False

A

A. True

46
Q

Attributes should clearly define participation, connectivity, and document cardinality.

A. True
B. False

A

B. False

47
Q

From a structural point of view, 3NF is better than _____.

A. 6NF
B. 4NF
C. 5NF
D. 2NF

A

D. 2NF

48
Q

Dependencies based on only a part of a composite primary key are known as _____ dependencies.

A. incomplete
B. primary
C. composite
D. partial

A

D. partial

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

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