Deck 11: Databases

Question 1

The relationship shown in the second row of the above figure is a one-to-one relationship.

Answer 1

False

Question 2

To create a flat file, you must use database management software.

Answer 2

False

Question 3

The hyperlink data type stores data that can have one of two values.

Answer 3

False

Question 4

Database fields are always variable in length.

Question 5

Queries within an unsorted database are slow because the only algorithm for searching an unsorted table requires a sequential look at each record.

Question 6

If the data you enter is shorter than the allocated field length, blank spaces are automatically added to fill the field.

Question 7

The relationship shown in the first row of the above figure is a one-to-many relationship.

Question 8

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

Question 9

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

Question 10

A computed field is a calculation that a DBMS performs during processing.

Question 11

XForms, an alternative to HTML forms, offer more flexibility and interface with XML documents.

Question 12

Changing a sort key can take a long time because the process physically rearranges records on the disk.

Question 13

Some relational database management systems (RDBMSs) allow the database server to receive queries in the form of XML commands.

Question 14

In a relational database, relationships can be added, changed, or deleted on demand.

Question 15

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

Question 16

Telephone numbers and ZIP codes are examples of data that should be stored in a field with the numeric data type.

Question 17

The item indicated in the figure above is an example of a SQL query.

Question 18

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

Question 19

A record is the basic building block for a structured file or database.

Question 20

The relationship shown in the third row of the above figure is a many-to-many relationship.

Question 21

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

Question 22

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

Question 23

The average American is in 5-10 databases.

Question 24

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

Question 25

Customers, clients, and most employers who use a database have an occasional need to change its structure by adding fields, changing field names, and setting keys.

Question 26

A(n) many-to-many relationship means that a record in one record type is related to only one record in another record type.

Question 27

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

Question 28

It is easy to query an encrypted database.

Question 29

In SQL, the CHANGE command changes data in a field.

Question 30

Fields can be displayed as rows in a table or as forms.

Question 31

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

Question 32

In SQL, the SEARCH command searches for records.

Question 33

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

Question 34

In SQL, the INSERT command is used to add a record.

Question 35

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 36

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

Question 37

Physical access to a database can be limited to authorized personnel by housing the computer in a locked data center.

Question 38

Poorly designed custom software can result in data independence .

Question 39

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

Question 40

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

Question 41

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

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

Question 42

Each ____ is a sequence, or list, of records in a relational database.

A) sort
B) tuple
C) table
D) attribute

Question 43

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

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

Question 44

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

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

Question 45

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 46

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

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

Question 47

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

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

Question 48

Which of the following has the most limited versatility?

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

Question 49

The ____ database model uses a mesh-like structure to offer the additional capacity to define many-to-many relationships.

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

Question 50

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 51

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 52

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

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

Question 53

A(n) ____ relationship means that one record in a particular record type can be related to many records in another record type, and vice versa.

A) many-to-many
B) cardinal
C) ordinal
D) one-to-one

Question 54

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) Unicode
D) ASCII

Question 55

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

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

Question 56

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

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

Question 57

You can query by ____ using a fill-in form like the one show in the figure above.

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

Question 58

Relationships between record types can be graphically depicted, as shown in the figure above, using a(n) ____.

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

Question 59

Data ____ means that data is stored separately from the programs that are used to manipulate the data.

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

Question 60

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

A) Database models
B) Flat file
C) Unstructured files
D) OLAP

Question 61

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

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

Question 62

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

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

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 table's ____ order is the order in which records are stored on disk.

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

Question 65

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

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

Question 66

A ____ is a collection of binary data that is stored in a single field of a database.

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

Question 67

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

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

Question 68

The goal of normalization is to minimize data ____.

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

Question 69

All of the following are examples of database server software EXCEPT ____.

A) Microsoft SQL Server
B) Oracle Database
C) IBM DB2 Universal Database
D) Novell SQL Server

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 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 72

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

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

Question 73

A field ____ is a picture of how the data is supposed to look when it is entered.

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

Question 74

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

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

Question 75

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 76

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.
D) All that is required to view an XML document is an XML-enabled browser.

Question 77

The above figure shows a(n) ____ document.

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

Question 78

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

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

Question 79

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

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

Question 80

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) browser
C) XForm
D) input