Interested to Buy Any Domain ? << Click Here >> for more details...
what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 28031 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 |
Explain the term 'columns' related to relational database management system?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is stored procedure in teradata?
how many modules are there in telecome domain?how to explain the architecture?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Is multi insert ansi standard?
What are some commonly used bteq scripts?
Explain and compare pros and cons of snow flake schemas?
What's the syntax of sub string?
How a Referential integrity is handled in Teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How to identify ppi columns?
Teradata 
