what are the roles and responsibilities of teradata DBA ?
Answer Posted / prakash.k
Following are the different functions which a DBA can perform:
1. User Management – Creation and managing Users, Databases, Roles, Profiles and Accounts.
2. Space Allocation – Assigning Permanent Space, Spool Space and Temporary Space.
3. Access of Database Objects – Granting and Revoking Access Rights on different database objects.
4. Security Control – Handling logon and logoff rules for Users.
5. System Maintenance – Specification of system defaults, restart etc.
6. System Performance – Use of Performance Monitor(PMON), Priority Scheduler and Job Scheduling.
7. Resource Monitoring – Database Query Log(DBQL) and Access Logging.
8. Data Archives, Restores and Recovery – ARC Utility and Permanent Journals.
Is This Answer Correct ? | 25 Yes | 1 No |
Post New Answer View All Answers
What's the difference between timestamp (0) and timestamp (6)?
How do you do backup and recovery in teradata?
In Teradata, what is the significance of UPSERT command?
What are the 5 phases in a multiload utility?
Define views in teradata with syntax.
What are some primary characteristics of teradata?
What are some commonly used bteq scripts?
What is oltp?
Why managing the data is important?
What is real time and near real time data warehousing?
How is the teradata different from oracle?
Explain teradata architecture?
What is inner join and outer join?
What is a node in teradata? Explain
What are the main components of teradata system?