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 |
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
If the table does not have duplicates then which utility you can suggest to load the data ?
What do you mean by tpt in teradata?
What is meant by a Least Cost Plan?
what is single value and Multivalue ?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
What is a sparse index?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
What do you mean by ttu in teradata?
What is a node in teradata? Explain
What is the use of stored procedures in teradata?
how to load or extract the error table data ?