Question 1

Attributes are usually selected to capture the relevant characteristics of entities.

Accepted Answer

A) True 
 B)False

Question 2

Shauna is the Database Administrator for an online store that sells cosmetics. They grew so fast that they ended up with seven different databases, and Shauna is now investigating how to set up a centralized database approach.
-One of the first benefits to a centralized database approach that Shauna discovers is the relationship between the data and the application program. All of the following statements are true EXCEPT: ____.

Accepted Answer

A)  The DBMS organizes the data independently of the application program 
B)  The application program is altered automatically by the location of data 
C)  The application program is not affected by the type of data 
D)  Introduction of new types of data not relevant to a particular application does not require the rewriting of that application to maintain compatibility with the data file

Question 3

The functions of a DBMS include all of the following EXCEPT: ____.

Accepted Answer

A)  Ensuring that the data is protected and safe from attacks and unauthorized access 
B)  Providing artificial intelligence to help with structured and unstructured decisions 
C)  Storing important data for individuals, groups, and organizations 
D)  Performing routine tasks

Question 4

-Referring to the figure above, it is clear that ____ are combined to make a field.

Accepted Answer

A)  characters 
B)  records 
C)  files 
D)  databases

Question 5

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

Accepted Answer

A)  key 
B)  attribute 
C)  field 
D)  record

Question 6

Object-relational databases combine features of the object-oriented model with the relational model. _________________________

Accepted Answer

A) True 
 B)False

Question 7

A database, a DBMS, and the application programs that utilize the data in the database make up a database ____.

Accepted Answer

A)  system 
B)  environment 
C)  either a. or b. 
D)  neither a. nor b.

Question 8

Credit card companies use the customer's credit card expiration date as the primary key. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Oracle, Sybase, and IBM databases are examples of ____ database software that can be used by most organizations for many different types of applications.

Accepted Answer

A)  special-purpose 
B)  general-purpose 
C)  industry-specific 
D)  relationship-specific

Question 10

In general, a data ____ language is a specific language provided with the DBMS that allows people and other database users to access, modify, and make queries about data contained in the database and to generate reports.

Accepted Answer

A)  management 
B)  manipulation 
C)  query 
D)  table

Question 11

A(n) ____ application interacts with other programs and databases; it interacts only indirectly with users.

Accepted Answer

A)  front-end 
B)  back-end 
C)  relationship 
D)  employee

Question 12

____ of data is a measure of the changes, such as additions, deletions, or modifications, typically required in a given period of time.

Accepted Answer

A)  Normalization 
B)  Depth 
C)  Breadth 
D)  Volatility

Question 13

Sky computing refers to accessing data and information services from the Internet utilizing a standard Web-based interface.

Accepted Answer

A) True 
 B)False

Question 14

A collection of related records is a file, also called a ____ in some databases.

Accepted Answer

A)  table 
B)  chart 
C)  set 
D)  query

Question 15

A(n) ____ is a field in a record that is used to identify the record.

Accepted Answer

A)  key 
B)  entity 
C)  character 
D)  attribute

Question 16

The object-oriented model encapsulates ____ functionality in software objects.

Accepted Answer

A)  data 
B)  database functionality 
C)  both a. and b. 
D)  neither a. nor b.

Question 17

Good data should be all of these EXCEPT: ____.

Accepted Answer

A)  redundant 
B)  flexible 
C)  simple 
D)  adaptable to different applications

Question 18

A(n) ____ consists of a group of programs that manipulate the database and provide an interface between the database and the user or the database and application programs.

Accepted Answer

A)  DBA 
B)  DBMS 
C)  GIGO 
D)  SQL

Question 19

How is data organized when using a relational database model? Please define these terms as they are used when working with relational databases: relations, selecting, and joining.

Accepted Answer

The answer of How is data organized when using a...

Question 20

Employee number, last name, first name, hire date, and department number are ____ for an employee.

Accepted Answer

A)  attributes 
B)  keys 
C)  characters 
D)  entities

Exam 7: Database Systems

Attributes are usually selected to capture the relevant characteristics of entities.

The functions of a DBMS include all of the following EXCEPT: ____.

-Referring to the figure above, it is clear that ____ are combined to make a field.

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

Object-relational databases combine features of the object-oriented model with the relational model. _________________________

A database, a DBMS, and the application programs that utilize the data in the database make up a database ____.

Credit card companies use the customer's credit card expiration date as the primary key. _________________________

Oracle, Sybase, and IBM databases are examples of ____ database software that can be used by most organizations for many different types of applications.

In general, a data ____ language is a specific language provided with the DBMS that allows people and other database users to access, modify, and make queries about data contained in the database and to generate reports.

A(n) ____ application interacts with other programs and databases; it interacts only indirectly with users.

____ of data is a measure of the changes, such as additions, deletions, or modifications, typically required in a given period of time.

Sky computing refers to accessing data and information services from the Internet utilizing a standard Web-based interface.

A collection of related records is a file, also called a ____ in some databases.

A(n) ____ is a field in a record that is used to identify the record.

The object-oriented model encapsulates ____ functionality in software objects.

Good data should be all of these EXCEPT: ____.

A(n) ____ consists of a group of programs that manipulate the database and provide an interface between the database and the user or the database and application programs.

How is data organized when using a relational database model? Please define these terms as they are used when working with relational databases: relations, selecting, and joining.

Employee number, last name, first name, hire date, and department number are ____ for an employee.