EXAM*II*7

All of the following are advantages of database-stored information except: Increased performance Increased flexibility Increased information integrity Increased information redundancy

Why do relational databases use primary keys and foreign keys? All of these. To create physical relationships. To create logical relationships. To create a database.

What type of website is best to build for a general informational website with static information? Static website Data-driven website All of these Relational website

Which of the following is a valid type of integrity constraint? Critical constraint Relational-critical integrity constraint Business-critical integrity constraint Business integrity constraint

What type of integrity constraint does not allow someone to create an order for a nonexistent customer? Information-critical integrity constraint None of these Business-critical integrity constraint Relational integrity constraint

Which of the following measures how quickly a system performs a certain process or transaction? Performance Scalability Redundancy Information integrity

What is an integration? Takes information entered into a given system and sends it to the database. Allows separate systems to communicate directly with each other. Takes information entered into a given system and sends it to the DBMS. Takes information entered into a given system and sends it to other processes.

What is the physical view of information? Deals with the logical storage of information on a storage device such as a hard disk. Deals with the physical storage of information on a storage device such as a hard disk. Focuses on how users logically access information to meet their particular business needs. Focuses on how users physically access information to meet their particular business needs.

What refers to how well a system can adapt to increased demands? Performance Information integrity Redundancy Scalability

What is a forward integration? Takes information entered into a given system and sends it to the DBMS. Takes information entered into a given system and sends it automatically to all downstream systems and processes. Takes information entered into a given system and sends it to the application-generation component. Takes information entered into a given system and sends it automatically to all upstream systems and processes.

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? Attribute Logical view Entity Physical view

Which of the following is not an advantage of building a data-driven website? Minimizes human error. Minimizes or reduces efficiency. Cuts production and update costs. Improves or maximizes stability.

What is a foreign key? A field (or group of fields) that uniquely identifies a given entity in a table. A field (or group of fields) that uniquely identifies a given attribute in a table. Characteristics or properties of an entity. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

What are the rules that help ensure the quality of information? Information integrity Business-critical integrity constraints Integrity constraints Relational integrity constraints

What type of website is best to build for a continually changing information, including press releases, new product information, and updated pricing? All of these Static website Data-driven website Relational website

Which of the following is incorrect in reference to a database? Users can access different views of information. Information is accessed by logical structure. Information is accessed by physical structure. Can be relational or network.

What is information redundancy? Storing the same information in multiple places. Storing duplicate information in multiple places. All of these. Duplication of information.

What is a backward integration? Takes information entered into a given system and sends it to the DBMS. Takes information entered into a given system and sends it automatically to all upstream systems and processes. Takes information entered into a given system and sends it automatically to all downstream systems and processes. Takes information entered into a given system and sends it to the application-generation component.

What is the primary problem with redundant information? It is difficult to determine which values are the most accurate. It is often inconsistent. All of these. It is difficult to determine which values are the most current.

What is a primary key? A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. A field (or group of fields) that uniquely identifies a given attribute in a table. A field (or group of fields) that uniquely identifies a given record in a table. Characteristics or properties of an entity.

Which of the following is true in regard to eliminating redundant information? Uses additional hard disk space. Makes performing information updates harder Improves information quality. All of these.

What are the rules that enforce basic and fundamental information-based constraints? Relational integrity constraints Information integrity Business-critical integrity constraints Integrity constraints

Which of the following is correct in reference to a database? A database can support many physical views. A database can support up to three logical views. A database can support only one logical view. A database can support many logical views.