Database roles

Question 1

Database Appliation

Answer 1

A software that helps business users interact with database systems

Question 2

Database Administrator

Answer 2

Database Administrators keep the data safe, organized, and accessible for the people who need it.

Question 3

Authorization

Answer 3

Giving limited access to individual users to access specific data

Question 4

Rules

Answer 4

Database systems ensure data is consistent with structural and business rules

Question 5

Query Processor

Answer 5

query processor acts like a translator and guide, helping the database understand what you want and finding the best way to get it for you. Query optimization is like choosing the quickest route on a map to reach your destination faster.

Question 6

Storage Manager

Answer 6

It organizes, saves, and manages all the data so that it can be easily accessed when needed and safely stored for the long term. They use indexes as a shortcut that makes it quicker to find specific information in a database.

Question 7

Transaction Manager

Answer 7

acts like a safety guard, making sure that important multi-step actions happen completely and correctly or not at all.