Deck 11: Databases

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

The average American is in less than 10 commercial databases.

Answer 3

False

Question 4

An encrypted database can be queried quickly.

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

The accompanying figure shows an example of an SQL query.

Question 10

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

Question 11

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

Question 12

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

Question 13

Modern database software is designed to support data dependence.

Question 14

The simplest model for storing data is the flat file.

Question 15

User privileges delineate which fields and records a particular user is allowed to read.

Question 16

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

Question 17

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

Question 18

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

Question 19

A record contains the smallest unit of meaningful information.

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

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 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

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

Question 32

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

Question 33

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

Question 34

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 35

Data ____ refers to the process of analyzing information in databases to discover previously unknown and potentially useful information.

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

Question 36

____ refers to a branch of data mining that focuses on predicting future probabilities and trends.

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

Question 37

Although encryption cannot prevent a database from being lost or stolen,it can make the data it contains unintelligible to a hacker._________________________

Question 38

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 39

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 40

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 41

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

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

Question 42

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 43

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 44

____ allows decision makers to look for relationships between multiple data dimensions.

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

Question 45

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

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

Question 46

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

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

Question 47

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 48

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 49

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 50

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 51

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

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

Question 52

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

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

Question 53

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

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

Question 54

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

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

Question 55

A record ____ contains data about a particular entity.

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

Question 56

Which of the following has the least versatility?

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

Question 57

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 58

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

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

Question 59

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 60

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

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

Question 61

What would be an appropriate data type to choose for a field designed to hold an MP3 file?

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

Question 62

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

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

Question 63

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 64

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

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

Question 65

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 66

Which of the following can be used to delineate the data entry area in a user interface?

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

Question 67

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 68

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

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

Question 69

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

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

Question 70

____ 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 71

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

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

Question 72

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

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

Question 73

The accompanying figure shows a(n)____ document.

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

Question 74

The goal of normalization is to minimize data ____.

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

Question 75

What would be an appropriate data type to choose for a fixed-length field designed to hold a person's name?

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

Question 76

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 77

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 78

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

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

Question 79

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 80

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