Exam 11: Databases

List and describe the five basic DBMS subsystems.

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

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.

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

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

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

Explain the components of data organization.

Explain commercial databases with examples.

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

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

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

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

Data redundancy can occur due to lack of data integrity.

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

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

What are the advantages of having databases?

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

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

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

Having several instances of the same data is called data: