Brainscape's Knowledge GenomeTM

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


See full index

ISAD > Data Design Practice Test > Flashcards

Data Design Practice Test Flashcards

1
Q

True or False: In a table or file, each column represents a record and each row represents a field.

A

False

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

True or False: A primary key is composed of exactly two fields.

A

False.

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

True or False:Like a primary key, a foreign key must be unique.

A

False. It doesn’t have to be unique

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

True or False:Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

A

True

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

True or False: The basic elements of logical storage are alphabetic or numeric characters, such as the letter A or the number 9.

A

True

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

True or False: Audit log files, which record details of all accesses and changes to a file or database, can be used to recover changes made since the last backup.

A

True

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

True or False: Systems that interact with a DBMS are relatively independent of how the physical data is maintained.

A

True

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

True or False: A secondary key is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

A

False. Foreign Key

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

True or False: An M:N relationship is different from 1:1 or 1:M relationships because the event or transaction that links the two entities is actually a third entity, called an associative entity, that has its own characteristics.

A

True

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

True or False: College course numbers usually are assigned using a block sequence code.

A

True

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

True or False: A logical record is a set of field values that describes a single person, place, thing, or event.

A

True

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

A _____, which is a framework for organizing, storing, and managing data, consists of files or tables that interact in various ways.

A. Data structure
B. Data Roster
C. Data Object
D. Data Log

A

A

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

A(n) _____ is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data.

A. data logger framework
B. database management system
C. integrated development environment
D. advanced host controller system

A

B

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

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

Scalability
Compatibility
Cardinality
Functionality

A

A

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

Typically, a database management system is managed by a person called a _____, who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

database administrator
business intelligence analyst
database consumer
big data analyst

A

A

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

A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.

procedural language
query by example language
query language
imperative language

A

C

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

With a _____, users provide an example of the data requested.

query language
data table
query by example language
data frame

A

C

18
Q

A _____ controls database operations, including storing, retrieving, updating, and deleting data.

data manipulation language
data device language
data definition language
data query language

A

A

19
Q

The complete definition of a database, including descriptions of all fields, tables, and relationships, is called a _____.

viewport
schema
framework
cell

A

Schema

20
Q

During the systems design phase, _____ are used to organize, access, and maintain data structures.

glossary fields
common fields
content fields
key fields

A

D

21
Q

n the accompanying figure, a _____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

primary key
secondary key
candidate key
foreign key

A

A

22
Q

In the accompanying figure, any field that serves as a primary key is called a _____.

candidate key
secondary key
combination key
foreign key

A

A

23
Q

In the accompanying figure, a _____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

secondary key
candidate key
combination key
foreign key

A

D

24
Q

If a primary key combines two or more fields, then it is called a _____

A

Composite Key

25
Q

A _____, which is not unique, is a field or combination of fields that can be used to access or retrieve records.

no-frills key
super key
secondary key
foreign key

A

C

26
Q

One type of validity check, called _____, is a set of rules that avoids data inconsistency and quality problems.

candidate integrity
foreign integrity
referential integrity
combinatorial integrity

A

C

27
Q

A(n) _____ is a graphical model of an information system that depicts the logical relationships and interaction among system entities.

entity-relationship diagram (ERD)
illustration flow chart
query relationship diagram (QRD)
data chart

A

A

28
Q

In an entity-relationship diagram, entities are commonly represented as _____

A

rectangles

29
Q

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.
Scalability
Compatibility
Cardinality
Functionality

A

C

30
Q

A common method of cardinality notation is called _____ because of the shapes, which include circles, bars, and symbols that indicate various possibilities.

A

Crow’s foot notation

31
Q

_____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.

A

Normalization

32
Q

A _____ specifies the fields and identifies the primary key in a particular file

frame design
table design
viewport
window

A

Table Design

33
Q

A table is in _____ if it does not contain a repeating group.

A

1st normal form

34
Q

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

A

Second normal form

35
Q

A _____ is a set of letters or numbers that represents a data item.

A

Code

36
Q

Some abbreviation codes are called _____ codes because they use a specific combination of letters that are easy to remember.

A

Mnemonic

37
Q

_____ is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company.

A

data warehouse

38
Q

_____ is designed to serve the needs of a specific department, such as sales, marketing, or finance.

A data mart
A data frame
Pseudo-data
Metadata

A

data mart

39
Q

_____ is strictly hardware related because it involves the process of reading and writing binary data to physical media, such as a hard drive, CD/DVD, or network-based storage device.
Logical storage
Virtual storage
Simulated storage
Physical storage

A

D

40
Q

_____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.

A

Ecryption

ISAD (8 decks)

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