Question 1

Which of the following is a valid type of integrity constraint?

Accepted Answer

A)  Relational-critical integrity constraint 
B)  Business integrity constraint 
C)  Critical constraint 
D)  Business-critical integrity constraint 
A)  Relational-critical integrity constraint 
B)  Business integrity constraint 
C)  Critical constraint 
D)  Business-critical integrity constraint D

Question 2

Evaluate the advantages of the relational database model.

Accepted Answer

Database advantages from a business perspective include increased flexibility,increased scalability and performance,reduced information redundancy,increased information integrity (quality),and increased information security.

Question 3

What is an integration?

Accepted Answer

A)  Allows separate systems to communicate directly with each other. 
B)  Takes information entered into a given system and sends it to the database. 
C)  Takes information entered into a given system and sends it to other processes. 
D)  Takes information entered into a given system and sends it to the DBMS. 
A)  Allows separate systems to communicate directly with each other. 
B)  Takes information entered into a given system and sends it to the database. 
C)  Takes information entered into a given system and sends it to other processes. 
D)  Takes information entered into a given system and sends it to the DBMS. A

Question 4

Which of the following is not an advantage of building a data-driven website?

Accepted Answer

A)  Minimizes human error. 
B)  Cuts production and update costs. 
C)  Improves or maximizes stability. 
D)  Minimizes or reduces efficiency. 
A)  Minimizes human error. 
B)  Cuts production and update costs. 
C)  Improves or maximizes stability. 
D)  Minimizes or reduces efficiency.

Question 5

What are characteristics or properties of an entity called?

Accepted Answer

A)  Attributes 
B)  Fields 
C)  Columns 
D)  All of these 
A)  Attributes 
B)  Fields 
C)  Columns 
D)  All of these

Question 6

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Accepted Answer

A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  None of these 
A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  None of these

Question 7

Describe the role and purpose of a database management system.

Accepted Answer

A database management system (DBMS)is so

Question 8

A _______________ key is a field that uniquely identifies a given record in a table.

Accepted Answer

The answer of A _______________ key is a field that...

Question 9

What is a foreign key?

Accepted Answer

A)  A field (or group of fields) that uniquely identifies a given entity in a table. 
B)  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. 
C)  Characteristics or properties of an entity. 
D)  A field (or group of fields) that uniquely identifies a given attribute in a table. 
A)  A field (or group of fields) that uniquely identifies a given entity in a table. 
B)  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. 
C)  Characteristics or properties of an entity. 
D)  A field (or group of fields) that uniquely identifies a given attribute in a table.

Question 10

A(n)___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

Accepted Answer

The answer of A(n)___________ key in the relational database model...

Question 11

Which of the following is incorrect in reference to a database?

Accepted Answer

A)  Can be relational or network. 
B)  Information is accessed by logical structure. 
C)  Information is accessed by physical structure. 
D)  Users can access different views of information. 
A)  Can be relational or network. 
B)  Information is accessed by logical structure. 
C)  Information is accessed by physical structure. 
D)  Users can access different views of information.

Question 12

The _________ view of information deals with the physical storage of information on a storage device such as a hard disk.

Accepted Answer

The answer of The _________ view of information deals with...

Question 13

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 14

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A)  To create a database. 
B)  To create physical relationships. 
C)  To create logical relationships. 
D)  All of these. 
A)  To create a database. 
B)  To create physical relationships. 
C)  To create logical relationships. 
D)  All of these.

Question 15

Which of the following measures how quickly a system performs a certain process or transaction?

Accepted Answer

A)  Scalability 
B)  Performance 
C)  Redundancy 
D)  Information integrity 
A)  Scalability 
B)  Performance 
C)  Redundancy 
D)  Information integrity

Question 16

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 17

A foreign key is a field (or group of fields)that uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 18

The ________ view of information focuses on how users logically access information to meet their particular business needs.

Accepted Answer

The answer of The ________ view of information focuses on...

Question 19

In the relational database model,what is a characteristic or property of an entity?

Accepted Answer

A)  Entity 
B)  Logical view 
C)  Attribute 
D)  Physical view 
A)  Entity 
B)  Logical view 
C)  Attribute 
D)  Physical view

Question 20

What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?

Accepted Answer

A)  Customer-driven website 
B)  Data-driven website 
C)  Customer-driven database 
D)  Data-driven database 
A)  Customer-driven website 
B)  Data-driven website 
C)  Customer-driven database 
D)  Data-driven database

Exam 7: Storing Organizational Information-Databases

Which of the following is a valid type of integrity constraint?

Evaluate the advantages of the relational database model.

What is an integration?

Which of the following is not an advantage of building a data-driven website?

What are characteristics or properties of an entity called?

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Describe the role and purpose of a database management system.

A _______________ key is a field that uniquely identifies a given record in a table.

What is a foreign key?

A(n)___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

Which of the following is incorrect in reference to a database?

The _________ view of information deals with the physical storage of information on a storage device such as a hard disk.

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Why do relational databases use primary keys and foreign keys?

Which of the following measures how quickly a system performs a certain process or transaction?

One of the advantages found in a relational database is increased information redundancy.

A foreign key is a field (or group of fields)that uniquely identifies a given record in a table.

The ________ view of information focuses on how users logically access information to meet their particular business needs.

In the relational database model,what is a characteristic or property of an entity?

What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing Organizational Information

Accessing Organizational Information-Data Warehouse

Enabling the Organization-Decision Making

Extending the Organization-Supply Chain Management

Building a Customer-Centric Organization-Customer Relationship Management

Integrating the Organization From End to End-Enterprise Resource Planning

Creating Innovative Organizations

Ebusiness

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

Developing a 21st-Century Organization

Business Basics

Business Process

Hardware and Software Basics

Mis Infrastructures

Networks and Telecommunications

Information Security

Ethics

Operations Management

Sustainable Mis Infrastructures

Business Intelligence

Global Information Systems

Global Trends

Filters