Multiple choice , select a correct answer:
1.File-processing systems have important limitations:
a.Data is separated and isolated.
b. Data is often duplicated.
c.Application programs are dependent on file formats.
d. All of the above.
e. None of the above.
Answer: d.
2. Database-processing programs:
a. Call the DBMS to access the stored data.
b. Cannot be used by more than one person.
c. Require at least one dedicated workstation.
d. Present problems with storage space.
Answer: a
3. In a database system, all the application data is stored in a single facility called the:
a.DBMS b. CPU c. Hard drive d.Database
Answer: d
4.The features and functions of a DBMS can be divided into three parts:
a. Fields, records, and files.
b. RAM, ROM, and floppy diskettes.
c. The design tools subsystem, the run-time subsystem, and the DBMS engine.
d. The file-processing subsystem, the transaction-processing subsystem, and the LAN.
Answer: c.
5.In order to build an effective database and related applications, the development team must:
a. Become thoroughly familiar with the user's model of their business activities.
b. Build a data model that identifies the things to be stored in the database.
c. Define the structure of the things to be stored in the database and the relationships among
them.
d. All of the above.
e. None of the above.
Answer: d
6. Normalization:
a. Is used because not all relations are equal.
Docsity.com
