Some experts said that a DBA needs to be able to control the

Some experts said that a DBA needs to be able to control the amount of space and other resources that users may consume by setting limits. Do you agree?

Solution

Yes, I agree with this statement. Because in DBA the amount of space that can be allocated for storage of a user\'s objects within the specified tablespace can be limited. In databases there are two types of tablespace allocations to a user, a allocation for a certain amount of disk space in the tablespace, specified in kilobytes or megabytes and another allocation for an unlimited amount of disk space in the tablespace. The main reason to allocating space is to prevent a user\'s objects from consuming too much space in a tablespace.