volume_mute
Classify the following tasks as either the responsibility of the DBA or a function of the DBMS
publish date: 2025/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)
