Filters
Question type

Study Flashcards

Data redundancy can occur due to lack of data integrity.

A) True
B) False

Correct Answer

verifed

verified

The duties of a database administrator include the determining of which people have access to what kinds of data in the database, referred to as _____ rights.

Correct Answer

verifed

verified

In a(n) _____ database, not all the data in a database is physically located in one place.

Correct Answer

verifed

verified

These databases store not only data but also instructions to manipulate the data.


A) Hierarchical
B) Network
C) Object-oriented
D) Multidimensional

E) A) and C)
F) A) and D)

Correct Answer

verifed

verified

Explain the components of data organization.

Correct Answer

verifed

verified

In the logical view, data is organized i...

View Answer

Information collected by an organization from a variety of external and internal databases is stored in this special type of database.


A) Data warehouse
B) Commercial database
C) Company database
D) Company warehouse

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

This occurs when transactions are collected and processed all at once.


A) Batch processing
B) Group processing
C) Real-time processing
D) Consignment processing

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

The logical arrangement of data in a database is called the database model.

A) True
B) False

Correct Answer

verifed

verified

Which view of data deals with how the data is actually formatted and located?


A) Physical view
B) Logical view
C) Information view
D) Technical view

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

The analysis tools associated with the data manipulation subsystem that support querying databases include _____ and structured query languages (SQL).

Correct Answer

verifed

verified

What are the advantages of having databases?

Correct Answer

verifed

verified

For both individuals and organizations, ...

View Answer

List and describe the five basic DBMS subsystems.

Correct Answer

verifed

verified

DBMS software is made up of five parts o...

View Answer

This commercial database offers news and information on legal, public records, and business issues.


A) CSi
B) Dialog Information Services
C) Dow Jones Interactive Publishing
D) LexisNexis

E) None of the above
F) All of the above

Correct Answer

verifed

verified

Having several instances of the same data is called data:


A) repetition
B) duplication
C) doubling
D) redundancy

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

Data _____ ensures that there aren't multiple sources of the same data.

Correct Answer

verifed

verified

The data and the DBMS are stored either on the user's hard-disk drive or on a LAN file server in these databases.


A) Company
B) Individual
C) Commercial
D) Web

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

Which of the following is not an advantage of using a database?


A) Security
B) Reliability
C) Sharing
D) Data Integrity

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

This subsystem defines the logical structure of the database, such as a field names and data types.


A) Data manipulation
B) Application generation
C) Data administration
D) Data definition

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

Explain commercial databases with examples.

Correct Answer

verifed

verified

A commercial database is generally an en...

View Answer

Database tables can be related or connected to other tables by common key fields.

A) True
B) False

Correct Answer

verifed

verified

Showing 21 - 40 of 78

Related Exams

Show Answer