Question 1

A disadvantage of partitioning is:

Accepted Answer

A)  simplicity. 
B)  remote optimization. 
C)  extra space and update time. 
D)  shorter technology spans. 
A)  simplicity. 
B)  remote optimization. 
C)  extra space and update time. 
D)  shorter technology spans.

Question 2

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

Accepted Answer

A) True 
 B)False

Question 3

The value a field will assume unless the user enters an explicit value for an instance of that field is called a:

Accepted Answer

A)  default value. 
B)  null value. 
C)  range control. 
D)  gurand. 
A)  default value. 
B)  null value. 
C)  range control. 
D)  gurand.

Question 4

A method to allow adjacent secondary memory space to contain rows from several tables is called:

Accepted Answer

A)  cluttering. 
B)  clustering. 
C)  concatenating. 
D)  compiling. 
A)  cluttering. 
B)  clustering. 
C)  concatenating. 
D)  compiling.

Question 5

A checkpoint facility is a facility by which the DBMS refuses to accept any new transactions.

Accepted Answer

A) True 
 B)False

Question 6

Explain what primary, secondary and unique key indexes are.

Accepted Answer

A primary key index is automatically gen

Question 7

Guidelines for server security should include all of the following EXCEPT:

Accepted Answer

A)  securing the network between client and server. 
B)  guidelines for password lengths. 
C)  password naming conventions. 
D)  guidelines for frequency of password changes. 
A)  securing the network between client and server. 
B)  guidelines for password lengths. 
C)  password naming conventions. 
D)  guidelines for frequency of password changes.

Question 8

An appropriate datatype for adding a sound clip would be:

Accepted Answer

A)  VARCHAR. 
B)  CHAR. 
C)  BLOB. 
D)  DATE. 
A)  VARCHAR. 
B)  CHAR. 
C)  BLOB. 
D)  DATE.

Question 9

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

Accepted Answer

A)  secondary key. 
B)  index. 
C)  composite key. 
D)  linked key. 
A)  secondary key. 
B)  index. 
C)  composite key. 
D)  linked key.

Question 10

The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database.

Accepted Answer

A) True 
 B)False

Question 11

Controls designed to restrict access and activities are called:

Accepted Answer

A)  schemas. 
B)  business rules. 
C)  encryption controls. 
D)  authorization rules. 
A)  schemas. 
B)  business rules. 
C)  encryption controls. 
D)  authorization rules.

Question 12

Discuss coding techniques and how they could be used.

Accepted Answer

Coding techniques are used in cases when

Question 13

Requirements for response time, data security, backup, and recovery are all requirements for physical design.

Accepted Answer

A) True 
 B)False

Question 14

What is a journalizing facility?

Accepted Answer

A journalizing facility provides an audi

Question 15

A file organization is a named portion of primary memory.

Accepted Answer

A) True 
 B)False

Question 16

All of the following are advantages to cloud-based computing EXCEPT:

Accepted Answer

A)  no need for initial investment in hardware, physical facilities and systems software. 
B)  elasticity. 
C)  organizations can explore new data management technologies more easily. 
D)  ACID support for database as a service. 
A)  no need for initial investment in hardware, physical facilities and systems software. 
B)  elasticity. 
C)  organizations can explore new data management technologies more easily. 
D)  ACID support for database as a service.

Question 17

All of the following are disadvantages to cloud-based computing EXCEPT:

Accepted Answer

A)  the promise of elasticity is not fulfilled because the model will not adapt to changing requirements. 
B)  live migration from one environment to another is a challenge. 
C)  DBaaS is still struggling to provide ACID properties of databases. 
D)  the visibility of costs of data management is better. 
A)  the promise of elasticity is not fulfilled because the model will not adapt to changing requirements. 
B)  live migration from one environment to another is a challenge. 
C)  DBaaS is still struggling to provide ACID properties of databases. 
D)  the visibility of costs of data management is better.

Question 18

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

Accepted Answer

A) True 
 B)False

Question 19

Forward recovery is faster than restore/rerun because:

Accepted Answer

A)  transactions do not have to be repeated. 
B)  security can be avoided. 
C)  images are mirrored. 
D)  systems are more complete. 
A)  transactions do not have to be repeated. 
B)  security can be avoided. 
C)  images are mirrored. 
D)  systems are more complete.

Question 20

Unlimited bandwidth is a characteristic of cloud computing.

Accepted Answer

A) True 
 B)False

A disadvantage of partitioning is:

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

The value a field will assume unless the user enters an explicit value for an instance of that field is called a:

A method to allow adjacent secondary memory space to contain rows from several tables is called:

A checkpoint facility is a facility by which the DBMS refuses to accept any new transactions.

Explain what primary, secondary and unique key indexes are.

Guidelines for server security should include all of the following EXCEPT:

An appropriate datatype for adding a sound clip would be:

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database.

Controls designed to restrict access and activities are called:

Discuss coding techniques and how they could be used.

Requirements for response time, data security, backup, and recovery are all requirements for physical design.

What is a journalizing facility?

A file organization is a named portion of primary memory.

All of the following are advantages to cloud-based computing EXCEPT:

All of the following are disadvantages to cloud-based computing EXCEPT:

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

Forward recovery is faster than restore/rerun because:

Unlimited bandwidth is a characteristic of cloud computing.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 8: Physical Database Design and Database Infrastructure

A disadvantage of partitioning is:

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

The value a field will assume unless the user enters an explicit value for an instance of that field is called a:

A method to allow adjacent secondary memory space to contain rows from several tables is called:

A checkpoint facility is a facility by which the DBMS refuses to accept any new transactions.

Explain what primary, secondary and unique key indexes are.

Guidelines for server security should include all of the following EXCEPT:

An appropriate datatype for adding a sound clip would be:

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database.

Controls designed to restrict access and activities are called:

Discuss coding techniques and how they could be used.

Requirements for response time, data security, backup, and recovery are all requirements for physical design.

What is a journalizing facility?

A file organization is a named portion of primary memory.

All of the following are advantages to cloud-based computing EXCEPT:

All of the following are disadvantages to cloud-based computing EXCEPT:

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

Forward recovery is faster than restore/rerun because:

Unlimited bandwidth is a characteristic of cloud computing.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters