Free Test Database Users and Adm... – Databas...

Q1: Who is responsible for the overall management of the database system?

A. Database Administrator (DBA) B. End User C. Application Programmer D. System Analyst

Q2: Which user interacts with the database through queries?

A. End User B. Database Administrator C. System Administrator D. Designer

Q3: Who is responsible for designing the database schema?

A. Database Designer B. Database Administrator C. End User D. Application Programmer

Q4: Which user writes application programs to interact with the database?

A. Application Programmer B. End User C. DBA D. Designer

Q5: Who controls access permissions and security in a database?

A. Database Administrator B. End User C. Designer D. Application Programmer

Q6: Which user typically uses the database for day-to-day operations?

A. End User B. DBA C. System Administrator D. Database Designer

Q7: What type of user is responsible for maintaining and optimizing the database?

A. Database Administrator B. End User C. Application Programmer D. Designer

Q8: Which user category includes people who query the database using standard query languages?

A. Naive Users B. Sophisticated Users C. Application Programmers D. DBAs

Q9: Sophisticated users typically?

A. Write complex queries and use database applications B. Only read reports C. Administer the database D. Design database schema

Q10: Which user is responsible for backup and recovery?

A. Database Administrator B. End User C. System Analyst D. Designer

Q11: Which user interacts with the database through application programs?

A. Sophisticated Users B. Naive Users C. Application Programmers D. DBA

Q12: Who is responsible for enforcing data integrity?

A. Database Administrator B. End User C. Designer D. Application Programmer

Q13: Which user defines the logical and physical design of the database?

A. Database Designer B. DBA C. End User D. Application Programmer

Q14: Who can be classified as naive users?

A. Users who use canned transactions B. Users who write complex queries C. DBAs D. Application Programmers

Q15: Which user is involved in database tuning?

A. Database Administrator B. Designer C. End User D. Programmer

Q16: Who typically tests the database system?

A. Application Programmer B. DBA C. End User D. Designer

Q17: Who provides requirements and feedback for database design?

A. End Users B. DBA C. Programmers D. Analysts

Q18: Which user group often creates reports from database data?

A. Sophisticated Users B. Naive Users C. DBA D. Designers

Q19: Who monitors database performance?

A. Database Administrator B. Application Programmer C. End User D. Designer

Q20: Which user is responsible for writing application-level security?