15)
A more rigorous definition of a databaseis a collection of data
organized to serve many applications efficiently by centralizing the data and
controlling redundant data.
16)
A DBMS reduces data redundancy and inconsistency by maximizing isolated files
in which the same data are repeated.
17)
Microsoft Access is a relational DBMS for desktop systems.
18)
Microsoft SQL Server are relational DBMS for large mainframes and mid-range
computers.
19)
Oracle Database Lite is a DBMS for small, handheld computing devices.
20)
Rows are commonly referred to as records or, in technical terms, as tulips.
21)
Every table in a relational database has one field designated as it key field.
22)
A DBMS separates the logical and physical views of the data.
23)
The selectoperation creates a subset consisting of columns in a table,
permitting the user to create new tables that contain only the information
required.
24)
DBMS designed for organizing structured data into rows and columns are not well
suited to handling graphics-based or multimedia applications.
25)
An object-oriented DBMSstores the data and procedures that act on those
data as objects that can be automatically retrieved and shared.
26)
Most DBMS have a specialized language called a data manipulation language that
is used to add, change, delete, and retrieve the data in the database.
27)
The most prominent data manipulation language today is Structured Query
Language (SQL).
28)
Every record in a file should contain at least one key field.