Question 1

Security is one advantage of partitioning.

Accepted Answer

A) True 
 B)False

Question 2

What is parallel query processing and how is it useful?

Accepted Answer

Since many of today's computers have eit

Question 3

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

Accepted Answer

A) True 
 B)False

Question 4

A view can be built to present only the data to which a user requires access.

Accepted Answer

A) True 
 B)False

Question 5

In a Heap file organization, files are not stored in any particular order.

Accepted Answer

A) True 
 B)False

Question 6

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.

Accepted Answer

A)  query design 
B)  programmer productivity 
C)  data integrity 
D)  data integration 
A)  query design 
B)  programmer productivity 
C)  data integrity 
D)  data integration

Question 7

A detailed coding scheme recognized by system software for representing organizational data is called a(n):

Accepted Answer

A)  DBMS code. 
B)  data type. 
C)  SQL. 
D)  DB layout. 
A)  DBMS code. 
B)  data type. 
C)  SQL. 
D)  DB layout.

Question 8

Database access frequencies are estimated from:

Accepted Answer

A)  transaction volumes. 
B)  user logins. 
C)  security violations. 
D)  random number generation. 
A)  transaction volumes. 
B)  user logins. 
C)  security violations. 
D)  random number generation.

Question 9

Along with table scans, other elements of a query can be processed in parallel.

Accepted Answer

A) True 
 B)False

Question 10

What are the four basic facilities that a database management system should provide for backup and recovery?

Accepted Answer

The four basic facilities are:
1. Backup

Question 11

A factor to consider when choosing a file organization is:

Accepted Answer

A)  inefficient data retrieval. 
B)  DDL. 
C)  efficient storage. 
D)  DML. 
A)  inefficient data retrieval. 
B)  DDL. 
C)  efficient storage. 
D)  DML.

Question 12

A requirement to begin designing physical files and databases is:

Accepted Answer

A)  normalized relations. 
B)  physical tables created. 
C)  implementation complete. 
D)  all datatypes determined. 
A)  normalized relations. 
B)  physical tables created. 
C)  implementation complete. 
D)  all datatypes determined.

Question 13

Discuss three possible opportunities for denormalization.

Accepted Answer

There are several possible situations wh

Question 14

Platform-as-a-service is an approach for providing infrastructure resources and tools for developers to be productive.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is an objective of selecting a data type?

Accepted Answer

A)  Represent a small number of possible values 
B)  Maximize storage space 
C)  Limit security 
D)  Improve data integrity 
A)  Represent a small number of possible values 
B)  Maximize storage space 
C)  Limit security 
D)  Improve data integrity

Question 16

Reduced uptime is a disadvantage of partitioning.

Accepted Answer

A) True 
 B)False

Question 17

Backward recovery starts with an earlier copy of the database.

Accepted Answer

A) True 
 B)False

Question 18

Hash partitioning spreads data evenly across partitions independent of any partition key value.

Accepted Answer

A) True 
 B)False

Question 19

A trigger can be used as a security measure in which of the following ways?

Accepted Answer

A)  To check for viruses 
B)  To cause special handling procedures to be executed 
C)  To design a database 
D)  To conduct a DFD analysis 
A)  To check for viruses 
B)  To cause special handling procedures to be executed 
C)  To design a database 
D)  To conduct a DFD analysis

Question 20

Examination and modification of the SQL code in an application may lead to performance improvements.

Accepted Answer

A) True 
 B)False

Security is one advantage of partitioning.

What is parallel query processing and how is it useful?

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

A view can be built to present only the data to which a user requires access.

In a Heap file organization, files are not stored in any particular order.

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.

A detailed coding scheme recognized by system software for representing organizational data is called a(n):

Database access frequencies are estimated from:

Along with table scans, other elements of a query can be processed in parallel.

What are the four basic facilities that a database management system should provide for backup and recovery?

A factor to consider when choosing a file organization is:

A requirement to begin designing physical files and databases is:

Discuss three possible opportunities for denormalization.

Platform-as-a-service is an approach for providing infrastructure resources and tools for developers to be productive.

Which of the following is an objective of selecting a data type?

Reduced uptime is a disadvantage of partitioning.

Backward recovery starts with an earlier copy of the database.

Hash partitioning spreads data evenly across partitions independent of any partition key value.

A trigger can be used as a security measure in which of the following ways?

Examination and modification of the SQL code in an application may lead to performance improvements.

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

Security is one advantage of partitioning.

What is parallel query processing and how is it useful?

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

A view can be built to present only the data to which a user requires access.

In a Heap file organization, files are not stored in any particular order.

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.

A detailed coding scheme recognized by system software for representing organizational data is called a(n):

Database access frequencies are estimated from:

Along with table scans, other elements of a query can be processed in parallel.

What are the four basic facilities that a database management system should provide for backup and recovery?

A factor to consider when choosing a file organization is:

A requirement to begin designing physical files and databases is:

Discuss three possible opportunities for denormalization.

Platform-as-a-service is an approach for providing infrastructure resources and tools for developers to be productive.

Which of the following is an objective of selecting a data type?

Reduced uptime is a disadvantage of partitioning.

Backward recovery starts with an earlier copy of the database.

Hash partitioning spreads data evenly across partitions independent of any partition key value.

A trigger can be used as a security measure in which of the following ways?

Examination and modification of the SQL code in an application may lead to performance improvements.

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