Question 1

​____________________ are restrictions placed on the data that can be stored in the database.

Accepted Answer

​Constraints

Question 2

Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value.​

Accepted Answer

A)   ​primary table
B)   ​fact table
C)   ​dimension table
D)   ​star table C

Question 3

It is possible for local DBMSs to commit updates at some sites and undo updates at other sites.This inconsistency can be prevented by using a ____.​

Accepted Answer

A)   ​two-step rollback
B)   ​two-phase commit
C)   ​two-phase rollback
D)   ​two-phase transaction B

Question 4

A(n)______________________________ is one in which data and the actions that operate on the data are encapsulated into objects.

Accepted Answer

The answer of A(n)______________________________ is one in which data and...

Question 5

​A DDBMS that has at least two sites at which the local DBMS are different is known as a ____.

Accepted Answer

A)   ​homogeneous DDBMS
B)   ​heterogeneous DDBMS
C)   ​holistic DDBMS
D)   ​DDBMS

Question 6

​Each Web page is assigned an Internet address called a Uniform Resource Locator (URL).

Accepted Answer

A) True 
 B)False

Question 7

In order to view and analyze higher levels of aggregate data,you must drill down the data.​

Accepted Answer

A) True 
 B)False

Question 8

​Accessing data using messages over a network is substantially slower than accessing data on a disk.

Accepted Answer

A) True 
 B)False

Question 9

​What are the advantages of distributed databases?

Accepted Answer

The answer of ​What are the advantages of distributed databases?...

Question 10

A local deadlock involves one transaction that requires a record held by a second transaction at one site,while the second transaction requires a record held by the first transaction at a different site.​

Accepted Answer

A) True 
 B)False

Question 11

When a centralized database becomes unavailable for any reason,no users can continue processing.In contrast,if a local database in a distributed database becomes unavailable,only users who need that data are affected.Because of this,distributed databases have a(n)____ advantage over a centralized database.​

Accepted Answer

A)   ​local control of data
B)   ​increasing database capacity
C)   ​system availability
D)   ​added efficiency

Question 12

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

Question 13

To execute the steps in a method,the user sends a(n)____________________ to the object.​

Accepted Answer

The answer of To execute the steps in a method,the...

Question 14

____ is a metalanguage derived from a restricted subset of SGML,and designed for the exchange of data on the Web.​

Accepted Answer

A)   ​UML
B)   ​URL
C)   ​XML
D)   ​HTTP

Question 15

​When computers at one site need to be connected with computers at another site,the connection must be within a ____.

Accepted Answer

A)   ​room
B)   ​building
C)   ​network
D)   ​combination

Question 16

If users are unaware of fragmentation,the DDBMS has fragmentation transparency.​

Accepted Answer

A) True 
 B)False

Question 17

If the client only performs the presentation functions (and not the business functions),then the client is known as a fat client.​

Accepted Answer

A) True 
 B)False

Question 18

A ____ is a subject-oriented,integrated,time-variant,nonvolatile collection of data in support of management's decision-making process.​

Accepted Answer

A)   ​data warehouse
B)   ​thin client
C)   ​back-end processor
D)   ​fat client

Question 19

​The term class refers to the general structure of an object.

Accepted Answer

A) True 
 B)False

Question 20

If the client,in a client/server system,performs the business functions (calculations,etc.),then this client is known as a(n)____.​

Accepted Answer

A)   ​thin client
B)   ​fat client
C)   ​overweight client
D)   ​external client

Exam 9: Database Management Approaches

____________________ are restrictions placed on the data that can be stored in the database.

Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value.

It is possible for local DBMSs to commit updates at some sites and undo updates at other sites.This inconsistency can be prevented by using a ____.

A(n)______________________________ is one in which data and the actions that operate on the data are encapsulated into objects.

A DDBMS that has at least two sites at which the local DBMS are different is known as a ____.

Each Web page is assigned an Internet address called a Uniform Resource Locator (URL).

In order to view and analyze higher levels of aggregate data,you must drill down the data.

Accessing data using messages over a network is substantially slower than accessing data on a disk.

What are the advantages of distributed databases?

A local deadlock involves one transaction that requires a record held by a second transaction at one site,while the second transaction requires a record held by the first transaction at a different site.

Which of the following is an advantage of distributed databases?

To execute the steps in a method,the user sends a(n)____________________ to the object.

____ is a metalanguage derived from a restricted subset of SGML,and designed for the exchange of data on the Web.

When computers at one site need to be connected with computers at another site,the connection must be within a ____.

If users are unaware of fragmentation,the DDBMS has fragmentation transparency.

If the client only performs the presentation functions (and not the business functions),then the client is known as a fat client.

A ____ is a subject-oriented,integrated,time-variant,nonvolatile collection of data in support of management's decision-making process.

The term class refers to the general structure of an object.

If the client,in a client/server system,performs the business functions (calculations,etc.) ,then this client is known as a(n) ____.

Exam 9: Database Management Approaches

​____________________ are restrictions placed on the data that can be stored in the database.

Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value.​

It is possible for local DBMSs to commit updates at some sites and undo updates at other sites.This inconsistency can be prevented by using a ____.​

A(n)______________________________ is one in which data and the actions that operate on the data are encapsulated into objects.

​A DDBMS that has at least two sites at which the local DBMS are different is known as a ____.

​Each Web page is assigned an Internet address called a Uniform Resource Locator (URL).

In order to view and analyze higher levels of aggregate data,you must drill down the data.​

​Accessing data using messages over a network is substantially slower than accessing data on a disk.

​What are the advantages of distributed databases?

A local deadlock involves one transaction that requires a record held by a second transaction at one site,while the second transaction requires a record held by the first transaction at a different site.​

Which of the following is an advantage of distributed databases?​

To execute the steps in a method,the user sends a(n)____________________ to the object.​

____ is a metalanguage derived from a restricted subset of SGML,and designed for the exchange of data on the Web.​

​When computers at one site need to be connected with computers at another site,the connection must be within a ____.

If users are unaware of fragmentation,the DDBMS has fragmentation transparency.​

If the client only performs the presentation functions (and not the business functions),then the client is known as a fat client.​

A ____ is a subject-oriented,integrated,time-variant,nonvolatile collection of data in support of management's decision-making process.​

​The term class refers to the general structure of an object.

If the client,in a client/server system,performs the business functions (calculations,etc.) ,then this client is known as a(n) ____.​

____________________ are restrictions placed on the data that can be stored in the database.

Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value.

It is possible for local DBMSs to commit updates at some sites and undo updates at other sites.This inconsistency can be prevented by using a ____.

A DDBMS that has at least two sites at which the local DBMS are different is known as a ____.

Each Web page is assigned an Internet address called a Uniform Resource Locator (URL).

In order to view and analyze higher levels of aggregate data,you must drill down the data.

Accessing data using messages over a network is substantially slower than accessing data on a disk.

What are the advantages of distributed databases?

A local deadlock involves one transaction that requires a record held by a second transaction at one site,while the second transaction requires a record held by the first transaction at a different site.

Which of the following is an advantage of distributed databases?

To execute the steps in a method,the user sends a(n)____________________ to the object.

____ is a metalanguage derived from a restricted subset of SGML,and designed for the exchange of data on the Web.

When computers at one site need to be connected with computers at another site,the connection must be within a ____.

If users are unaware of fragmentation,the DDBMS has fragmentation transparency.

If the client only performs the presentation functions (and not the business functions),then the client is known as a fat client.

A ____ is a subject-oriented,integrated,time-variant,nonvolatile collection of data in support of management's decision-making process.

The term class refers to the general structure of an object.

If the client,in a client/server system,performs the business functions (calculations,etc.) ,then this client is known as a(n) ____.