Question 1

The steps taken by the DDBMS to update the various copies of data should be done behind the scenes; this is called _____________________ transparency.

Accepted Answer

replication

Question 2

A(n) ____________________ is the set of values that are permitted for an attribute.

Accepted Answer

domain

Question 3

Which rule for distributed databases states that no site should depend on another site to perform its database functions?

Accepted Answer

A)  Distributed transaction management 
B)  Local autonomy 
C)  Operating system independence 
D)  Network independence 
A)  Distributed transaction management 
B)  Local autonomy 
C)  Operating system independence 
D)  Network independence B

Question 4

With respect to the definition of data warehouse, which of the following means that data in a data warehouse represents periodic snapshots of the data, such as at the end of each month?

Accepted Answer

A)  nonvolatile 
B)  time-variant 
C)  subject-oriented 
D)  integrated 
A)  nonvolatile 
B)  time-variant 
C)  subject-oriented 
D)  integrated

Question 5

If data is loaded into a data warehouse periodically, but users cannot update a data warehouse directly, the data is said to be volatile.

Accepted Answer

A) True 
 B)False

Question 6

____________________ means that you define an object to contain both the data and its associated actions.

Accepted Answer

The answer of ____________________ means that you define an object...

Question 7

A subclass inherits the structure of a class but not its methods.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is an advantage of distributed databases?

Accepted Answer

A)  local control of data 
B)  easier updates of replicated data 
C)  more complex query processing 
D)  more complex treatment of concurrent updates 
A)  local control of data 
B)  easier updates of replicated data 
C)  more complex query processing 
D)  more complex treatment of concurrent updates

Question 9

A characteristic of a DDBMS that states that users do not need to be aware of the location of the data in a database is known as replication transparency.

Accepted Answer

A) True 
 B)False

Question 10

In a centralized database design, what should you try to minimize to increase data access speed?

Accepted Answer

A)  the speed of the disk drive 
B)  the number of network messages 
C)  the number of disk accesses 
D)  the amount of memory used 
A)  the speed of the disk drive 
B)  the number of network messages 
C)  the number of disk accesses 
D)  the amount of memory used

Question 11

What is the process of uncovering new knowledge, patterns, trends, and rules from the data stored in a data warehouse known as?

Accepted Answer

A)  fragmentation transparency 
B)  replication transparency 
C)  polymorphism 
D)  data mining 
A)  fragmentation transparency 
B)  replication transparency 
C)  polymorphism 
D)  data mining

Question 12

In which type of system are the data and actions encapsulated?

Accepted Answer

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

Question 13

Access to a data warehouse is accomplished through the use of OLAP software.

Accepted Answer

A) True 
 B)False

Question 14

Which rule for distributed databases states that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database?

Accepted Answer

A)  Continuous operation 
B)  Local autonomy 
C)  Location transparency 
D)  Fragmentation transparency 
A)  Continuous operation 
B)  Local autonomy 
C)  Location transparency 
D)  Fragmentation transparency

Question 15

With ____________________ visibility, only the class itself can view or update the value.

Accepted Answer

The answer of With ____________________ visibility, only the class itself...

Question 16

Which of the following refers to the association of an operation to actual program code?

Accepted Answer

A)  attaching 
B)  matching 
C)  linking 
D)  binding 
A)  attaching 
B)  matching 
C)  linking 
D)  binding

Question 17

With ____________________ visibility, any other class can view or update the value of an attribute.

Accepted Answer

The answer of With ____________________ visibility, any other class can...

Question 18

What is the overall structure of the fact table and dimension tables called?

Accepted Answer

A)  class schema 
B)  data model 
C)  star schema 
D)  object model 
A)  class schema 
B)  data model 
C)  star schema 
D)  object model

Question 19

What is the main purpose of data fragmentation?

Accepted Answer

A)  to make it easier for users to access remote data 
B)  to place data at the location where the data is least often accessed 
C)  to place data at the location where the data is most often accessed 
D)  to make data access faster, whether it is local or remote 
A)  to make it easier for users to access remote data 
B)  to place data at the location where the data is least often accessed 
C)  to place data at the location where the data is most often accessed 
D)  to make data access faster, whether it is local or remote

Question 20

An advantage of a distributed database is that the database can handle more complex query processing.

Accepted Answer

A) True 
 B)False

The steps taken by the DDBMS to update the various copies of data should be done behind the scenes; this is called _____________________ transparency.

A(n) ____________________ is the set of values that are permitted for an attribute.

Which rule for distributed databases states that no site should depend on another site to perform its database functions?

With respect to the definition of data warehouse, which of the following means that data in a data warehouse represents periodic snapshots of the data, such as at the end of each month?

If data is loaded into a data warehouse periodically, but users cannot update a data warehouse directly, the data is said to be volatile.

____________________ means that you define an object to contain both the data and its associated actions.

A subclass inherits the structure of a class but not its methods.

Which of the following is an advantage of distributed databases?

A characteristic of a DDBMS that states that users do not need to be aware of the location of the data in a database is known as replication transparency.

In a centralized database design, what should you try to minimize to increase data access speed?

What is the process of uncovering new knowledge, patterns, trends, and rules from the data stored in a data warehouse known as?

In which type of system are the data and actions encapsulated?

Access to a data warehouse is accomplished through the use of OLAP software.

Which rule for distributed databases states that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database?

With ____________________ visibility, only the class itself can view or update the value.

Which of the following refers to the association of an operation to actual program code?

With ____________________ visibility, any other class can view or update the value of an attribute.

What is the overall structure of the fact table and dimension tables called?

What is the main purpose of data fragmentation?

An advantage of a distributed database is that the database can handle more complex query processing.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Filters

Exam 9: Database Management Approaches

The steps taken by the DDBMS to update the various copies of data should be done behind the scenes; this is called _____________________ transparency.

A(n) ____________________ is the set of values that are permitted for an attribute.

Which rule for distributed databases states that no site should depend on another site to perform its database functions?

With respect to the definition of data warehouse, which of the following means that data in a data warehouse represents periodic snapshots of the data, such as at the end of each month?

If data is loaded into a data warehouse periodically, but users cannot update a data warehouse directly, the data is said to be volatile.

____________________ means that you define an object to contain both the data and its associated actions.

A subclass inherits the structure of a class but not its methods.

Which of the following is an advantage of distributed databases?

A characteristic of a DDBMS that states that users do not need to be aware of the location of the data in a database is known as replication transparency.

In a centralized database design, what should you try to minimize to increase data access speed?

What is the process of uncovering new knowledge, patterns, trends, and rules from the data stored in a data warehouse known as?

In which type of system are the data and actions encapsulated?

Access to a data warehouse is accomplished through the use of OLAP software.

Which rule for distributed databases states that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database?

With ____________________ visibility, only the class itself can view or update the value.

Which of the following refers to the association of an operation to actual program code?

With ____________________ visibility, any other class can view or update the value of an attribute.

What is the overall structure of the fact table and dimension tables called?

What is the main purpose of data fragmentation?

An advantage of a distributed database is that the database can handle more complex query processing.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Filters