Question

1. Controls redundant data

2. Restricts unauthorized access to data; only DBA staff uses it.
3. Provides indexes for efficient query processing
a. Database normalization
b. Database security
c. Database optimization
d. Database management

Answer 1

The question asks to match database functions with the correct terminology. Database normalization controls redundant data, database security restricts unauthorized access, and database optimization provides indexes for efficient query processing.

Step-by-step explanation:

The question seems to be about identifying the functions related to database systems and matching them with their correct terminology. The functions mentioned are:

• Controls redundant data
• Restricts unauthorized access to data; only DBA staff uses it.
• Provides indexes for efficient query processing

The correct terminology for these functions are as follows:

1. Database normalization is the process that controls redundant data within the database.
2. Database security involves measures that restrict unauthorized access to data, ensuring it's only used by authorized personnel such as DBA staff.
3. Database optimization includes providing indexes which help in efficient query processing. database optimization (option c).Therefore, the function that controls redundant data is database normalization (option a), the function that restricts unauthorized access is database security (option b), and the provision of indexes for efficient query processing is part of