Interested to Buy Any Domain ? << Click Here >> for more details...
what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 28141 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Which is faster fastload or multiload?
Why MLOAD needs Work Tables?
What are the steps involved after the disk manager passes the request?
what is identity columns in teradata
What are the various indexes in teradata? How to use them?
What is upsert statement in teradata?
What are the steps to create a data model?
Can you connect multiload from ab initio?
What is bteq utility in teradata?
How to select first n records in teradata?
What is the difference between teradata and basic rdbms?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Teradata 
