Deck 14: Databases and Database Management Systems

Question 1

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.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

Arranging data for efficient retrieval is called data organization.

Answer 3

True

Question 4

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

Question 5

Most databases created today do not use the hierarchical or network models;these models are generally used with legacy systems that are still operational and must be maintained.

Question 6

At the top of the data hierarchy is the database,which consists of a group of related tables.

Question 7

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

Question 8

The data dictionary includes data located in the database tables.

Question 9

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 10

Typically,in hierarchical database management systems,a one-to-one relationship exists between data entities.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

N-tier database systems provide a great deal of flexibility and scalability,allowing the system to be modified as new needs and opportunities arise.

Question 17

The figure above shows an n-tier database model.

Question 18

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

Question 19

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 20

Data integrity refers to the accuracy of data.

Question 21

At the lowest level,words are entered into database fields/columns,which hold single pieces of data in the database,such as product names or quantities.

Question 22

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

Question 23

In determining the location where specific data is to be stored in a(n)centralized DBMS,factors such as communications cost,response time,storage cost,and security are key considerations.

Question 24

Structured query language (SQL)is recognized as the standard query language for relational databases.

Question 25

One emerging data security risk is the exploitation of known but unpatched vulnerabilities by hackers.

Question 26

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 27

With MOLAP (Multidimensional OLAP),the multidimensional information is stored in an existing relational database using tables to store the summary information.

Question 28

The finished specifications for a table are commonly referred to as the table format.

Question 29

Software that connects two otherwise separate applications-such as a Web server and a DBMS-is referred to as interware

Question 30

A ____ is a collection of related fields.

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

Question 31

Web databases allow Web pages to be static Web pages; that is, Web pages in which the appearance or content of the pages change based on the user’s input.

Question 32

A record is also called a ____.

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

Question 33

After all the tables in a database application have been created and their primary keys designated,the tables can be related to one another via their primary key so that a primary key for one table can be used to extract data from other tables as needed.

Question 34

A(n)file management system is a program that allows the creation of individual database tables,each of which is stored in its own physical file and is not related to any other file.

Question 35

As part of its disaster-recovery plan,some firms maintain a(n)hot site-an alternate location equipped with identical hardware and software that can be used to resume operations quickly in case of a major disaster.

Question 36

One advantage of the n-tier architecture is that it allows the program code used to access the database to be separate from the database,and the code can be divided into any number of logical components.

Question 37

Objects stored in an OODBMS can be retrieved using queries,such as with a(n)object query language (OQL)-an object-oriented version of SQL.

Question 38

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

Question 39

Database developers are the people responsible for managing the databases within an organization.

Question 40

A field is also called a ____.

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

Question 41

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 42

Individual database tables are often referred to as ____.

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

Question 43

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 44

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

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

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

Question 46

The characteristics of an entity are called ____.

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

Question 47

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 48

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 49

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 50

____ are made up of related records.

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

Question 51

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 52

____ actually create the 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 53

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 54

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 55

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

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

Question 56

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 57

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 58

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 59

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 60

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)migration
B)conversion
C)normalization
D)accommodation

Question 61

Case 14-2
The JL Group is a political think tank that is incorporating new media into their analyses.
The JL Group has gathered data on voting habits.In order to make sure that respondents cannot claim to have voted in more elections than is possible given their age,____ rules can be assigned to the database tables.

A)index validation
B)record validation
C)DBA validation
D)dynamic

Question 62

Case 14-2
The JL Group is a political think tank that is incorporating new media into their analyses.
The employees of JL Group who use the database of the company for their daily work,without having knowledge of how the underlying database is structured,interact with the database ____.

A)using the database script
B)through the database designer
C)through the database programmer
D)using the user interface

Question 63

Case 14-1
James is a recent college graduate and has six months of IT experience.He is thinking about pursuing a certification program in order to demonstrate that he is serious about IT.
James is most interested in becoming a database designer.Another name for this career choice is database ____.

A)architect
B)developer
C)programmer
D)administrator

Question 64

The key characteristics for an OODBMS (including objects,attributes,methods,____,and inheritance)are similar to object-oriented programming principles.

A)pages
B)scripting
C)conversion
D)classes

Question 65

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 66

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

Question 67

Continuing to evaluate and improve the security measured used with the database is a database ____ activity.

A)programming
B)design
C)implementation
D)maintenance

Question 68

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 69

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

Question 70

The JL Group is in the process of creating dynamic Web pages to poll politically aware young adults. They are interested in creating scripts that are compatible with many types of databases, so they are using the ____ language.

A)CGI
B)API
C)COBOL
D)PHP

Question 71

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 72

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 73

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

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 75

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

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

Question 76

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

Question 77

Case 14-1
James is a recent college graduate and has six months of IT experience.He is thinking about pursuing a certification program in order to demonstrate that he is serious about IT.
Database designers work with systems analysts and other individuals involved in ____.

A)CCP
B)DBMS
C)SDLC
D)CDMP

Question 78

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 79

To ensure the uniqueness of the ____________________,it usually consists of an identifying number,such as a student ID number,customer number,or product number.

Question 80

A database typically consists of interrelated ____________________ consisting of fields and records.