what are the roles and responsibilities of teradata DBA ?
Answer / 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 |
write lock is compatiable with which type of lock?
What are the functions performed by bynet?
what is identity columns in teradata
What is meant by a node?
Explain and compare pros and cons of snow flake schemas?
What is meant by a dispatcher?
what is meant by Hot amp?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
What do you mean by teradata intelliflex?
How do you Generate sequence at the time of Display?
How does indexing improve query performance?
In Teradata, what is the significance of UPSERT command?