Database Administrator:-Schema definition. -The DBA creates the original database schema by executing a set of data definition statements in the DDL.
-Storage structure and access-method definition.To define the storage structure and access methods.
- Schema and physical-organization modification.--The DBA carries out changes to the schema and physical organization to reflect the changing needs of the organization, or to alter the physical organization to improve performance.
-Granting of authorization for data access--
-Routine maintenance-
-To grant authorization for data access
-To specify integrity constraints
-Storage structure and access-method definition.To define the storage structure and access methods.
- Schema and physical-organization modification.--The DBA carries out changes to the schema and physical organization to reflect the changing needs of the organization, or to alter the physical organization to improve performance.
-Granting of authorization for data access--
-Routine maintenance-
-To grant authorization for data access
-To specify integrity constraints
No comments:
Post a Comment