Deck 1: Introduction to Database Management

Question 1

A(n) ____ is a person,place,object,event,or idea for which you want to store and process data.

A)attribute
B)DBMS
C)entity
D)DBA

Answer 1

C

Question 2

Eliminating redundancy is always possible when using a database approach.

Answer 2

False

Question 3

A database will not only hold information about multiple types of entities,but also information about the relationships among these multiple entities.

Answer 3

True

Question 4

An attribute is a characteristic or property of an entity.

Question 5

A spreadsheet's data-sharing features allows multiple employees to update data in one spreadsheet at the same time.

Question 6

There is a greater impact of failure in a nondatabase,file-oriented system.

Question 7

Redundancy wastes space because you are storing the same data in more than one place.

Question 8

Programs created with Visual Basic,Java,Perl,PHP,or C++ can access the database directly,rather than having to access it through the DBMS.

Question 9

In a database,each entity has its own table.

Question 10

A database cannot be password protected to prevent unauthorized users from accessing the data.

Question 11

Storing the same data in more than one place is called ____.

A)data independence
B)data integrity
C)redundancy
D)security

Question 12

A relationship is an association between attributes.

Question 13

Sharing data is one advantage of database processing.

Question 14

A good DBMS provides integrity constraints,which are features that let you change the structure of the database without changing the programs that access the database.

Question 15

A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger.

A)spreadsheet
B)database
C)data file
D)attribute

Question 16

The ____ of an entity become the columns in the database table.

A)E-R diagrams
B)tuples
C)data files
D)attributes

Question 17

In an entity-relationship (E-R) diagram,rectangles represent entities and lines represent relationships between connected entities.

Question 18

To support all the complex functions that it provides to users,a DBMS must store data in multiple files.

Question 19

A(n) ____ is a characteristic or property of an entity.

A)attribute
B)constraint
C)datapoint
D)record

Question 20

The attributes of an entity become the rows in the table

Question 21

____ are screen objects used to maintain,view,and print data from a database.

A)Forms
B)Fields
C)Data files
D)Entities

Question 22

An integrity constraint is a rule that ____.

A)is kept in an external file
B)can unintentionally be accessed by unauthorized users
C)can be accessed only by authorized users
D)data must follow in the database

Question 23

A visual way to represent a database is with a(n) ____.

A)spreadsheet
B)DBMS
C)DBA
D)entity-relationship diagram

Question 24

____ is the prevention of unauthorized access to the database.

A)Data independence
B)Integrity constraint
C)Redundancy
D)Security

Question 25

Which of the following statements is correct?

A)In a nondatabase,file-oriented environment,data is often partitioned into several disjointed systems with each system having its own collection of files.
B)User data cannot be combined and shared among authorized users.
C)Database users should not have access to the same information.
D)The elimination of redundancy is always possible.

Question 26

In an E-R diagram,the ____________________ at the end of a line indicates the "many" part of the one-to-many relationship between two entities.

Question 27

A database has ____ if the data in it satisfies all established integrity constraints.

A)redundancy
B)integrity
C)data independence
D)database design

Question 28

A DBMS lets you assign users to ____.

A)groups
B)classes
C)attributes
D)clusters

Question 29

During the ____ process,a database expert determines the structure of the required database.

A)data security
B)database integrity
C)database design
D)database selection

Question 30

In an E-R diagram,____________________ represent entities.

Question 31

____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.

A)Data independence
B)Integrity constraint
C)Database design
D)Data dependence

Question 32

A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities,such as adding new data and deleting existing data.

A)DBA
B)E-R diagram
C)entity
D)DBMS

Question 33

An association between entities is known as a(n) ____.

A)integrity constraint
B)relationship
C)database
D)data file

Question 34

A person who is in charge of a database within an organization is often called the database ____.

A)writer
B)administrator
C)designer
D)controller

Question 35

Popular ____ include Access,Oracle,DB2,MySQL,and SQL Server.

A)E-R diagrams
B)DBAs
C)DBMSs
D)data files

Question 36

In an E-R diagram,____________________ represent relationships between connected entities.

Question 37

One disadvantage of a database system is ____.

A)a larger file size
B)data dependence
C)reduced integrity
D)reduced productivity

Question 38

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.

A)database administrator
B)DBA
C)E-R diagram
D)DBMS

Question 39

A group of people in charge of a database within an organization is often called the ____________________.

Question 40

A program,or collection of programs,through which users interact with a database is known as a(n) _________________________.

Question 41

In a(n) ____________________ relationship between two entities,each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.

Question 42

Eliminating ____________________ not only saves space but also makes the process of updating data much simpler.

Question 43

List the advantages of database processing.

Question 44

Explain why the impact of failure is greater in database processing,compared with the nondatabase approach.

Question 45

List the disadvantages of database processing.

Question 46

A database file requires a large amount of disk space and internal ____________________.

Question 47

Explain why it is better to try to control redundancy rather than eliminate it.

Question 48

A good _________________________ has many features that allow users to gain access to data in a database without having to do any programming.

Question 49

Discuss how the database approach and the nondatabase approach differ in terms of ensuring the security of the database.

Question 50

The problem of inconsistency in data is a direct result of ____________________.