Question 1

An index on columns from two or more tables that come from the same domain of values is called a:

Accepted Answer

A)  bitmap index. 
B)  multivalued index. 
C)  join index. 
D)  transaction index. 
A)  bitmap index. 
B)  multivalued index. 
C)  join index. 
D)  transaction index.

Question 2

An appropriate datatype for one wanting a fixed-length type for last name would include:

Accepted Answer

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

Question 3

Discuss the advantages and disadvantages of partitioning.

Accepted Answer

Partitioning data has several advantages

Question 4

There are two principal types of authorization tables: one for subjects and one for facts.

Accepted Answer

A) True 
 B)False

Question 5

The smallest unit of named application data is a record.

Accepted Answer

A) True 
 B)False

Question 6

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes.

Accepted Answer

A) True 
 B)False

Question 7

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

Accepted Answer

A) True 
 B)False

An index on columns from two or more tables that come from the same domain of values is called a:

An appropriate datatype for one wanting a fixed-length type for last name would include:

Discuss the advantages and disadvantages of partitioning.

There are two principal types of authorization tables: one for subjects and one for facts.

The smallest unit of named application data is a record.

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes.

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

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

An index on columns from two or more tables that come from the same domain of values is called a:

An appropriate datatype for one wanting a fixed-length type for last name would include:

Discuss the advantages and disadvantages of partitioning.

There are two principal types of authorization tables: one for subjects and one for facts.

The smallest unit of named application data is a record.

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes.

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

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