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 |
Why managing the data is important?
How to load specific no.of records using bteq, or fastload,or multiload
What is the multi-insert?
What are the differences between TerdataV2R5 and V12 Versions please??
What are the 5 phases in a multiload utility?
How to copy teradata scripts from ur remote desktop to server machine?
Does SDLC changes when you use Teradata instead of Oracle?
What is the difference between teradata and basic rdbms?
What are normalization, first normal form, second normal form and third normal form?
what do you mean by INMOD Routines and OUTMODE Routines ?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
What is the primary index in teradata?