Deck 6: Database Management Systems

Question 1

Which statement is false concerning database end users?

A)There can be an increase in end- user errors because the database is easy to use.
B)End users ask questions using query- by- example.
C)End users generate forms and reports.
D)End users need to know how to code SQL statements.

Answer 1

D

Question 2

Which database definition is the collection of data under the control of database management system software?

A)general definition of a database
B)relational database
C)restrictive definition of a database
D)database

Answer 2

C

Question 3

Which of the following is not a major area for the database administrator?

A)security
B)implementation
C)programming
D)planning

Answer 3

C

Question 4

When defining a database in Microsoft Access, what property is used to force certain characters to be entered in a particular manner?

A)validation rule
B)default value
C)input mask
D)key field

Question 5

When databases break information into multiple tables to avoid duplicate data, it is referred to as reducing:

A)data accuracy.
B)data consistency.
C)data redundancy.
D)data duplication.

Question 6

A key in a table is a:

A)file.
B)record.
C)data field.
D)data.

Question 7

In the data hierarchy, what is a collection of files?

A)database
B)data field
C)data
D)record

Question 8

In the data hierarchy, which of the following represents the smallest unit of data?

A)data field
B)database
C)record
D)file

Question 9

Which of the following is not a step in the problem- oriented approach to creating a database?

A)Describe information needs.
B)Define the problem.
C)Create an enterprise data model.
D)Specify data needs.

Question 10

Which statement is false concerning database programmers?

A)Database programmers are specialists.
B)The consequences of a programming error could be felt by a very large number of users.
C)Database programmers are often hired as entry- level programmers.
D)Database programmers often write code to strip and/or aggregate data from a database.

Question 11

The term that describes conceptual collections of related data fields is a(n):

A)entity.
B)record.
C)attribute.
D)field.

Question 12

Which view of the data in a database shows one record at a time?

A)queries
B)tables
C)forms
D)reports

Question 13

The term used to describe a request for the database to display selected records is:

A)question.
B)query.
C)sort.
D)filter.

Question 14

Which statement is false concerning the enterprise modeling approach?

A)It takes advantage of a broad view of the firm's data resource.
B)Information systems can easily share data.
C)It addresses problems well.
D)The synergy of the data resources between business areas can be leveraged.

Question 15

Which database feature can be used to limit a user's access to data in the database?

A)sorting
B)OLAP
C)queries
D)filtering

Question 16

The data modeling technique that consists of the named class, fields in the class, and actions that act upon the class is called a(n):

A)class diagram.
B)data flow diagram.
C)object diagram.
D)entity- relationship diagram.

Question 17

Which database structure was never widely adopted by business organizations today?

A)network
B)relational
C)object- oriented
D)hierarchical

Question 18

The duties of the DBA fall into all of the following major areas except for:

A)database security.
B)database implementation.
C)database planning.
D)performance statistics processor.

Question 19

The database administrator's role of offering educational programs to database users and providing assistance when needed falls into which major area?

A)security
B)planning
C)operation
D)implementation

Question 20

Which of the following is a disadvantage of DBMSs?

A)data redundancy
B)data dependence
C)obtain a large hardware configuration
D)more security risks

Question 21

Which database structure was the first database management system developed by GE?

A)relational
B)object- oriented
C)hierarchical
D)network

Question 22

Which statement is false regarding the hierarchical database structure?

A)GE developed it in 1964.
B)It works well when only a few records are needed.
C)The structure can look like branches on a tree.
D)It influenced the work of CODASYL.

Question 23

The term that refers to the definition of data stored within the database and controlled by the database management system is referred to as the:

A)data dictionary.
B)database repository.
C)database concept.
D)database dictionary.

Question 24

typically show one record at a time, do not provide summary data, and generally do not aggregate data from many database tables.

Question 25

are aggregated data from the database that are formatted in a manner that aids decision making.

Question 26

Which of the following is not a common method for accessing the database held in a database management system?

A)reports
B)forms
C)queries
D)tables

Question 27

The database feature that allows data analysis similar to statistical cross- tabulation is:

A)data mining.
B)query.
C)filtering.
D)OLAP.

Question 28

The was developed to allow retrieval of specific records.

Question 29

relationships can be implied from the data.

Question 30

In A includes the definitions of the data stored within the database and controlled by the database management system.

Question 31

A is a collection of files.

Question 32

is a formal process for eliminating redundant data fields while preserving the ability of the database to add, modify, and delete records without causing errors.

Question 33

The advantages of DBMSs include all of the following except for:

A)achieve data independence.
B)reduce hardware costs.
C)reduce data redundancy.
D)improve security.

Question 34

Which of the following is not an advantage of using a database management system?

A)Retrieve data and information rapidly.
B)Achieve data dependence.
C)Reduce data redundancy.
D)Improve security.

Question 35

When changes to the data structure are made without affecting the application programs that process the data, it is referred to as:

A)data consistency.
B)data dependence.
C)data duplication.
D)data independence.

Question 36

A is a request for the database to display selected records.

Question 37

The modeling technique that deals with data in entities and the relationships between entities is referred to as a(n):

A)object diagram.
B)entity- relationship diagram.
C)data flow diagram.
D)class diagram.

Question 38

A is a collection of related records.

Question 39

Which of the following disadvantages of using a database management system becomes less important with each passing year?

A)obtaining expensive software
B)obtaining a large hardware configuration
C)hiring and maintaining a DBA staff
D)the amount of computer resources increases with more users

Question 40

A is a field that uniquely identifies each table row but that was not chosen to be the key.

Question 41

A database management system enables the firm to reduce data redundancy and achieve data dependence.

Question 42

is the ability to make changes in the data structure without making changes to the application programs that process the data.

Question 43

consist of the named class, fields in the class, and actions that act upon the class.

Question 44

The network database structure allows the retrieval of specific records with a given record to point to any other record in the database.

Question 45

Sometimes tables that originally stand alone as independent may later be required to be joined.

Question 46

When a manager wants only a few selected records from the very large number of records in the database, the hierarchical structure is inefficient.

Question 47

Databases reduce in tables.

Question 48

A restrictive definition of a database is the collection of data under the control of database management system software.

Question 49

Structured query language is the method of choice for interacting with Web- based databases.

Question 50

Relational database structures are based on implicit relationships.

Question 51

Entity- relationship diagrams are used to describe relationships between conceptual collections of data so that their related records can be joined together.

Question 52

The logical integration of records across multiple physical locations is called the _.

Question 53

Entity- relationship diagrams give deeper insights into how data and applications work together than do class diagrams.

Question 54

The role of the end user is to maintain a secure database.

Question 55

Subforms help to enforce the accuracy and consistency that databases require.

Question 56

Data mining, data marts, and data warehousing refer to the family of concepts that view the firm's data as a treasure box to be opened, examined, and conquered.

Question 57

Databases store data in single tables to reduce data redundancy.

Question 58

A record is a collection of data files.

Question 59

One of the disadvantages of having a database management system is that a specialized database management staff must be hired and maintained.

Question 60

Firms want database programmers to be chosen from the most skilled personnel available.

Question 61

Structured query language is presented as a standardized form that the user completes to generate a query.

Question 62

Name the key personnel involved with databases and briefly describe their roles.

Question 63

Another name for the process- oriented approach to creating a database is the problem- oriented approach.

Question 64

A database management system is a hardware configuration that stores the structure of the database, the data itself, relationships among data in the database, and forms and reports pertaining to the database.

Question 65

Briefly explain the three database structures discussed in this chapter.

Question 66

Database planning involves working with business area managers to define the firm's data needs.

Question 67

What are the three definitions of a database?

Question 68

IBM developed the first database management system in 1965.

Question 69

The majority of users' interactions with databases are via reports and forms.

Question 70

The strength of the enterprise modeling approach is that it addresses problems well.

Question 71

In practice, entity- relationship diagrams are developed after the database has been created.

Question 72

A flat file is a table that does not have repeating columns.

Question 73

A candidate key is a field that does not uniquely identify each table row and can be used as a key.

Question 74

What are the advantages and disadvantages of database management systems?

Question 75

List the steps that occur for a process- oriented approach to creating a database.

Question 76

Two primary goals of the database concept are to minimize data redundancy and achieve data dependence.

Question 77

Class diagrams are used to describe the data relationships and the actions that operate on the data in the relationships.

Question 78

Data dictionary is the term that refers to the definition of data stored within the database and controlled by the database management system.

Question 79

Database operation represents a high level of specialization and selection.