Interested to Buy Any Domain ? << Click Here >> for more details...
what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 28128 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain the term 'tables' related to relational database management system?
What do you mean by tpt in teradata?
List out all forms of LOCKS that are available in Teradata.
What is a level of granularity of a fact table?
What are the multiload utility limitations?
Explain fastload in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the string manipulation operators and functions associated with teradata?
What is meant by a Least Cost Plan?
How does hashing happens in teradata?
What are different table types used in teradata?
What is partitioned primary index (ppi)?
What are the functions of a teradata dba?
What is the purpose of joins in teradata?
