Question 1

Each partition is stored in a separate contiguous section of disk space,which Oracle calls a(n)________.

Accepted Answer

A)  Database
B)  Tablespace
C)  Table
D)  Index B

Question 2

When merging relations that contain synonyms,we should obtain,if possible,agreement from users on a single standardized name for the attribute and eliminate the other synonym.

Accepted Answer

A) True 
 B)False  True

Question 3

Normalized relations are,of course,the result of ________ database design.

Accepted Answer

A)  Physical
B)  Logical
C)  Conceptual
D)  Conventional B

Question 4

A relation is in first normal form if every non-primary key attribute is functionally dependent on the whole primary key.

Accepted Answer

A) True 
 B)False

Question 5

What information is required to design the physical files and databases related to the project?

Accepted Answer

The answer of What information is required to design the...

Question 6

In a ________ database model,data is represented as a set of related tables or relations.

Accepted Answer

A)  Logical
B)  Conventional
C)  Relational
D)  Physical

Question 7

In ________ normal form,each non-primary key attribute is identified by the whole key (what we call full functional dependency).

Accepted Answer

A)  First
B)  Fourth
C)  Third
D)  Second

Question 8

________ is NOT a valid degree of the relationship.

Accepted Answer

A)  Binary
B)  Unary
C)  N-ary
D)  Ternary

Question 9

The ________ families of file organizations cover most of the file organizations we will have at our disposal as we design physical files and databases.

Accepted Answer

A)  Two
B)  Three
C)  Four
D)  Five

Question 10

There are ________ key steps in logical database modeling and design.

Accepted Answer

A)  Two
B)  Three
C)  Four
D)  Five

Question 11

What is file organization? How does a database designer choose a type of file organization for a specific file?

Accepted Answer

The answer of What is file organization? How does a...

Question 12

A null value is a special field value,similar to a zero,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown.

Accepted Answer

A) True 
 B)False

Question 13

In logical database modeling and design,we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.

Accepted Answer

A)  Summation
B)  Integration
C)  Addition
D)  Combination

Question 14

A functional dependency is a particular relationship between two ________.

Accepted Answer

A)  Attributes
B)  Rows
C)  Databases
D)  Tables

Question 15

Each ________ of a relation corresponds to a record that contains data values for an entity.

Accepted Answer

A)  Column
B)  Entity
C)  Attribute
D)  Row

Question 16

In an object oriented database model,data is represented as a set of related tables or relations.

Accepted Answer

A) True 
 B)False

Question 17

Which relation is created with a composite primary key using the primary keys of the related entities,plus any non-key attributes associative entity of the relationship or associative entity?

Accepted Answer

A)  Associative entity
B)  Associative entity with its own key
C)  Associative entity with additional key
D)  Weak entity

Question 18

A functional dependency between ________ key attributes is also called a transitive dependency.

Accepted Answer

A)  Non-primary
B)  Primary
C)  Composite
D)  Unique

Question 19

In logical database modeling and design,we translate the ________ E-R data model for the application or enterprise,developed without explicit consideration of specific user interfaces,into normalized data requirements.

Accepted Answer

A)  Normal
B)  Physical
C)  Logical
D)  Conceptual

Question 20

Describe the three families of file organization.

Accepted Answer

The answer of Describe the three families of file organization....

Exam 9: Designing Databases

Each partition is stored in a separate contiguous section of disk space,which Oracle calls a(n) ________.

When merging relations that contain synonyms,we should obtain,if possible,agreement from users on a single standardized name for the attribute and eliminate the other synonym.

Normalized relations are,of course,the result of ________ database design.

A relation is in first normal form if every non-primary key attribute is functionally dependent on the whole primary key.

What information is required to design the physical files and databases related to the project?

In a ________ database model,data is represented as a set of related tables or relations.

In ________ normal form,each non-primary key attribute is identified by the whole key (what we call full functional dependency) .

________ is NOT a valid degree of the relationship.

The ________ families of file organizations cover most of the file organizations we will have at our disposal as we design physical files and databases.

There are ________ key steps in logical database modeling and design.

What is file organization? How does a database designer choose a type of file organization for a specific file?

A null value is a special field value,similar to a zero,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown.

In logical database modeling and design,we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.

A functional dependency is a particular relationship between two ________.

Each ________ of a relation corresponds to a record that contains data values for an entity.

In an object oriented database model,data is represented as a set of related tables or relations.

Which relation is created with a composite primary key using the primary keys of the related entities,plus any non-key attributes associative entity of the relationship or associative entity?

A functional dependency between ________ key attributes is also called a transitive dependency.

In logical database modeling and design,we translate the ________ E-R data model for the application or enterprise,developed without explicit consideration of specific user interfaces,into normalized data requirements.

Describe the three families of file organization.