Deck 14: Databases and Database Management Systems

Question 1

Normalization is usually viewed as a multistep process, from first normal form (1NF) to usually fifth normal form (5NF).

Answer 1

False

Question 2

Most DBMSs come bundled with a set of tools to perform a variety of necessary tasks, such as building user interfaces, creating forms and reports, and interfacing with query languages and ____ for complex applications.

A) query wizards
B) programming languages
C) report generators
D) form screens

Answer 2

B

Question 3

In some systems, data integrity is enforced on a per transaction basis.

Answer 3

True

Question 4

Arranging data for efficient retrieval is called data organization.

Question 5

To protect against data loss caused by a database failure, accidental deletion, or other problem that renders the main copy of a database unusable, stringent backup procedures should be implemented.

Question 6

Hashing procedures usually result in two or more records being assigned the same storage address, an event known as a collision.

Question 7

Views need to be designed to extract the needed information in as efficient a manner as possible.

Question 8

A ____ holds a single category of data (such as customer names or employee telephone numbers) that will be stored in a database.

A) cell
B) field
C) table
D) record

Question 9

Multidimensional databases are appropriate when a variety of types of objects need to be stored and retrieved.

Question 10

Data integrity refers to the accuracy of data.

Question 11

If a field needs to store decimal places, the Long Integer field size can be used.

Question 12

The data dictionary includes data located in the database tables.

Question 13

A database typically consists of interrelated tables that contain forms and reports.

Question 14

With HOLAP (Hybrid OLAP), a combination of MOLAP and ROLAP technologies are used.

Question 15

Data accessibility refers to protecting data against destruction and misuse-both intentionally and accidentally.

Question 16

IBM's DB2 9 program contains a hybrid XML / relational database server.

Question 17

Many-to-many entity relationships exist when one entity can be related to more than one other entity, and those entities can be related to multiple entities of the same type as the original entity.

Question 18

A field is also called a ____.

A) column
B) row
C) table
D) record

Question 19

Repairing or restoring data that has become corrupt, perhaps as the result of a storage media error or computer virus, is a database analysis activity.

Question 20

The accompanying figure shows an n-tier database model.

Question 21

In ____, the table field involved in the changes is locked until the changes to that field have been completed.

A) column-level locking
B) database locking
C) row-level locking
D) record-level locking

Question 22

A(n) ____ is a small table consisting only of a list of the primary key field for each record in a table along with location information for that record.

A) tablet
B) keyword
C) index
D) main table

Question 23

A record is also called a ____.

A) field
B) report
C) row
D) table

Question 24

The field in a table that is used to relate that table to other tables is called the ____.

A) composite key
B) secondary key
C) primary key
D) primary field

Question 25

Virtually all DBMSs include a ____ for easy data input, modification, and retrieval.

A) user interface
B) line interface
C) command interface
D) device interface

Question 26

The ____ contains all data definitions for a database, including table structures, security information, relationships between the tables in the database, and so on.

A) database book
B) data dictionary
C) data box
D) data book

Question 27

In a typical client-server database application, the client is called the ____.

A) back end
B) rear end
C) portal
D) front end

Question 28

The characteristics of an entity are called ____.

A) attributes
B) variables
C) traits
D) fields

Question 29

Individual database tables are often referred to as ____.

A) low files
B) base files
C) flat files
D) clear files

Question 30

The ____ is the most widely used database model today.

A) hierarchical database management system
B) relational database management system (RDBMS)
C) network database management system
D) database management system (DBMS)

Question 31

DBMSs available for use on personal computers include ____ and Corel Paradox.

A) IBM DB2
B) Microsoft Access
C) Adobe Acrobat
D) Adobe Fireworks

Question 32

____ is a growing concern because of the vast amounts of personal data stored in databases today and the many breaches that have occurred in the recent past.

A) Data privacy
B) Data integrity
C) Data accessibility
D) Data legibility

Question 33

____ are made up of related records.

A) Rows
B) Fields
C) Columns
D) Tables

Question 34

Data definition involves describing the properties of the data that go into each database table, specifically the ____ that make up the database.

A) records
B) rows
C) fields
D) characters

Question 35

With a ____, a database is located in its entirety on a single computer, such as a server or mainframe computer.

A) distributed database system
B) star database system
C) centralized database system
D) ring database system

Question 36

With ____, the computer uses each record's primary key field and a mathematical formula called a hashing algorithm to determine a unique address that identifies where the record is physically stored in the database file.

A) real-time organization
B) indexed organization
C) sequenced organization
D) direct organization

Question 37

A ____ is a collection of related fields.

A) table
B) field
C) column
D) record

Question 38

____ create the actual database, based on the design generated by the database designer, and get it ready for data entry.

A) Database developers
B) Database administrators (DBAs)
C) Database security officers
D) Database analysts

Question 39

One of the properties that can be assigned to a field is a(n) ____ to specify the format (such as letters, numbers, or symbols) that must be entered into a field.

A) format structure
B) input mask
C) data mask
D) data filter

Question 40

One of the simplest hashing algorithms involves dividing the primary key field by a particular ____.

A) power of two
B) prime number
C) irrational number
D) transcendental number

Question 41

If a new database is to be used with existing data, the data needs to be transferred from its existing form into the new system-a process called ____.

A) data migration
B) data conversion
C) data normalization
D) data accommodation

Question 42

Middleware for Web database applications is commonly written as ____-short sections of code written in a programming or scripting language that are executed by another program.

A) scripts
B) JavaScripts
C) applets
D) utilities

Question 43

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.

A) normalization
B) cyclic redundancy check
C) zeroing
D) zonification

Question 44

____________________ rules are used when the value of one field in the record needs to be checked against another field in that same record to be sure it is valid.

Question 45

Primary keys can be a combination of two key fields (called ____________________ primary keys), but single primary keys are more typical in simple databases.

Question 46

____________________ databases are located on a PC and are designed to be accessed by one user.

Question 47

A ____ extracts specific information from a database by specifying particular conditions (called criteria) about the data you would like to retrieve.

A) form
B) query
C) macro
D) view

Question 48

The ____________________ in a database system are the ones who enter data, update data, and retrieve information from the database when necessary.

Question 49

The figure above illustrates a ____, created from data contained in a database.

A) report
B) query
C) form
D) table

Question 50

____________________ refers to the process of ensuring that the data entered into a database matches the specified type, format, and allowable value.

Question 51

To create a query, users can either type a query using SQL or, more commonly, use the query tools built into the DBMS (such as a query design screen or query ____) to create a query object.

A) command
B) line
C) wizard
D) key

Question 52

In ____________________ organization, the order of the records is physically based on the content of the key field.

Question 53

____________________ entity relationships exist when one entity is related to only one other entity of a particular type.

Question 54

In ASPs, the code to tie the database to the Web site is typically written in JavaScript or ____.

A) VBScript
B) CGI
C) PHP
D) BasicScript

Question 55

With indexed organization, a(n) ____________________ is used to keep track of where data is stored.

Question 56

With ____, data is stored in single multidimensional database structures (sometimes called data cubes).

A) Online Analytical Processing (OLAP)
B) ROLAP (Relational OLAP)
C) MOLAP (Multidimensional OLAP)
D) HOLAP (Hybrid OLAP)

Question 57

Some database programs allow you to create a table by just entering data, and then the program will create the ____________________ based on the data entered.

Question 58

Web-based database requests are received by the Web server, which then converts the request into a database query and passes it on to the database server with the help of software called ____.

A) middleware
B) capsules
C) macros
D) applets

Question 59

____ databases are designed to store a collection of summarized data for quick and easy data analysis.

A) Relational
B) Object-oriented
C) Analytical
D) Multidimensional

Question 60

A(n) ____________________ is a specific field in a database table that uniquely identifies the records in that table.

Question 61

Explain in-memory databases

Question 62

What do database administrators do?

Question 63

Describe a database and a database management system (DBMS).

Question 64

Discuss database entities and attributes.

Question 65

The appearance and content of ____________________ Web pages change based on a user's input.

Question 66

When you are beginning to design a new database, sketching a(n) ____________________ of the reports and other desired database output can be helpful in identifying the fields that need to be included in the database.

Question 67

In Microsoft Access, tables can be created in either Datasheet view or ____________________ view, as shown in the accompanying figure.

Question 68

____________________ script is a set of instructions written in a programming language and designed to accept data from and return data to a Web page visitor.

Question 69

____________________ usually includes the programs used with the database and the programs needed to connect the client and server components of the database system.

Question 70

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____________________.

Question 71

What is a CGI (common gateway interface) script?

Question 72

With a(n) ____________________, the data is separated into several databases, each of which is stored on a different computer that may be in different physical locations from one another but that are connected via a network.