Deck 11: Databases

Question 1

A record contains the smallest unit of meaningful information.

Answer 1

False

Question 2

The hyperlink data type is used to store data that can have one of two values.

Answer 2

False

Question 3

Modern database software is designed to support data dependence.

Answer 3

False

Question 4

The simplest model for storing data is the flat file.

Question 5

The logical data type is used for true/false or yes/no data.

Question 6

An index has no bearing on the physical sequence of records on disk.

Question 7

The average American is in less than 10 commercial databases.

Question 8

In the accompanying figure,the relationship shown in the bottom row is a many-to-many relationship.

Question 9

Sorted tables typically produce slower queries and updates than unsorted tables.

Question 10

In the accompanying figure,the relationship shown in the top row is a one-to-many relationship.

Question 11

Database tables should be indexed by any field or fields that are commonly used as search fields.

Question 12

In a fixed-length field,when the data entered is shorter than the allocated field length,blank spaces automatically fill the field.

Question 13

User privileges delineate what activities a user can perform within a database.

Question 14

An encrypted database is more efficient than an unencrypted database.

Question 15

The accompanying figure shows an example of an SQL query.

Question 16

The United States has some of the strongest privacy regulations in the developed world.

Question 17

Queries within an unsorted database are slow because each record must be looked at sequentially.

Question 18

XML documents are not optimized for many operations you would customarily associate with databases,such as fast sorts,searches,and updates.

Question 19

If a name field contains an entire name,it is difficult to individually manipulate the first name,last name,and middle initial.

Question 20

A relational database stores data in a collection of related tables.

Question 21

In the broadest definition,a(n)____ is a collection of information.

A) index
B) database
C) hierarchy
D) field

Question 22

In the query illustrated in the accompanying figure,the (SELECT) command is used to link the Albums and Tracks tables._________________________

Question 23

In a(n) (relational) database,relationships are specified by joining common data stored in the fields of records in different tables._________________________

Question 24

You can query by ____ using a fill-in form,like the one shown in the accompanying figure.

A) example
B) model
C) format
D) function

Question 25

(Dynamic) Web publishing allows you to take a snapshot of the data in a database by generating a report,which is converted into an HTML document._________________________

Question 26

In the accompanying figure,the (middle) row shows a relationship where one album contains many songs,and one song may appear on many albums._________________________

Question 27

In the query illustrated in the accompanying figure,the (JOIN) command specifies that you want to see the album with item number LPM-2256._________________________

Question 28

In database jargon,a(n) (relationship) is an association between data that is stored in different record types._________________________

Question 29

Data ____ refers to computer algorithms that analyze information to discover previously unknown and potentially useful information.

A) leading
B) mining
C) tracking
D) warehousing

Question 30

(XML) is a markup language that allows field tags,data,and tables to be incorporated into a Web document._________________________

Question 31

In a(n) (case sensitive) database,uppercase letters are not equivalent to their lowercase counterparts._________________________

Question 32

____ refers to a branch of data mining that analyzes current and historical data to predict future trends.

A) Future-oriented analytics
B) Linked analytics
C) Predictive analytics
D) Forecasting analytics

Question 33

The data accessed by data mining and other analysis techniques is often stored in a data ____.

A) cellar
B) stockyard
C) warehouse
D) silo

Question 34

In the query illustrated in the accompanying figure,the (SELECT) command specifies the fields that should appear._________________________

Question 35

The term (XML) refers to software that is designed to manage data stored in a database._________________________

Question 36

In a flat file,each row in the table is a(n) (field)._________________________

Question 37

The (index0 key for a table specifies the order in which records are stored and where new records are inserted in a table._________________________

Question 38

Thieves who gain access to a(n) (encrypted) database cannot make sense of the data._________________________

Question 39

A(n) (index) simply points to the record where the data can be found._________________________

Question 40

Poorly designed custom database software can result in data (independence)._________________________

Question 41

It is possible to enter data as a(n)____ text file and then use a programming language to write routines to access that data.

A) binary
B) primary key
C) relational
D) ASCII

Question 42

A(n)____ file uses a uniform format to store data for each person or thing in the file.

A) structured
B) indexed
C) variable-length
D) fixed-length

Question 43

A(n)____ is an association between data that is stored in different record types.

A) method
B) table
C) relationship
D) attribute

Question 44

Relationships between record types can be graphically depicted using a(n)____.

A) DRE
B) ERD
C) EDR
D) GRD

Question 45

In the relationship in the ____ row of the accompanying figure,one record in a particular record type can be related to many records in another record type,and vice versa.

A) top
B) middle
C) bottom
D) No such relationship is shown in the accompanying figure

Question 46

In an object database,an attribute is ____.

A) equivalent to a record
B) a group of objects
C) equivalent to a field in a relational database
D) any behavior that an object is capable of performing

Question 47

A record that contains data is referred to as a record ____.

A) type
B) occurrence
C) stock
D) catalog

Question 48

The ____ database model uses a mesh-like structure,which allows for the definition of many-to-many relationships.

A) hierarchical
B) network
C) parent-child
D) duplex

Question 49

Database ____ software is designed to manage billions of records and several hundred transactions per second.

A) server
B) client
C) distribution
D) system

Question 50

Database ____ software allows a remote computer or network workstation to access data in a database.

A) client
B) server
C) distribution
D) management

Question 51

____ allows decision makers to quickly get answers to complex queries that encompass multiple factors.

A) Database modeling
B) Flat file
C) Predictive analytics
D) OLAP

Question 52

Data ____ means that data are separate from the programs used to manipulate the data.

A) dependence
B) independence
C) reliance
D) autonomy

Question 53

____ refers to the number of associations that can exist between two record types.

A) Ordinality
B) Referentiality
C) Relating
D) Cardinality

Question 54

A technique called ____ Web publishing is a simple way to display the data in a database by converting a database report into an HTML document,which can be displayed as a Web page by a browser.

A) dynamic
B) flexible
C) static
D) entry

Question 55

With a(n)____ database,the database is stored on several different computers,on multiple networks,or in different geographical locations.

A) distributed
B) object
C) network
D) relational

Question 56

A fixed-length field contains a predetermined number of ____.

A) letters
B) units
C) pixels
D) bytes

Question 57

A(n)____ allows you to create,update,and administer a relational database.

A) XML DBMS
B) RDBMS
C) OODBMS
D) ERD

Question 58

In the world of databases,a(n)____ refers to a collection of data fields.

A) record
B) format
C) structure
D) index

Question 59

If a single data management tool can be used to maintain many different files and databases,it must support data ____.

A) dependence
B) independence
C) networks
D) relationships

Question 60

Which of the following has the least versatility?

A) database software
B) custom software
C) spreadsheet software
D) dedicated software

Question 61

A ____ data type usually provides a variable-length field into which users can enter comments.

A) text
B) character
C) memo
D) string

Question 62

The ____ data type would be appropriate for a fixed-length field designed to hold a person's name.

A) memo
B) real
C) text
D) logical

Question 63

A database ____ contains a list of keys,and each key provides a pointer to the record that contains the rest of the fields related to that key.

A) schema
B) catalog
C) index
D) roster

Question 64

A ____ validates an entry by searching for the same data in a file or database table.

A) validating routine
B) redundancy routine
C) lookup routine
D) normalizing routine

Question 65

To provide a quality database interface,a designer might ____.

A) arrange fields in a logical order
B) minimize on-screen instructions to save space
C) position entry areas randomly
D) use only one type of control on the interface

Question 66

The two tables shown in the accompanying figure are ____ by the CustomerNumber field.

A) merged
B) related
C) split
D) concatenated

Question 67

____ is a markup language that allows field tags,data,and tables to be incorporated into a Web document.

A) HTML
B) XML
C) Java
D) ASP

Question 68

The goal of normalization is to minimize data ____.

A) redundancy
B) cardinality
C) indexing
D) formatting

Question 69

The ____ Web publishing process generates customized Web pages as needed.

A) server-side
B) flexible
C) static
D) dynamic

Question 70

A field ____ is a template that adds the correct formatting as data is entered.

A) format
B) roster
C) validation
D) screen

Question 71

The ____ data type would be the right choice for a field designed to hold an MP3 file.

A) music
B) computed field
C) logical
D) BLOB

Question 72

The ____ data type is used to store true/false or yes/no data using minimal storage space.

A) yes
B) logical
C) memo
D) true

Question 73

Dynamic Web publishing relies on a program or script,referred to as a(n)____ program,that acts as an intermediary between your browser and a DBMS.

A) server-side
B) client-side
C) XForm
D) input

Question 74

A table's ____ order is the order in which records are stored on disk.

A) storage
B) sort
C) normal
D) linked

Question 75

The accompanying figure shows a(n)____ document.

A) HTML
B) XML
C) JavaScript
D) Perl

Question 76

A CGI script can be written in all of the following EXCEPT ____.

A) C++
B) Java
C) JavaScript
D) Perl

Question 77

A field ____ rule is a specification that the database designer sets up to filter the data entered into a particular field.

A) cardinality
B) validation
C) structure
D) filter

Question 78

A(n)____ can be used to delineate the data entry area in a user interface.

A) box
B) line
C) shaded area
D) all of the above

Question 79

Which of the following is NOT true of XML?

A) It exists as a document in human-readable format.
B) It is portable so that it can be easily accessed from virtually any platform.
C) XML documents are optimized for many operations you customarily associate with databases such as fast sorts and updates.
D) All that is required to view an XML document is an XML-enabled browser.

Question 80

All of the following are tools to help you create server-side programs EXCEPT ____.

A) ASP
B) JavaScript
C) CGI
D) PHP