Interested to Buy Any Domain ? << Click Here >> for more details...
what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 28224 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
What do you mean by teradata sql assistant?
What is the purpose of joins in teradata and what are the available join types?
What is logical data model?
What is teradata? What are some primary characteristics of teradata?
Differentiate database data and data warehouse data?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is called partitioned primary index (ppi)?
Explain fallback in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
If RDBMS is halted what will you do ?
When tpump is used instead of multiload?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the use of teradata system software?
