volume_mute

Classify the following tasks as either the responsibility of the DBA or a function of the DBMS

publish date2025/09/07 21:56:30.918128 UTC

drag and drop the selected option to the right place

Correct Answer

(1) Creating user accounts and specifying restrictions,Responsibility of the DBA
(2) Automatically enforcing access restrictions once they are defined,Function of the DBMS
(3) Allowing parametric users to access the database only through predefined canned transactions,Function of the DBMS

Explanation

The DBA uses the security subsystem to create accounts and to specify account restrictions. DBMS should enforce these restrictions automatically, which includes controlling access methods like canned transactions.

Reference

Fundamentals of database systems (7th edition)


Quizzes you can take where this question appears