Question 1

____ is the prevention of unauthorized access to the database.

Accepted Answer

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

Question 2

Which of the following statements is correct?

Accepted Answer

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 3

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

Accepted Answer

The answer of The problem of inconsistency in data is...

Question 4

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.

Accepted Answer

The answer of In an E-R diagram,the ____________________ at the...

Question 5

A relationship is an association between attributes.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of In an E-R diagram,____________________ represent relationships between...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of A program,or collection of programs,through which users...

Question 9

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

Accepted Answer

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

Question 10

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.

Accepted Answer

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

Question 11

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

Accepted Answer

The answer of A good _________________________ has many features that...

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

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.

Accepted Answer

A) True 
 B)False

Question 15

One disadvantage of a database system is ____.

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

An attribute is a characteristic or property of an entity.

Accepted Answer

A) True 
 B)False

Question 18

The attributes of an entity become the rows in the table

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

Exam 1: Introduction to Database Management

____ is the prevention of unauthorized access to the database.

Which of the following statements is correct?

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

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.

A relationship is an association between attributes.

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

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

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

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

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 good _________________________ has many features that allow users to gain access to data in a database without having to do any programming.

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

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

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.

One disadvantage of a database system is ____.

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

An attribute is a characteristic or property of an entity.

The attributes of an entity become the rows in the table

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

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