Chapter 9 Potential Test Questions

To designate a foreign key in a relation, the name contains ________. A) A dash B) An arrow C) A circle D) A functional dependency

A) A dash

Which relation is created with a composite primary key using the primary keys of the related entities, plus any nonkey attributes associative entity of the relationship or associative entity? A) Associative entity B) Associative entity with its own key C) Associative entity with additional key D) Weak entity

A) Associative entity

A functional dependency is a particular relationship between two ________. A) Attributes B) Rows C) Databases D) Tables

A) Attributes

In most situations, many physical database design decisions are implicit or eliminated when we choose the ________ technologies to use with the application. A) Data management B) System management C) Software management D) SDLC

A) Data management

During logical database design, you must account for every data element on a system input or output form or report and on the ________. A) E-R diagram B) Conceptual design C) Physical design D) Logical design

A) E-R diagram

Thinking about attributes, which of the following is an example of a synonym? A) EMP_ID and Employee_ID B) Student_ID and Matriculation_Name C) Billing_Address and Shipping_Address D) Pet_Name and Type_Of_Pet

A) EMP_ID and Employee_ID

What is the result of normalization? A) Every nonprimary key attribute depends on the whole primary key and nothing but the primary key. B) All tables have a primary key. C) Hierarchal databases are converted to relational databases. D) Each table can only be used by one user.

A) Every nonprimary key attribute depends on the whole primary key and nothing but the primary key.

A default value is the value that a ________ will assume unless an explicit value is entered for it. A) Field B) Row C) Table D) Data type

A) Field

A(n) ________ must satisfy referential integrity, which specifies that the value of an attribute in one relation depends on the value of the same attribute in another relation. A) Foreign key B) Primary key C) Unique key D) Index

A) Foreign key

In some situations, a single attribute name, called a(n) ________, may have more than one meaning or describe more than one characteristic. A) Homonym B) Antonym C) Synonym D) Duplicate

A) Homonym

A(n) ________ is a file organization in which rows are stored either sequentially or non- sequentially, and an index is created that allows software to locate individual rows. A) Indexed file organization B) Sequential file organization C) Hashed file organization D) Physical file

A) Indexed file organization

________ database design is driven not only from the previously developed E-R data model for the application or enterprise but also from form and report layouts. A) Logical B) Physical C) Normalized D) De-normalized

A) Logical

The capability to split a table into separate sections, often called ________, is possible with most relational database products. A) Partitioning B) Splitting C) Combining D) Normalizing

A) Partitioning

Which relation is created with primary key and nonkey attributes only? A) Regular entity B) Weak entity C) Sub-type D) Associative entity

A) Regular entity

In a relation, the sequence of columns can be interchanged without changing the meaning or use of the ________. A) Relation B) Attribute C) Row D) Primary key

A) Relation

A unary relationship is a relationship between the instances of a ________ entity type, which are also called recursive relationships. A) Single B) Double C) Triple D) Many

A) Single

A relation is a named, ________-dimensional table of data. Each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows. A) Two B) One C) Three D) Four

A) Two

A relation is in ________ if every non-primary key attribute is functionally dependent on the whole primary key. A) 1NF B) 2NF C) 3NF D) 4NF

B) 2NF

Which relation is created with the primary key associated with the relationship or associative entity, plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities (as foreign key attributes)? A) Associative entity B) Associative entity with its own key C) Associative entity with additional key D) Binary 1:N relationship

B) Associative entity with its own key

Which of the following is a key step in logical database modeling and design? A) Develop a physical data model for each known user interface. B) Compare the consolidated logical database design with the translated E-R model to produce one final logical database model for the application. C) Translate the mental database. D) Combine all tables into one big table.

B) Compare the consolidated logical database design with the translated E-R model to produce one final logical database model for the application.

A database designer chooses a file organization for a specific file that will provide which of the following?A) Slow data retrieval B) Efficient use of storage space C) Maximum need for reorganization D) Security from authorized users

B) Efficient use of storage space

A(n) ________ is the smallest unit of application data recognized by system software, such as a programming language or database management system. A) Table B) Field C) Row D) Index

B) Field

A binary one-to-many (1:N) relationship in an E-R diagram is represented by adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a(n) ________ in the relation that is on the many side of the relationship. A) Primary key B) Foreign key C) Unique key D) Index

B) Foreign key

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) Summation B) Integration C) Addition D) Combination

B) Integration

Normalized relations are, of course, the result of ________ database design. A) Physical B) Logical C) Conceptual D) Conventional

B) Logical

________ is a process for converting complex data structures into simple, stable data structures. A) De-normalization B) Normalization C) Database modeling D) Relation

B) Normalization

A ________ table is a named set of rows and columns that specifies the fields in each row of the table. A) Conceptual B) Physical C) Relational D) Logical

B) Physical

Logical and ________ database design is typically performed in parallel with other systems design steps. A) Normal B) Physical C) Conceptual D) Normalized

B) Physical

What is the relational representation for a binary relationship in the E-R structure? A) Create a relation for the superclass. B) Place the primary key of either entity in the relation for the other entity. C) Create a relation for the primary key. D) Create a relation with non-key attributes.

B) Place the primary key of either entity in the relation for the other entity.

A(n) ________ is a field of data that can be used to locate a related field or row of data. A) Index B) Pointer C) Secondary key D) Attribute

B) Pointer

A(n) ________ is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation. A) Composite key B) Primary key C) Identifier D) Index

B) Primary key

Each regular entity type in an E-R diagram is transformed into a(n) ________. A) Identifier B) Relation C) Attribute D) Row

B) Relation

Entries in cells are simple and an entry at the intersection of each row and column has a ________ value. A) Duplicate B) Single C) Multi D) Repeating

B) Single

Each partition is stored in a separate contiguous section of disk space, which Oracle calls a(n) ________. A) Database B) Tablespace C) Table D) Index

B) Tablespace

The ________ families of file organizations cover most of the file organizations we will have at our disposal as we design physical files and databases. A) Two B) Three C) Four D) Five

B) Three

Which relation is created by placing the primary key of either entity in the relation for the other entity or by doing this for both entities? A) Binary 1:N relationship B) Unary 1:1 relationship C) Weak entity D) Associative entity with additional key

B) Unary 1:1 relationship

Which relation is created by placing the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side? A) Associative entity B) Weak entity C) Binary 1:N relationship D) Associative entity with additional key

C) Binary 1:N relationship

________ is NOT a valid type of partitioning method in relational database products. A) Range B) Hash C) Boundary D) Composite

C) Boundary

Each ________ in a relation corresponds to an attribute of that relation. A) Entity B) Data C) Column D) Row

C) Column

A(n) ________ is a coding scheme recognized by system software for representing organizational data. A) Data model B) Attribute C) Data type D) Field

C) Data type

A ________ is an attribute that appears as a non-primary key attribute in one relation and as a primary key attribute (or part of a primary key) in another relation. A) Referential integrity B) Primary key C) Foreign key D) Unique key

C) Foreign key

There are ________ key steps in logical database modeling and design. A) Two B) Three C) Four D) Five

C) Four

All of these are types of database models except ________. A) Hierarchical model B) Network model C) Matrix model D) Relational model

C) Matrix model

________ is NOT a valid degree of the relationship. A) Binary B) Unary C) N-ary D) Ternary

C) N-ary

A ________ value is a special field value, distinct from zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown. A) Key B) True C) Null D) Default

C) Null

A recursive foreign key is a foreign key in a relation that references the ________ values of that same relation. A) Nonprimary key B) Unique key C) Primary key D) Foreign key

C) Primary key

Cindy tried to delete a customer but the customer still had open invoices so the system would not allow her to delete the customer. More than likely ________ was enforced. A) De-normalization B) Normalization C) Referential integrity D) Relational management

C) Referential integrity

The most common style for a logical database is the ________ model. A) Data B) E-R C) Relational database D) Layout

C) Relational database

A(n) ________ is one field or a combination of fields for which more than one row may have the same combination of values. A) Index B) Primary key C) Secondary key D) Pointer

C) Secondary key

In some situations, two or more attributes may have different names but the same meaning, as when they describe the same characteristic of an entity. Such attributes are called ________. A) Homonyms B) Antonyms C) Synonyms D) Duplicates

C) Synonyms

A well-structured relation is a relation that contains a minimum amount of redundancy and that allows users to insert, modify, and delete the rows without error or inconsistencies and is also known as a ________. A) Column B) Row C) Table D) Key

C) Table

In ________ normal form, nonprimary key attributes do not depend on each other (what we call no transitive dependencies). A) First B) Fourth C) Third D) Second

C) Third

Which relation is created with a composite primary key using the primary keys of the related entities and additional primary key attributes associated with the relationship or associative entity, plus any non-key attributes of the relationship or associative entity? A) Binary 1:N relationship B) Associative entity C) Associative entity with its own key D) Associative entity with additional key

D) Associative entity with additional key

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. A) Normal B) Physical C) Logical D) Conceptual

D) Conceptual

________ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields. A) Partitioning B) Modeling C) Normalization D) Denormalization

D) Denormalization

All of these are steps to transforming an E-R diagram into normalized relations except ________. A) Represent relationships B) Represent entities C) Merge the relations D) Denormalize the relations

D) Denormalize the relations

Which of the following is an example of a primary key? A) Number of children B) Physical address C) Last name D) Driver's license number

D) Driver's license number

We begin the physical design phase by addressing the design of physical fields for each attribute in a ________ data model. A) Conventional B) Conceptual C) Physical D) Logical

D) Logical

The result of normalization is that every ________ key attribute depends upon the whole primary key. A) Candidate B) Unique C) Primary D) Nonprimary

D) Nonprimary

The key should be ________; that is, no attribute in the key can be deleted without destroying its unique identification. A) De-normalized B) Normalized C) Redundant D) Nonredundant

D) Nonredundant

In logical database design, we use a process called ________, which is a way to build a data model that has the properties of simplicity, non-redundancy, and minimal maintenance. A) Data modeling B) Database designing C) De-normalization D) Normalization

D) Normalization

A computer operating system stores data in a ________, which is a named set of table rows stored in a contiguous section of secondary memory. A) Disk B) Tablespace C) Table D) Physical file

D) Physical file

In a relation, each row is unique and uniqueness is guaranteed because the relation has a non- empty ________ key value. A) Unique B) Composite C) Candidate D) Primary

D) Primary

Each entity type in the E-R diagram becomes a relation. The identifier of the entity type becomes the ________ of the relation, and other attributes of the entity type become non-primary key attributes of the relation. A) Foreign key B) Index C) Unique key D) Primary key

D) Primary key

Each ________ of a relation corresponds to a record that contains data values for an entity. A) Column B) Entity C) Attribute D) Row

D) Row

In a hashed file organization, the location of each ________ is determined using an algorithm. A) Constraint B) Key C) Column D) Row

D) Row

In ________ normal form, each nonprimary key attribute is identified by the whole key (what we call full functional dependency). A) First B) Fourth C) Third D) Second

D) Second

All of the following are guidelines for choosing indexes for relational databases except ________. A) Specify a unique index for the primary key of each file B) Specify an index for foreign keys C) Specify an index for nonkey fields D) Specify multiple keys for each table

D) Specify multiple keys for each table

Which relation is created with a composite primary key (which includes the primary key of the entity on which this weak entity depends) and nonkey attributes? A) Associative entity with additional key B) Super-type C) Regular entity D) Weak entity

D) Weak entity

one purpose of database design is struture thr data in stable structures, called normalized tables, that aren't like to change over time and have minimal____. A) Data B) Space C) Redundancy D) Columns

redundancy