Data Design Practice Test

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False.

Question 3

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

Answer 3

False. It doesn’t have to be unique

Question 4

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

Answer 4

True

Question 5

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

Answer 5

True

Question 6

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.

Answer 6

True

Question 7

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

Answer 7

True

Question 8

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.

Answer 8

False. Foreign Key

Question 9

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.

Answer 9

True

Question 10

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

Answer 10

True

Question 11

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

Answer 11

True

Question 12

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

Answer 12

A

Question 13

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

Answer 13

B

Question 14

_____ 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

Answer 14

A

Question 15

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

Answer 15

A

Question 16

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

Answer 16

C

Question 17

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

query language
data table
query by example language
data frame

Answer 17

C

Question 18

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

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

Answer 18

A

Question 19

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

viewport
schema
framework
cell

Answer 19

Schema

Question 20

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

glossary fields
common fields
content fields
key fields

Answer 20

D

Question 21

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

Answer 21

A

Question 22

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

candidate key
secondary key
combination key
foreign key

Answer 22

A

Question 23

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

Answer 23

D

Question 24

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

Answer 24

Composite Key

Question 25

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

Answer 25

C

Question 26

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

Answer 26

C

Question 27

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

Answer 27

A

Question 28

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

Answer 28

rectangles

Question 29

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

Answer 29

C

Question 30

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

Answer 30

Crow's foot notation

Question 31

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

Answer 31

Normalization

Question 32

A _____ specifies the fields and identifies the primary key in a particular file frame design table design viewport window

Answer 32

Table Design

Question 33

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

Answer 33

1st normal form

Question 34

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.

Answer 34

Second normal form

Question 35

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

Answer 35

Code

Question 36

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

Answer 36

Mnemonic

Question 37

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

Answer 37

data warehouse

Question 38

_____ 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

Answer 38

data mart

Question 39

_____ 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

Answer 39

D

Question 40

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

Answer 40

Ecryption