Interested to Buy Any Domain ? << Click Here >> for more details...
what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 28122 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 new features of teradata?
What is the primary index in teradata?
What are normalization, first normal form, second normal form and third normal form?
If RDBMS is halted what will you do ?
How you will check the version of teradata?
What are aggregate tables? How do you design them using teradata?
Highlight the limitations of TPUMP Utility.
How would you load a very large file in teradata in general?
what are the day to day activities of teradata DBA ?
What are some commonly used bteq scripts?
What do you mean by ttu in teradata?
What is meant by a Virtual Disk?
What is a node in teradata?
What happens when a node suffers a downfall?
Highlight all the modes that are present under Confidence Level.
