Interested to Buy Any Domain ? << Click Here >> for more details...
what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 28008 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 parallel data extension in teradata?
What are normalization, first normal form, second normal form and third normal form?
What do you mean by tpt in teradata?
What are the design features involved in teradata?
Did you write stored procedures in teradata?
Explain amp in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is primary index and secondary index?
Explain the advantages of partitioned primary index in a query?
What is the maximum number of dml can be coded in a multiload script?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is the difference between global temporary tables and volatile temporary tables?
Explain the types of join supports by teradata?
What are the multiload utility limitations?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
