Study
Homework Help
Writing
Blog
Pricing
Commerce and BusinessbackBusinessbackMISbackBusiness Driven TechnologybackPractice Set 2481back

Storing Organizational Information-databases

This question bank verified by Studydeets

Questions Bank

All Questions
Filter by:
Question 1
Free
Multiple Choice

Which of the following types of information can be found in a database?

Choose correct answer/s
A

Inventory

B

Transactions

C

Employees

D

All of these

Check answer
Question 2
Free
Multiple Choice

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

Choose correct answer/s
A

Entity

B

Logical view

C

Attribute

D

Physical view

Check answer
Question 3
Free
Multiple Choice

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

Choose correct answer/s
A

Entity

B

Logical view

C

Attribute

D

Physical view

Check answer
Question 4
Free
Multiple Choice

What are characteristics or properties of an entity called?

Choose correct answer/s
A

Attributes

B

Fields

C

Columns

D

All of these

Check answer
Question 5
Free
Multiple Choice

Why do relational databases use primary keys and foreign keys?

Choose correct answer/s
A

To create a database.

B

To create physical relationships.

C

To create logical relationships.

D

All of these.

Check answer
Question 6
Multiple Choice

What is a primary key?

Choose correct answer/s
A
A field (or group of fields) that uniquely identifies a given record 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.
To unlock the question
Question 7
Multiple Choice

What is a foreign key?

Choose correct answer/s
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.
To unlock the question
Question 8
Multiple Choice

All of the following are advantages of database-stored information except:

Choose correct answer/s
A
Increased flexibility
B
Increased performance
C
Increased information redundancy
D
Increased information integrity
To unlock the question
Question 9
Multiple Choice

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

Choose correct answer/s
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.
To unlock the question
Question 10
Multiple Choice

What is the physical view of information?

Choose correct answer/s
A
Deals with the physical storage of information on a storage device such as a hard disk.
B
Deals with the logical storage of information on a storage device such as a hard disk.
C
Focuses on how users logically access information to meet their particular business needs.
D
Focuses on how users physically access information to meet their particular business needs.
To unlock the question
Question 11
Multiple Choice

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

Choose correct answer/s
A
A database can support only one logical view.
B
A database can support many physical views.
C
A database can support many logical views.
D
A database can support up to three logical views.
To unlock the question
Question 12
Multiple Choice

What refers to how well a system can adapt to increased demands?

Choose correct answer/s
A
Scalability
B
Performance
C
Redundancy
D
Information integrity
To unlock the question
Question 13
Multiple Choice

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

Choose correct answer/s
A
Scalability
B
Performance
C
Redundancy
D
Information integrity
To unlock the question
Question 14
Multiple Choice

What is information redundancy?

Choose correct answer/s
A
Duplication of information.
B
Storing the same information in multiple places.
C
Storing duplicate information in multiple places.
D
All of these.
To unlock the question
Question 15
Multiple Choice

What is the primary problem with redundant information?

Choose correct answer/s
A
It is difficult to determine which values are the most current.
B
It is often inconsistent.
C
It is difficult to determine which values are the most accurate.
D
All of these.
To unlock the question
Question 16
Multiple Choice

Which of the following is true in regard to eliminating redundant information?

Choose correct answer/s
A
Uses additional hard disk space.
B
Makes performing information updates harder.
C
Improves information quality.
D
All of these.
To unlock the question
Question 17
Multiple Choice

What are the rules that help ensure the quality of information?

Choose correct answer/s
A
Information integrity
B
Integrity constraints
C
Relational integrity constraints
D
Business-critical integrity constraints
To unlock the question
Question 18
Multiple Choice

What are the rules that enforce basic and fundamental information-based constraints?

Choose correct answer/s
A
Information integrity
B
Integrity constraints
C
Business-critical integrity constraints
D
Relational integrity constraints
To unlock the question
Question 19
Multiple Choice

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

Choose correct answer/s
A
Relational-critical integrity constraint
B
Business integrity constraint
C
Critical constraint
D
Business-critical integrity constraint
To unlock the question
Question 20
Multiple Choice

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

Choose correct answer/s
A
Relational integrity constraint
B
Business-critical integrity constraint
C
Information-critical integrity constraint
D
None of these
To unlock the question