Deck 9: Data Design

Question 1

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

Answer 1

True

Question 2

A web-based data design requires users to have powerful workstations.

Answer 2

False

Question 3

Web-based designs are dependent on a specific combination of hardware and software.

Answer 3

False

Question 4

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

Question 5

Cipher codes distinguish items by using a series of subgroups of digits.

Question 6

A table design is in third normal form (3NF)if it is in 2NF and if all nonkey fields are dependent on one another.

Question 7

A repeating group is a set of one or more fields that can occur only once in a single record,with each occurrence having the same value.

Question 8

A subschema is a view of the database used by one or more systems or users.

Question 9

Like a primary key,a foreign key must be unique.

Question 10

Three main types of relationships can exist between entities: a one-to-one relationship,abbreviated 1:1;a one-to-many relationship,abbreviated 1:M;and a many-to-many relationship,abbreviated M:N.

Question 11

Migrating a traditional database design to the web can require design modification,additional software,and some added expense.

Question 12

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.

Question 13

To resolve potential database connectivity and access problems,companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Question 14

The three normal forms constitute a progression in which second normal form represents the best design.

Question 15

Web-based systems are popular because they offer ease of access,cost-effectiveness,and worldwide connectivity.

Question 16

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

Question 17

Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

Question 18

A common field is an attribute that appears in only one entity.

Question 19

A primary key is composed of exactly two fields.

Question 20

Most magazine subscription codes are action codes.

Question 21

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

Question 22

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.

A) database administrator
B) business intelligence analyst
C) database consumer
D) big data analyst

Question 23

The database and the Internet speak the same language.

Question 24

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

Question 25

The inherent efficiency of high-volume processing on larger computers is called _____.

A) monopoly
B) economy of scope
C) cardinality
D) economy of scale

Question 26

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

A) Scalability
B) Compatibility
C) Cardinality
D) Functionality

Question 27

Common fields can be used to link entities in various types of relationships.

Question 28

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.

Question 29

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.

Question 30

Mainframe storage refers to data that a user can view,understand,and access,regardless of how or where that information actually is organized or stored.

Question 31

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

Question 32

College course numbers usually are assigned using a block sequence code.

Question 33

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

A) query language
B) data table
C) query by example language
D) data frame

Question 34

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

A) procedural language
B) query by example language
C) query language
D) imperative language

Question 35

_____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.

A) ActiveX data object (ADO)
B) Java virtual connector (JVC)
C) Open database connectivity (ODBC)
D) Open embedded connectivity (OEC)

Question 36

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

A) data manipulation language
B) data device language
C) data definition language
D) data query language

Question 37

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

Question 38

A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs.

Question 39

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

Question 40

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

A) viewport
B) schema
C) framework
D) cell

Question 41

_____ are numbers or letters assigned in a specific order.

A) Sequence codes
B) Category codes
C) Significant digit codes
D) Derivation codes

Question 42

_____ combine data from different item attributes,or characteristics,to build a code.

A) Sequence codes
B) Category codes
C) Significant digit codes
D) Derivation codes

Question 43

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

A) business glossary
B) data dictionary
C) mnemonic
D) code

Question 44

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

A) foreign key
B) composite key
C) dedicated key
D) candidate key

Question 45

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
B) zeroth normal form
C) third normal form
D) fourth normal form

Question 46

Any field that is not a primary key or a candidate key is called a _____.

A) no-frills field
B) nonkey field
C) secondary field
D) foreign field

Question 47

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

A) second normal form
B) first normal form
C) third normal form
D) fourth normal form

Question 48

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

A) Scalability
B) Compatibility
C) Cardinality
D) Functionality

Question 49

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

A) Encapsulation
B) Normalization
C) Abstraction
D) Encryption

Question 50

Designing tables is easier if a _____ is used to show a table's structure,fields,and primary key.

A) distinct notation format
B) multifaceted notation format
C) viewport notation format
D) standard notation format

Question 51

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

A) entity-relationship diagram (ERD)
B) illustration flow chart
C) query relationship diagram (QRD)
D) data chart

Question 52

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

A) harmonic
B) sequence
C) mnemonic
D) rhapsodic

Question 53

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

A) triangles
B) circles
C) rectangles
D) hexagons

Question 54

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

A) candidate integrity
B) foreign integrity
C) referential integrity
D) combinatorial integrity

Question 55

_____ enables Java applications to exchange data with any database that uses SQL statements and is compliant with its standard.

A) Java runtime environment (JRE)
B) Java eclipse framework connectivity (JEFC)
C) Java virtual machine (JVM)
D) Java database connectivity (JDBC)

Question 56

A table design that contains a repeating group is called _____.

A) normalized
B) unnormalized
C) unsynchronized
D) synchronized

Question 57

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

A) frame design
B) table design
C) viewport
D) window

Question 58

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

A) no-frills key
B) super key
C) secondary key
D) foreign key

Question 59

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

A) big O notation
B) dark resistor's notation
C) crow's foot notation
D) hash topology notation

Question 60

To bridge the gap between a database and the Internet,it is necessary to use _____,which is software that integrates different applications and allows them to exchange data.

A) middleware
B) a stack
C) a server
D) firmware

Question 61

Eamon wants to provide a discount to premium buyers who order in large quantities.He wants to create a code for each price and share it with them.Also,he wants to ensure that only the premium buyers can decipher the code shared.In this scenario,which of the following codes would you suggest that Eamon use?

A) Cipher code
B) Mnemonic code
C) Action code
D) Derivation code

Question 62

_____ 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.

A) Logical storage
B) Virtual storage
C) Simulated storage
D) Physical storage

Question 63

A long integer format uses _____ bits to represent the number 1,234,567,890 in binary form.

A) 12
B) 24
C) 30
D) 32

Question 64

Explain why large firms use data warehouses.

Question 65

Binary digits have only _____ possible value(s).

A) one
B) two
C) three
D) four

Question 66

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

A) Encapsulation
B) Normalization
C) Standardization
D) Encryption

Question 67

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

A) A data warehouse
B) A data frame
C) Pseudo-data
D) Metadata

Question 68

Explain the importance and process of system file backup.

Question 69

Eamon plans to operate three warehouses,in different cities,to support his business.To find the exact location of a product,he wants to establish a code that identifies a product's warehouse location,floor number,section number,aisle number,and bin number.By doing this,he can ship the ordered products faster.Which of the following codes would you suggest that Eamon use?

A) Significant digit code
B) Block sequence code
C) Sequence code
D) Action code

Question 70

_____,a coding method that uses one byte per character,is used on mainframe computers and high-capacity servers.

A) ASCII (American Standard Code for Information Interchange)
B) EBCDIC (Extended Binary Coded Decimal Interchange Code)
C) Unicode
D) ISO (International Organization for Standardization)

Question 71

The data mining technique that relies on association rule learning is often called _____.

A) simulated analysis
B) virtual storage analysis
C) strategy-oriented analysis
D) market basket analysis

Question 72

Describe how middleware is used.

Question 73

_____ use a keyword to encode a number.

A) Cipher codes
B) Identifier codes
C) Action codes
D) Associative codes

Question 74

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

A) A data mart
B) A data frame
C) Pseudo-data
D) Metadata