Access privilege & Security

Who is responsible for formulating database policies and enforcing them?

• Database Users

• Database Administrator (DBA)

• Management Team

What is the primary function of the DBA regarding database security?

• Designing user interfaces

• Developing marketing strategies

• Monitoring database usage for potential security violations

What is an access privilege policy?

• A set of database performance rules

• Documentation of database authorization rules

• Guidelines for data backup procedures

Which SQL statement is used to define a user's access privileges?

• REVOKE

• SELECT

• GRANT

What does the REVOKE statement in SQL do?

• Grants privileges to a user

• Removes privileges from a user

• Deletes data from the database

"Preventing unauthorized access to a database" is about ____________.

• Security

• Backup

• Encryption

Who is considered as an unauthorized user?

• A DBA who modifies user privileges

• A manager overseeing the database policy

• A user who has no right to access the database

What must a DBA obtain before implementing database policies and procedures?

• Approval from users

• Authorization from management

• Support from system analysts

What should the DBA do after creating a database policy?

• Submit the policy to auditors

• Archive the policy in a secure folder

• Distribute the policy to all authorized users

What might a DBA do if there are limitations in existing database security features?

• Ignore the issue

• Develop or purchase special security programs

• Remove user privileges